master-master (Master-Master replication)

Master-Master Replication is used to replicate data from one MySQL database server (the master) to one or more MySQL database servers (the slaves). master-master replication uses master1 as master and master2 as slave both responding to client data queries. Any data modification or data update in one database are automatically replicated to the other machine and all other machines in the master-master set up. master-master replication offers Data Security, High Availability, Database Backup from Slave, Backup if one of the databases crashes and Failover Solution.