4

MySQL slave server restart

view full story
linux-howto

http://serverfault.com – 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 (HowTos)