All posts tagged with "mysql"
A real migration from a pool of RQ worker processes to a single asyncio job engine: leases instead of a coordinator, batching instead of one request per job, the MySQL deadlock it caused, and load-test numbers.
Understand ProxySQL hostgroups: what they are, how they route MySQL traffic, common use cases, pitfalls, Galera cluster integration, and running multiple ProxySQL instances across data centers.
Learn how to use ProxySQL as a connection pooler between PHP applications and MySQL, dramatically reducing connection overhead and improving database scalability.
Deep dive into Galera Cluster internals — the wsrep API, write-set replication, certification-based conflict resolution, node states, flow control, quorum mechanics, and SST vs IST recovery.
Understand MySQL binary log replication from the ground up — how async and semi-sync replication work, what GTIDs are and why they matter, replication lag causes, and the failure modes that led to Galera Cluster.
Master MySQL high availability from replication basics to multi-master Galera clusters, Percona XtraDB Cluster, ProxySQL query routing, backup strategies, and production monitoring with PMM.