Forum Stats

  • 3,817,211 Users
  • 2,259,290 Discussions
  • 7,893,699 Comments

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 \

                    [<db_name>[.<tbl_name>]]

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

Answers