Re: Problems with replication restarting

2004-12-20 Thread Jon Drukman
[EMAIL PROTECTED] wrote: So this would imply that you cannot simply stop/start a slave server - instead, I would need to write a wrapper script that stops the slave using "STOP SLAVE", and at next startup, read the master.info file to find out where it left off, and then issue a "CHANGE MASTER TO..

RE: Problems with replication restarting

2004-12-20 Thread Sanjeev Sagar
ave. Which MySQL version or release on what O/S? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 9:26 AM To: [EMAIL PROTECTED] Subject: RE: Problems with replication restarting So this would imply that you cannot simply stop/start a sl

RE: Problems with replication restarting

2004-12-20 Thread mark_round
42 To: Round, Mark - CALM Technical <[EMAIL PROTECTED]> Cc: [EMAIL PROTECTED] Subject: Re: Problems with replication restarting [EMAIL PROTECTED] wrote: >However, when I restart the slave (through init scripts, or when >rebooting the server etc.), instead of continuing on from where i

Re: Problems with replication restarting

2004-12-20 Thread Ian Sales
[EMAIL PROTECTED] wrote: However, when I restart the slave (through init scripts, or when rebooting the server etc.), instead of continuing on from where it left off, it appears to start again from the beginning. This is confirmed by watching the value of Relay_Log_Pos from SHOW SLAVE STATUS\G.