MySQL Forums
Forum List  »  Replication

Re: Start slave fails
Posted by: Kanwar Plaha
Date: March 27, 2010 05:19AM

Hi Rick,
I backed up the master database with locking enabled and immediately setup the slave. I also saved the master log position *before* taking the backup. So I am confused why the replication should fail for any query as the slave should catch up from a time before the backup and hence should give consistent results.

If there is any other way of setting up replication (I cannot shutdown the master as it is live), please let me know so I can try.

Thanks,
Kanwar

Options: ReplyQuote


Subject
Views
Written By
Posted
3543
March 23, 2010 06:51PM
1510
March 24, 2010 09:10AM
1686
March 24, 2010 05:40PM
1370
March 26, 2010 11:26PM
Re: Start slave fails
1478
March 27, 2010 05:19AM
1368
March 27, 2010 10:04AM
1610
March 27, 2010 05:00PM
1444
March 27, 2010 09:35PM
1347
March 28, 2010 05:14PM


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.