The invention discloses a high-
availability management method of an
MYSQL cluster, and relates to the technical field of
database management. Comprising the following steps: step 1, managing the availability of an MYSQL slave cluster: forwarding a request to service ip ports of a plurality of slaves through an ip port bound with a unified application
service gateway device by using the routing forwarding of the unified application
service gateway device agent
software application, configuring
heartbeat check of the port of the unified application
service gateway device, and according to the
heartbeat check, managing the availability of the MYSQL slave cluster; 2, managing availability of the MYSQL host: establishing a standby
machine of the MYSQL host, creating a new virtual ip, pointing the virtual ip to the MYSQL host and the standby
machine, and when a
software application is connected with the host through the virtual ip to perform write-in operation, switching to the standby
machine when the MYSQL host is abnormal, and transferring the write-in operation to the MYSQL standby machine; and step 3, performing host
data synchronization of the MYSQL slave cluster: when the MYSQL host is abnormal, synchronously pointing the slave to the standby, enabling the standby to synchronize the newest host log, ensuring the newest data, and
synchronizing the host data by the slave cluster.