Analysis and comparison of five MySQL database reliability solutions (2) _ MySQL

Analysis and comparison of five MySQL database reliability solutions (2) GFS/GNBD can provide the required shared hard disk.

GFS is a transaction-safe file system. You can share data with a MySQL instance at the same time.

Cost:

The cost of up to n high-performance servers, one of which is activated and others are used as backup servers.

Advantages:

High Reliability

Some degree of redundancy

Scaling based on high reliability

Disadvantages:

No server load balancer

Unguaranteed redundancy

Unable to scale write operations

Speed

2 times the size of a single server. The read operation is well supported.

Application scenarios

READ-intensive applications that require high reliability

3. MySQL/DRBD/HA (Active/Passive)

Introduction:

If multiple MySQL servers use a shared hard disk as data storage, what is the solution?

DRBD can provide shared hard disks. DRBD can be set to transaction security.

You can share data with a MySQL instance at the same time.

Cost:

The cost of up to n high-performance servers, one of which is activated, and the other is used as backup servers.