Comments on Jonathan Levin's Axioms: How to Safetly Restart Your MySQL Slave Server

Thanks Jonathan, keep posting

2010-05-19T07:55:28.679+01:00

Thanks Jonathan, keep posting

Oops! I meant FLUSH TABLES :) However FLUSH LOGS ...

2010-05-19T01:45:30.957+01:00

Oops! I meant FLUSH TABLES :)

However FLUSH LOGS doesn't cause any harm. Both will be flushed as part of the orderly shutdown.

@Gerry I don't know if you want to flush your...

2010-05-18T21:03:44.832+01:00

@Gerry

I don't know if you want to flush your logs as you might want them for restoration or other slaves.
FLUSH TABLES, as I have learnt the hard way, will make sure all data and index changes be completed. So if you have delay_key_write on, it will save the changes to disk and won't corrupt your tables.

FLUSH LOGS could take a long time depending on you...

2010-05-18T19:25:10.828+01:00

FLUSH LOGS could take a long time depending on your environment, but it will eventually finish.

My $.02
G

Hi, There's also the Slave_open_temp_tables s...

2010-05-18T13:13:56.432+01:00

Hi,

There's also the Slave_open_temp_tables status variable; verify that it is zero before shutting down, or start/stop slave again until it is.