Hi, Thanks a lot for sharing your thoughts....
regards, Usha On Wed, Jun 16, 2010 at 10:04 AM, Vamsee Kanakala <[email protected]>wrote: > 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 > _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
