The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-15. For the latest, interactive version please visit https://mariadb.com/kb/.

Switch over at a database level

Is it possible to switch over an individual database?

For example, with the below scenario: - I have 3-server replication - Server contains multiple databases owned by different users

I'd like to manually switch over only one database, "MyDb1" as a failover test. The rest of the databases residing on the same MariaDB server should not be impacted. This is to minimize the impact to other databases for failover test exercise.

Is this possible by Standard Replication?

I'd be grateful for this information.

Answer Answered by Rhys Campbell in this comment.

https://www.digitalocean.com/community/tutorials/how-to-set-up-mysql-master-master-replication

Essentially both servers are slaves of each other. They can both accept writes that will be replicated to each other.

You need to be careful about not writing on both...

server1\db1 server2\db1

Or you'll end up with data issues.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.