MariaDB Master-Master the way to go? Failover advice

Hi all,

I have an application that does not support an automatic secondary SQL server to try, so I would like to use MariaDB replication. I would like to do something along these lines:

2 databases - Master - Slave.

1 Floating IP through Linode failover.

The server that has the floating IP must always be the master, and the server that doesn't have the floating IP be the slave. e.g. say the master fails, IP is switched to the slave db, mysql starts listening on that interface and now acts as a master. In the meantime, master (which should now be a slave) will come back up. Then, when the new master fails at some point, IP's are switched again and the original master becomes master once again, and the other node switches back to slave once it recovers and sees it no longer has the floating IP.

Is this a good way of doing things? Is it doable? If anyone has pointers for the tools I will need to implement it or point to a tutorial that'd be great. :)


0 Replies


Please enter an answer

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct