I recently adopted 3 mysql servers and my back ground is in Oracle an mssql so please forgive my terminology or lack of knowledge of mysql. We recently shutdown three of our mysql nodes for maintenance. Nodes 2 and 3 shutdown just fine, but node 1 took 20+ minutes to shutdown with an error (sorry, I do not have the error message). These are synchronized nodes. My question is, what are the steps to:
- Verify the database integrity on node 1
- How do you join and sync node 1 to the remaining nodes
[LIST]
[]Database client version: libmysql - 5.5.41
[]Server type: Percona Server
[*]CentOS
[/LIST]
Thanks!