hello guys, i was just curious to know that wether can i add up two or more databases to a single nextcloud instance to distribute data loads between them equally as the databases that i have hosted have fixed capacity
note: databases are from 2 different hostes.
No, not like that. There is an option to add read-only replicas of the main database. We sometimes had the question with multi-server configuration (Help needed to setup a NC14 cluster - #17 by Finalls), which is interesting for real high-volume setups where a single server is not enough.
in such cases, they might restrict the number of queries per minute and stuff like that, so the overall performance in the end is not great.
Also the size is not evenly spread over tables, so you might end up with a table that cannot be managed by one database alone.
i think its my mistake that i didn’t clear the scenario…
actually i am tring to host a nextcloud server on my hosting (a shared hosting), but the mysql database provided by my hosting has limited capacity of 1024MB or 1GB per database but i can host unlimited databases with no storage capacity limits in total.
so for shared hosting mostly people use sqllite for setup as it is disk-based and does not come with this capacity limit,
i was searching a way to bypass this limit, the best idea i had in my mind is that i can cluster mysql databases, but then problem arises that shared hosting dosent give me root to install mysqlcluster, so i was tryin to figure out a way that how can i host multiple databases and connect them together to form a single database…
i also had and idea in mind that the server can run check on all linked databases one by one but still ideation and implementation are two different things…
any ideas for this problem?
I don’t know if that is so trivial. As I said, what do you do when the oc_filecache table is larger than 1 GB? Also for each connection, you need to create multiple connections to the databases. You can try to implement things yourself, Nextcloud is open source.
In general, shared hosting is very limited and in some cases difficult to run Nextcloud (limits in the php environment, limits on the database size/access). In such cases, it is often better to get a virtual server for little money.
This topic was automatically closed 8 days after the last reply. New replies are no longer allowed.