Re: setup mysql replication on CentOS error
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
Subject
Views
Written By
Posted
4217
May 24, 2010 05:11AM
Re: setup mysql replication on CentOS error
1357
May 25, 2010 08:40AM
1161
May 25, 2010 08:18PM
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.