Programming VIP

order This paper focuses on maxwell's Recovery Recovery maxwell-1.25.1/src/main/java/com/zendesk/maxwell/recovery/Recovery.java public class Recovery { static final Logger LOGGER = LoggerFactory.getLogger(Recovery.class); private final ConnectionPool replicationConnectionPool; private final RecoveryInfo recoveryInfo; private final MaxwellM ...

1. Set the executed gtid number of 3308 instances as the gtid number at the end of the full backup on that day View the name of the binlog file that ends when the xtrabackup is fully backed up on that day, the pos location point of the binlog, and the Gtid number that ends when the full backup is completed: [root@mgr01 backup]# cat /data/backu ...

introduce MHA (Master High Availability) is currently a relatively mature solution to MySQL high availability. It is a set of excellent high availability software as fault handover and master-slave promotion in MySQL high availability environment. In the process of MySQL fault switching, MHA can automatically complete the database fault swi ...

Physical backup and recovery: Physical backup is divided into hot backup and cold backup. Compared with logical backup, physical backup has faster backup and recovery speed. The principle is based on the cp command. Cold standby: backup MySQL database shared table space,.frm, stand-alone table space (.ibd), redo log files. Advantages: ...