Managed MySQL FAQ
Reliability
How is high availability ensured on Managed Databases?
UpCloud Managed Databases work using the master/replica model to provide dependable high-availability. This means all writes are done on the master node, but you are free to query the read-only replicas for added performance. Single master node ensures consistent transaction handling which can otherwise become an issue with multi-master HA solutions.
DBs like PostgreSQL® and MySQL®, where there's a single primary node and several replica nodes, we give two different hostnames: one for the primary (which is write-capable), and one which contains all of the replicas (which are read-only). A DB client will randomly choose one of the IP addresses in the DNS A record for the replica, which will naturally spread the load across those nodes.
Do you promote a replica to primary automatically in case of a failure with the master node?
Can I take backups of the databases?
Are the backups encrypted at rest?
Operations
Is it possible to connect to the database using private networking?
Can the connections be restricted to specific IP addresses?
What is the maintenance window and what does it mean to me?
How are Managed Databases billed?
MySQL is a registered trademark of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.