How PhxSQL Achieves MySQL-Compatible High Availability with Strong Consistency

PhxSQL is an open‑source, MySQL‑compatible relational database cluster that provides high availability and strong data consistency through a single‑master multi‑slave architecture, automatically switching masters when over half the nodes are alive, without relying on external services like Zookeeper, and requiring no code changes for migration.

Database ClusterPhxSQLhigh availability

0 likes · 6 min read

How PhxSQL Achieves MySQL-Compatible High Availability with Strong Consistency

WeChat Backend Team

Sep 8, 2016 · Databases

Why PhxSQL Rejects Multi-Write, Sharding, and Serializability: Design Trade‑offs

This article explains how PhxSQL prioritizes strong linearizable consistency, high availability, serializable isolation, and full MySQL compatibility, and why it deliberately forgoes features such as multi‑write, sharding, and strict serializable isolation due to the high cost of distributed transactions and protocol complexity.

ConsistencyMySQL compatibilityPhxSQL

0 likes · 17 min read

Why PhxSQL Rejects Multi-Write, Sharding, and Serializability: Design Trade‑offs

Efficient Ops

Aug 31, 2016 · Databases

Can WeChat’s Open‑Source PhxSQL Deliver True High‑Availability MySQL?

The article reviews WeChat’s newly open‑sourced PhxSQL, a MySQL clustering solution that promises high availability and strong consistency, examines its complex architecture with added Phxbinlogsvr and Phxsqlproxy components, and discusses practical concerns such as deployment difficulty, replication latency, lack of multi‑master writes, semi‑synchronous behavior, and monitoring challenges.

PhxSQLdatabase clusteringhigh availability

0 likes · 9 min read

Can WeChat’s Open‑Source PhxSQL Deliver True High‑Availability MySQL?