Bgs a écrit :
>
> Greetings,
>
> We have regular problems with mysql replication when there is a db
> change. This is mostly ALTER TABLE. The sync breaks and we either have
> to do the changes manually or either shut down the whole system for a
> new sync from zero. Is there a way to sync alter
[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..
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
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
[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.
Neil Gunton wrote:
>
> Since I didn't get any replies to my previous message (see below), I am
> trying to compile MySQL myself, to see if it results in a more stable
> system when using replication. However this is failing consistently with
> the following error:
>
> make[4]: Entering directory
Since I didn't get any replies to my previous message (see below), I am
trying to compile MySQL myself, to see if it results in a more stable
system when using replication. However this is failing consistently with
the following error:
make[4]: Entering directory `/usr/src/mysql-4.0.17/sql'
source
Hi,
Depending on you environment, rdate might work. On solaris, it can sync 2
clocks, on Digital UNIX, it gets the 'average' of clocks it can find.
Regards
Quentin
-Original Message-
From: Leonardo Dias [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 8 February 2001 09:27
To: [EMAIL PROTECT
