The invention discloses a mysql online migration
system and method based on MHA. The
system comprises an MHA management node, a mysql
master slave node and a new slave node, wherein the MHA management node comprises an MHA management module, an online switching module and an MHA configuration updating module; the mysql
master slave node comprises an online data setting module and an offline slave
database module; the new slave node module comprises a slave
database setting module. The mysql online migration
system and method has the advantages that the method is simple in operation steps, mysql
database node migration can be completed by several simple commands, and especially the migration of the mysql master database node is convenient and simple; high stability is achieved, errors can hardly occur, and migration quality is increased;
data consistency is well guaranteed, and data inconsistency is avoided; high
automation level is achieved, and work efficiency is increased; due to the fact that operation is simple, multiple mysql
master slave clusters can be operated at the same time, and the online migration of multiple mysql database nodes is achieved.