Forum Stats

  • 3,780,689 Users
  • 2,254,426 Discussions


MySQL 5.6 Data Replication Syncronization Checker Between Servers (Master & Slave)

Mubashar Iftikhar
Mubashar Iftikhar Member Posts: 49
edited May 17, 2018 1:12AM in MySQL Community Space

Hi Everyone

I have one Master and Slave

OS : MySQL5.6 & RHEL 7.0

Replication Status : Running Fine

Everything working fine and correctly

    I want to check that the data is correctly replicated between servers (Master to Slave)

     and with the help of "mysqlrplsync", i execute this command

mysqlrplsync --master=repuser:[email protected]:3306 \ --slaves=repuser:[email protected]:3306,repuser:[email protected]:3306

but this command show that error

[[email protected] common]# mysqlrplsync --master=root:[email protected]:3306 \ --slaves=rpl:[email protected]:3306

WARNING: Using a password on the command line interface can be insecure.

Usage: mysqlrplsync --master=user:[email protected]:port --slaves=user:[email protected]:port \


mysqlrplsync: error: Option --discover-slaves-login or --slaves is required.

Note : Even i have tried by adding the database name in the above command

My this method to check Data synchronization is correct ?

If not then can you please guide me how to perform Synchronization of Data Step by Step ?

Best Regards

Mubashar Iftikhar

Mubashar Iftikhar