Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 634
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

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