Background

Many service systems run around the clock. As the data storage software of applications, MySQL must be highly available. MySQL high availability (HA) is implemented using the replication technology of databases. The MySQL primary-secondary replication technology is implemented using the binlog (binary log). When the primary database is faulty, services can be manually switched to secondary databases to ensure service continuity and reliability.

Currently, most MySQL databases are deployed on x86 servers. In the future, more MySQL databases will be deployed on ARM servers. This document describes how to deploy MySQL primary-secondary replication on ARM servers or in an environment with ARM and x86 servers, and use the pt-table-checksum tool to check data consistency between the primary and secondary databases.

In this document, the deployment of one primary database and two secondary databases is used as an example. You can deploy more secondary databases. The hardware configuration, software versions, and test networking described in Environment Configuration are only examples. MySQL 8.0.20 and MySQL 5.7.27 have been verified. You can refer to this document when deploying MySQL of other versions.