Shulou(Shulou.com)05/31 Report--

Today, I will talk to you about the characteristics and shortcomings of MySQL Galera Cluster. Many people may not know much about it. In order to let you know more, Xiaobian summarizes the following contents for you. I hope you can gain something according to this article.

Galera Cluster was developed on top of a more generic API called wsrep (Write Set Replication).

The wsrep API is an independent open source project initiated by Codership that defines an interface between database servers and data replication plug-ins.

MySQL-wsrep is a patch to MySQL that implements the wsrep API interface in the database server. After installing this patch, MySQL can launch wsrep plug-ins such as Galera. Galera is a wsrep provider that enables synchronous multi-master data replication.

Galera Cluster has the following characteristics:

True multi-master architecture, any node can read and write

Synchronous replication with no latency between nodes and no data loss due to node downtime

Tightly coupled, all nodes maintain the same state, no different data between nodes

No master-slave switching or VIP usage required

Hot Standby, no downtime during Failures (since Failures are not required)

Automatic node configuration, eliminating the need to manually backup the current database and copy it to the new node

Support InnoDB storage engine

Corresponding to transparency, no application changes or minimal changes

No need for read/write separation

The shortcomings of Galera Cluster mainly include:

Data replication only supports tables of the InnoDB storage engine.

LOCK and UNLOCK statements are not supported, nor are the GET_LOCK() and RELEASE_LOCK() functions.

Using log_output to store logs in tables is not supported, logs can only be stored as files.

XA (Extended Architecture) transactions are not currently supported.

After reading the above, do you have any further understanding of the characteristics and shortcomings of MySQL Galera Cluster? If you still want to know more knowledge or related content, please pay attention to the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.