What I do is MySQL+Nextcloud/Apache on a RPi and another Nextcloud instance on Apache on my desktop computer. Both the Apache instances are load balanced using keepalived. This gives me two things-
1. Good performance if my desktop Ubuntu is running.
2. When its not (happens when I reboot to Windows to play games), the RPi serves Nextcloud at a slower speed.