Rebooting a mysql slave?

[Simon]

Hi There,

Ive had a good look for this and cant seem to find out the right
answer... If anyone can shed some light i would be most grateful!

We have 2 mysql servers in a master/slave setup. We need to reboot the
slave server... when doing this, will it 'just work' - e.g. once
rebooted and backup and running will the slave catch up again
automatically? Is it prudent to 'stop slave', reboot, then 'start
slave' again?

We perform a 'stop slave', mysqldump then 'start slave' on a regular
basis, but cant acually find anything about rebooting the actual
server it self.

Likewise if you have to reboot the master for some reason...?

Thanks muchly

Simon

_______________________________________________
NZLUG mailing list ***@linux.net.nz
http://www.linux.net.nz/cgi-bin/mailman/listinfo/nzlug

[Steve Holdoway]

Post by Simon
Hi There,
Ive had a good look for this and cant seem to find out the right
answer... If anyone can shed some light i would be most grateful!
We have 2 mysql servers in a master/slave setup. We need to reboot the
slave server... when doing this, will it 'just work' - e.g. once
rebooted and backup and running will the slave catch up again
automatically? Is it prudent to 'stop slave', reboot, then 'start
slave' again?
We perform a 'stop slave', mysqldump then 'start slave' on a regular
basis, but cant acually find anything about rebooting the actual
server it self.
Likewise if you have to reboot the master for some reason...?
Thanks muchly

Hi Simon,

Yes it will 'just work' - I have a number of customers out there with
master/master replicated databases ( local store and website ) that can
handle the vagaries of ADSL... well the local ADSL here can be pretty
random. The requests just stack up, and then are run when normal service
is resumed.

Steve

[Robert]

Post by Simon
Hi There,
Ive had a good look for this and cant seem to find out the right
answer... If anyone can shed some light i would be most grateful!
We have 2 mysql servers in a master/slave setup. We need to reboot
the slave server... when doing this, will it 'just work' - e.g. once
rebooted and backup and running will the slave catch up again
automatically? Is it prudent to 'stop slave', reboot, then 'start
slave' again?
We perform a 'stop slave', mysqldump then 'start slave' on a regular
basis, but cant acually find anything about rebooting the actual
server it self.
Likewise if you have to reboot the master for some reason...?
Thanks muchly
Simon

Hi Simon,

Yes the MySQL slave will re-establish its connection to the master server
without you having to do anything as soon as the MySQL server comes back up
there shouldn't be any problems as a normal reboot will stop the MySQL server
gracefully.

Robert

_______________________________________________
NZLUG mailing list ***@linux.net.nz
http://www.linux.net.nz/cgi-bin/mailman/listinfo/nzlug

[David Hawke]

Hi Simon

Can you give us a little more detail here - how is the master / slave
setup - with Heartbeat, Pacemaker ?

Presumably you are replicating the disk - DRBD maybe ??

David H

Post by Simon
Hi There,
Ive had a good look for this and cant seem to find out the right
answer... If anyone can shed some light i would be most grateful!
We have 2 mysql servers in a master/slave setup. We need to reboot the
slave server... when doing this, will it 'just work' - e.g. once
rebooted and backup and running will the slave catch up again
automatically? Is it prudent to 'stop slave', reboot, then 'start
slave' again?
We perform a 'stop slave', mysqldump then 'start slave' on a regular
basis, but cant acually find anything about rebooting the actual
server it self.
Likewise if you have to reboot the master for some reason...?
Thanks muchly
Simon
_______________________________________________
http://www.linux.net.nz/cgi-bin/mailman/listinfo/nzlug

_______________________________________________
NZLUG mailing list ***@linux.net.nz
http://www.linux.net.nz/cgi-bin/mailman/listinfo/nzlug

[Simon]

Post by Steve Holdoway
Hi Simon
Can you give us a little more detail here - how is the master / slave setup
- with Heartbeat, Pacemaker ?
Presumably you are replicating the disk - DRBD maybe ??

Thanks for the reply david, its just a standard mysql master/slave
replication setup, manual fail over at this stage. The answers gave
the exact answer i needed and everything went swimingly!

Thanks

Simon

_______________________________________________
NZLUG mailing list ***@linux.net.nz
http://www.linux.net.nz/cgi-bin/mailman/listinfo/nzlug