MySQL Forums
Forum List  »  Replication

Re: setup mysql replication on CentOS error
Posted by: Rick James
Date: May 25, 2010 08:40AM

A checklist (not sure if it is complete)

On Master:
* To be a Master, log_bin (note: underscore, dash) needs to be turned on in my.cnf (plus restart)
* "GRANT REPLICATION SLAVE ..." is needed on the Master (at least).
* The server_id values MUST be different between Master and Slave.
* SHOW MASTER STATUS -- run this on the Master

On Slave:
* To be a Slave, execute CHANGE MASTER with most of the possible args.
* The server_id values MUST be different between Master and Slave.
* SHOW SLAVE STATUS -- run this on the slave

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: setup mysql replication on CentOS error
1357
May 25, 2010 08:40AM


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.