MySQL Bugs: #27845: Mult-master replication

Bug #27845	Mult-master replication
Submitted:	16 Apr 2007 9:42	Modified:	24 Jan 2018 17:33
Reporter:	mingfei hua	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Replication	Severity:	S4 (Feature request)
Version:	ALL	OS:	Any
Assigned to:	Assigned Account	CPU Architecture:	Any

Description:
   Is there any plan for multi-master replication in future versions, or this function is exist already. Means of "multi-master" here is one mysql server have more than one master at same time,not circul repliction.

How to repeat:
NULL

Thank you for the report.

This functionality is not implemented. But read about MySQL Cluster at http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster.html May be it successes your needs?

I reclassify the report to "Feature request"

Thanks for your good suggestion. 
 We did some test for NDB before,found that it is not very stable and the performance improvement is not very obvious. So we have plan to use NDB in our productive ENV,we'll continue to test the new function and support mysql.
  Now,we want to use mysql replication for dual ways data sync between two sites,the function is  the basic of our site failover project. We use circle replication in primary sites,and make a tool run as daemon to monitor replication status for automatic failover.Above is the structure of primary site,the same in standy  site. The problem is every mysql server have one replication master in his own site,how we use mysql replication to syn data between sites. First ,we want to use some other ETL tools to sync data between sites, if mysql replication can do it ,it is our first choice.
    Any good suggestion for me,very very very appreciate.

Bug #31182 was marked as duplicate of this one.

Many thanks for writing a feature request.

You can do multi-master replication by just configure master as slave and vice versa. You have to be careful with auto_increment and some other stuff. In practise often one master is configured to use odd auto_increment numbers and the other even numbers. By using increment_start=1 for first master and 2 for second master and increment_increment=2.

More informations you will find here: http://dev.mysql.com/doc/refman/5.1/en/replication-features-auto-increment.html

Also we offer multi-master solutions for cluster. Just read here:

http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-replication-multi-master.html
http://dev.mysql.com/doc/refman/6.0/en/replication-solutions-multi-master-upgrade.html

I will close this feature request now because I think it is fixed.

My requirement is : Mysql "A" will be the slave of Mysql "B" and Mysql "C" at the same time. other words, "A" has two master "B" and "c",this feature has realized in cluster env,but not in common env.

Many thanks for your feedback. Now I understand what you want to have. We will discuss this.

Ref bug #35125

Multi-source replication was released in MySQL 5.7, which seems to address
this request.

Thanks for the feature request.