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.
This would be a really helpful feature. I hope ploi gets it soon :)
Any idea on a timescale for this?
I assume you're looking at using Galera?
How valid is this item to this day? Is this still wanted? Let me know! (And if you have a use-case let me know as well!)
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
This would be awesome, being able to at least have an atomic replica offsite.
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.