RE: Replication - promoting slave to master

2004-06-18 Thread Alec . Cawley
[EMAIL PROTECTED] wrote on 18/06/2004 15:09:58: > I would need log-bin and log-slave-updates enabled on the slave, correct? > > So to automate the process it would be better to start both servers > without the Master-host info in the conf file, letting Heartbeat issue the > commands on star

RE: Replication - promoting slave to master

2004-06-18 Thread Victor Pendleton
necessary to have log-bin enabled in the event that you will be promoting this server to master one day. -Original Message- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 6/18/04 9:09 AM Subject: RE: Replication - promoting slave to master I would need log-bin and log-slave-updates

RE: Replication - promoting slave to master

2004-06-18 Thread stanner
L PROTECTED] '" <[EMAIL PROTECTED]>, "'[EMAIL PROTECTED] '" <[EMAIL PROTECTED]> cc: Subject:RE: Replication - promoting slave to master Initially you should have set the slave up with log-bin in its my.cnf file so that it is writing t

RE: Replication - promoting slave to master

2004-06-17 Thread Victor Pendleton
Initially you should have set the slave up with log-bin in its my.cnf file so that it is writing to its own binary logs. In the event that the master goes down, you should issue a change master on any other slaves so that they point to the new master. Redirect all writes to the new master. On the n