Bug #72982 Multi-source replication with MySQL 5.7.4
Submitted: 12 Jun 2014 8:05 Modified: 12 Jun 2014 10:23
Reporter: Support ICIL Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Replication Severity:S1 (Critical)
Version:5.7.4 OS:Linux (ubutu12.04)
Assigned to: CPU Architecture:Any
Tags: No documents about how to set the slave replicate to multi-masters

[12 Jun 2014 8:05] Support ICIL
Description:
I am doing the testing of replication with multi-master to one slave.
I have installed three MySQL servers with mysql-5.7.4-m14-linux-glibc2.5-x86_64.tar.gz.  I have set gtid-mode=on for replication.

From the "set up replication" document, there's no instruction about how to set the slave to replicate with the two master servers at the same time.
Some one reported that it can use MySQL5.7.2 to achive replication with multi-master to one slave.
The setting on slave server as below. But it did not work on MySQL 5.7.4???

mysql> CHANGE MASTER TO
    -> MASTER_HOST="10.150.2.100",
    -> MASTER_USER="replM2",
    -> MASTER_PASSWORD="password",
    -> MASTER_PORT=3306 for CHANNEL="master2";
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'for CHANNEL="master2"' at line 5

How to repeat:
On a server with MySQL 5.7.4 and run the command like below.
mysql> CHANGE MASTER TO
    -> MASTER_HOST="10.150.2.100",
    -> MASTER_USER="replM2",
    -> MASTER_PASSWORD="password",
    -> MASTER_PORT=3306 for CHANNEL="master2";
[12 Jun 2014 10:06] MySQL Verification Team
Thank you for your report.
As of now this is available in labs only, please try out the binaries available in labs for multi source replication. 

http://labs.mysql.com/

Look for MySQL Multi-Source Replication option and download..

mysql-5.7.2-labs-multi-src-rep-linux-glibc2.5-x86_64.tar.gz	5.7.2	2013-09-18	linux-glibc2.5-x86_64	309.9 M	6527b3b5af296d85e6cc4eff379ac20e
[12 Jun 2014 10:16] Support ICIL
Thanks for your reply.
Then I'll look forward to the new version MySQL5.7.4 of multi-source replication.