MySQL Forums
Forum List  »  Replication

Multi-source replication with MySQL 5.7.5
Posted by: shweta rao
Date: March 09, 2015 06:17AM

I am testing multi-master replication to one slave.
I have downloaded the MySQL Multi-Source Replication files from MYSQL Labs and set gtid-mode=on for replication. The masters are located on remote servers and I'm configuring slave in my local instance. JFI, I'm running a Windows 8 64-bit OS.

However, I am not able to set multiple channels using the below CHANGE MASTER TO statement for multi-source replication-

mysql> CHANGE MASTER TO
-> MASTER_HOST="hostname",
-> MASTER_USER="repluser",
-> MASTER_PASSWORD="password",
-> MASTER_PORT=3306 for CHANNEL="master1";
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="master1"' at line 5

Am I supposed to install the lab files in some way to make this work?

Thanks in advance.

Options: ReplyQuote


Subject
Views
Written By
Posted
Multi-source replication with MySQL 5.7.5
2374
March 09, 2015 06:17AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.