Solved

MySQL Implement two way Replication

Posted on 2009-05-15
2
606 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
2 Comments
 
LVL 29

Accepted Solution

by:
Michael W earned 500 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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
query returning everything 11 87
Install MySQL 5.6 and PHP on Centos Linux 6 99
html input clean up 3 47
Need Distinct Value from Joined Tables in MSSQL 5 51
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
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…

912 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now