1. Environment: CentOS5.5x84, mysql5.152. two machines: master1: 192.168.5.143master2: 192.168.0.1493. Compile and install MySQL separately and test the connection.
1. Environment: CentOS5.5 x84, mysql5.152. two machines: master1: 192.168.5.143master2: 192.168.0.1493. Separately compile and install MySQL and test connection
10. Test
Experiment 1: Start two services and perform operations on any mysql instance.
Experiment 2: Start two services and add 20 warehouses using tpcc tool on master1. The data occupies about 1.9 GB of hard disk, and count (*) is calculated on the two machines. The data is consistent.
Experiment 3: Start master1 and use the tpcc tool to add a warehouse and start master2. After synchronization for a period of time, calculate count (*) and the results are consistent.
Ps, MySQL master-master replication is actually two-way master-slave replication.