Environment Requirements
It requires three servers and involves two different OSs to migrate MySQL from an x86 server to a Kunpeng server and set up the primary/secondary replication mode.
Hardware and OS Requirements
Table 1 shows the hardware and OS requirements.
Component |
x86 Server x 2 (Primary and Secondary Databases) |
Kunpeng Server (New Primary Database) |
|---|---|---|
CPU |
Intel® Xeon® Gold 5218R Processor at 2.10 GHz |
Kunpeng 920 5220 at 3.0 GHz |
Memory |
24 x 32 GB x 2666 MT/s DDR4 |
8 x 32 GB x 2933 MT/s DDR4 |
Drive |
System drive: 600 GB SAS HDD MySQL data drive: 1 x 1.0 TB NVMe SSD |
System drive: 600 GB SAS HDD MySQL data drive: 1 x 570 GB NVMe SSD |
NIC |
1 x 10 Gbit/s |
1 x 10 Gbit/s |
OS |
Anolis OS 8.2 |
openEuler 22.03 (LTS-SP2) |
Software Requirements
Table 2 shows the software requirements.
Planning Nodes for MySQL Primary/Secondary Replication
Figure 1 and Table 3 show the node planning for MySQL primary/secondary replication.
IP Address |
Architecture |
Database (Before Switchover) |
Database (After Switchover) |
MySQL Server ID |
|---|---|---|---|---|
192.168.0.1 |
x86 |
Primary database |
New secondary database |
1 |
192.168.0.2 |
x86 |
Secondary database 1 (x86) |
Secondary database 1 (x86) |
2 |
192.168.0.3 |
Arm |
Secondary database 2 (Kunpeng) |
New primary database |
3 |