Mysql Master-master replication

[Mysql D]

Hi all,

We have a project to have mysql server setup with replication for php application. Since I dont have much experience on mysql, looking for some help to make the workable solution for our requeriment.

Our main concern is having high availability and to distribute load across servers 2 instances). So after reviewing documentation on MYSQL cluster and replication, we have decided to go with Master-master replication.

I was able to successfully setup master-master replication. But now I'm looking to see if it possible to have read/writes split across the master-master.

I'm looking to have the below for MySQL 5.7 on Ubuntu 16.0.4:

Master-Master replication

Master1 - handle writes/reads
master2 - will be for read-only/reporting

And if Master1 dies, need to have applications automatically connected to master2 (for both read/writes)

In short
Master1 - Active for Read and Writes
Master2 - Active for Reads.

So need to know the best method to monitor and configure automatic failover or by using any proxy to monitor active master for read/write or to handle on Applicaiton connection string?

I had gone through lots of documentation on Galera/Tungsten and MMM Manager/HAproxy and MysqlProxy but was not able to decide as we are running out of time to test each.

So, any help would be really appreciated.


Thanks in advance.