Comments - Switch over at a database level
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.
You could probably just setup master->master replication to do this. As long as you're just writing in one database after the fail-over then it will work.
As long as you're just writing in one database after the fail-over
I don't think I understand what you mean by this.
Can you expand this a bit?
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.
Thanks, I see what you mean now. :)