Usha Murali wrote:
Hi ,
in mysql master slave architecture,how to find if both of them are in
sync...
If you mean a replicated MySQL setup by 'master-slave architecture',
it's as simple as doing an insert/update/delete on the master and
checking if the slave got the change or not. If not, something went wrong.
Make sure you didn't make any changes to the master since you took the
mysql binary log position. If you don't know what I'm talking about,
carefully retrace the steps listed here, you should be good:
http://www.howtoforge.com/mysql_database_replication
If those steps are not entirely clear, this is where you can also refer
to (if you're using a more recent mysql version like 5.1, check the
relevant docs for that version):
http://dev.mysql.com/doc/refman/5.0/en/replication-howto.html
Vamsee.
_______________________________________________
ILUGC Mailing List:
http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
