MySQL Setup at Hostinger Explained (opens in new tab)

Ever wondered how hosting companies manage their MySQL database architecture? At Hostinger, we have various MySQL setups starting from the standalone replica-less instances to Percona XtraDB Cluster (later just PXC), ProxySQL routing-based and even absolutely custom and unique solutions which I’m going to describe in this blog post. We do not have elephant-sized databases for internal services like API, billing, and clients. Thus almost every decision ends up with high availability as a top p...