Network Planning

Figure 1 shows the planned networking. There is one primary database and two secondary databases. Deploy MySQL primary-secondary replication on the primary and secondary databases, and install BenchmarkSQL, Sysbench, and Percona Toolkit on the client. BenchmarkSQL or Sysbench is used to import data to the primary database in batches, and Percona Toolkit is used to verify data consistency between the primary and secondary databases.

Figure 1 Networking planning (one primary database and two secondary databases)