What's the secure/proper way of restarting the MySQl slave server. I need to reboot the machine in order to update the kernel and apply some configuration changes.
I've tested it on my lab and unfortunately it didn't work properly:
- I powered down slave server.
- I've created new database with one simple table on the master server
- I powered up the slave server (I haven't noticed any errors in the logs) The slave server has the correct master log position but there is no data created on the master while the slave was down. The master log position is updated when i create new data on the master but it's not appear on the slave?
I'm wondering if I should make any extra steps before I reboot the server, like "SLAVE STOP;" etc.
I have also another question regarding Percona Xtradb backup. When this script is running on the slave it's going behind the master (The I/O is not high and I've set --throttle option anyway)
What's the maximum value that the slave server can go behind the master and it still will be able to catch up with master?