Mysql- High availability Cluster-introduction (1)

Common mysql cluster architecture: 1. Single master and slave

Overall, there are three steps to replication:

(1) master records changes in the binary log (binary log) (these records

Called binary log events, binary log events)

(2) slave copies the binary log events of master to its relay log

(relay log)

(3) slave replays the events in the relay log and changes the data that reflects itself.

two。 Type of architecture:

MySQL master-slave replication of enterprise application scenarios:

1. Real-time data backup of slave server as master server

two。 Real-time read and write separation between master and slave server to achieve load balancing from server

3. Split multiple access from the server according to business importance

3. Load balancing, read-write separation

4. Read and write are separated, read is split by business