Skip to Main Content

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

Mubashar IftikharApr 18 2018 — edited May 17 2018

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:123@localhost:3306 \ --slaves=repuser:123@192.168.10.11:3306,repuser:123@localhost:3306

but this command show that error

[root@master common]# mysqlrplsync --master=root:pass@host1:3306 \ --slaves=rpl:pass@host2:3306

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

Usage: mysqlrplsync --master=user:pass@host:port --slaves=user:pass@host: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

Comments
Post Details
Added on Apr 18 2018
10 comments
180 views