Safe slave shutdown when using temporary tables-opracowanie

Safe slave shutdown when using temporary tables. Temporary tables are replicated except
in the case where you stop the slave server (not just the slave threads) and you have replicated
temporary tables that are open for use in updates that have not yet been executed on the slave. If you
stop the slave server, the temporary tables needed by those updates are no longer available when
the slave is restarted. To avoid this problem, do not shut down the slave while it has temporary tables
open. Instead, use the following procedure:
1. Issue a STOP SLAVE SQL_THREAD statement.
2. Use SHOW STATUS to check the value of the Slave_open_temp_tables [613] variable.
3. If the value is not 0, restart the slave SQL thread with START SLAVE SQL_THREAD and repeat the
procedure later.
4. When the value is 0, issue a mysqladmin shutdown command to stop the slave.
... zobacz całą notatkę