It would be great if we could setup database servers as read write replicas from the panel.
This, please! I am in the process of trying to set this up and it seems unnecessarily long and complicated. Manually configuring the master and replicas, generating ssl certs etc. Would be amazing to have a quick option to set a database as a master and then select the replica servers for replication and have it magically work.
This could be a big win for Ploi. All of the current managed database options are super expensive for the hardware offered, this could position Ploi as an alternative to a fully managed database, and/or allow Ploi customers to more easily offer their own managed database options.
Any idea on a timescale for this?
I assume you're looking at using Galera?
If you run a serious business I think you want a managed db cluster covering your needs. So I think you do not want some kind of "unmanaged" solution via Ploi.
For testing and development I can imagine we could use it.
I see a couple of use cases in my situation
- to have a hot swappable recovery instance of the DB
- in case of a master-master replica: to easily scale up an instance, while the other one keeps functioning
- to easily scale up the performance of the db by adding clients
- to have db instances in mulitple regions, to have a db instance nearby the code server
If this is added to Ploi we will have the ability to save a lot of money!
Another use for this would be to have a read only replica on another server that could be promoted to the master in case the main server goes down. So in my case i have multiple vpses that have a main duty (database, main site, api sever) but also serve as a backup in case some thing goes wrong with one of the other servers, so services can continue while a replacement is provisioned.