MySQL Failover on Two Azure Servers

Question

I am considering setup of two web servers in a single availability set on Azure and running a local copy of MySQL Server Community Edition on each server to save costs. The web applications on each would be identical.

I'm thinking a master/slave MySQL cluster would be the best option. So if machine 1 is the master and goes down, machine 2 can become the master or vice versa. I want to accomplish this cluster with just two machines for now but I see in the documentation the minimum system requirements are for 3 instances (2 x Data Nodes, 1 x App/Management Node)

Is there a good set of instructions for accomplishing this? (By good I mean easy to follow step-by-step sort of instructions).

Mmmmh.... dual master replication might be a better option? http://stackoverflow.com/questions/803649/mysql-dual-master — Adam, May 11 '15 at 02:42
master-master with haproxy on each instance to control database selection — pala_, May 11 '15 at 03:07

score 0 · Answer 1 · answered May 11 '15 at 03:35

0

I found a decent guide on Digital Ocean that may prove useful.

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

answered May 11 '15 at 03:35

Adam

4,590
10
51
84

MySQL Failover on Two Azure Servers

1 Answers1