MySQL Forums
Forum List  »  Replication

Re: Replication not working
Posted by: Rick James
Date: April 06, 2014 12:01AM

> > GRANT REPLICATION SLAVE ON *.* TO 'root'@'%' IDENTIFIED BY 'password';

No, create a new user for replication; don't clobber "root".

> binlog_do_db = “database name”

Don't use MicroSoft "smart quotes"

> > FLUSH TABLES WITH READ LOCK;

I don't know why you did this. I don't see the subsequent dump (on Master) of all the data and load (on Slave) of the data.
Or do you have no data yet?

> Execute the following lines to set the master
> CHANGE MASTER ...

CHANGE MASTER is done on the Slave. (It is unclear from your comments which machine you did it on.)

> MASTER_USER='user-name', MASTER_PASSWORD='password'

Those need to match the GRANT that I criticized above.

> If there is an issue in connecting, you can try starting slave with a command to skip over it:
> SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; SLAVE START;

No, "connection" issues do not lead to using the SKIP_COUNTER.

Caveat: There may be more problems with your instructions. Please read the online documentation again.

Options: ReplyQuote


Subject
Views
Written By
Posted
2022
April 01, 2014 04:40AM
Re: Replication not working
685
April 06, 2014 12:01AM


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.