[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 633
  • Last Modified:

MySQL Implement two way Replication

What steps are involved in settting up two way replication or dual master replication on MySQL.
Kindly highlight methods to overcome conflict in indexes while restoring data after a failure.
0
npglobal
Asked:
npglobal
1 Solution
 
Michael WorshamInfrastructure / Solutions ArchitectCommented:
MySQL's master-master configuration should not be confused with multi-master, where all master nodes can receive changes, and updates. These configurations require complex conflict resolution and are not typical.

Dual-master MySQL replication setup
http://lug.wsu.edu/node/545

MySQL Master Master Replication Tutorial
http://www.howtoforge.com/mysql_master_master_replication

MySQL Master-Master-Slave(s) Database Replication
http://webaugur.com/dave/blogger/2009/04/mysql-master-master-slaves-database.html
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now