[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

MySQL Implement two way Replication

Posted on 2009-05-15
2
Medium Priority
?
627 Views
Last Modified: 2012-05-07
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
Comment
Question by:npglobal
1 Comment
 
LVL 29

Accepted Solution

by:
Michael Worsham earned 2000 total points
ID: 24397923
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

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
Recursive SQL is one of the most fascinating and powerful and yet dangerous feature offered in many modern databases today using a Common Table Expression (CTE) first introduced in the ANSI SQL 99 standard. The first implementations of CTE began ap…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question