Talk about maxwell's Recovery

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 ...

Added by jazzydog on Sat, 09 May 2020 18:21:55 +0300

MySQL relaylog + SQL_Thread incremental recovery binlog

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 ...

Added by Amal on Sun, 18 Aug 2019 08:23:00 +0300

MySQL MHA High Availability Scheme

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 ...

Added by budder on Sat, 06 Jul 2019 02:18:30 +0300

Physical Backup and Logical Backup

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: ...

Added by eekeek on Fri, 14 Jun 2019 23:39:22 +0300