Comparison of MySQL High Availability Technologies (1)

Comparison of MySQL High Availability Technologies (1)

The pictures and materials are from the MYSQL technical insider of Master Jiang chengyao of MYSQL ).

Database Reliability refers to data reliability; Database Availability refers to database service availability. Reliable data is like the Industrial and Commercial Bank of China. data cannot be lost. If a service is available, the server cannot go down.

Use various high availability technologies of MYSQL to meet the following high availability requirements

To reach 99.9%: MYSQL replication technology

To reach 99.99%: use mysql ndb cluster and Virtualization Technology

To reach 99.999%: GEO-REPLICATION and NDB cluster technology using the shared-nothing Architecture

What is Gluster Geo-replication?

Gluster Geo-replication (geo-replication) is a remote disaster recovery technology. It is mainly used to store a storage in a cluster, almost instantly (near real-time) back up data to a remote data center through the Internet (wan.

Downtime allowed for various high availability levels

DRBD: Raid 1 of a Network Disk