Query Caching - Query Routing - Mirroring - Query Rewrite - Data Masking
sukan February 16, 2018
Sukan is Database Team Lead at Mafiree with over a decade of experience in database systems, architecture, and performance optimization. He specializes in MySQL, MongoDB, TiDB, and ClickHouse, developing architectural improvements that make data platforms faster, more efficient, and cost-effective. Sukan writes about practical database engineering topics, real-world performance tuning, data replication, and high-scale system design, drawing from extensive hands-on experience solving complex technical challenges.
It is very helpful.
From routing to rewriting — ProxySQL elevates PostgreSQL. Explore how we did it, step-by-step. Power up your PostgreSQL with ProxySQL's smart features!Query rewrite, dual auth, caching, and more — all in action.
How ProxySQL helps in achieving query routing without making a application changes.
Features of ProxySQL 2.0 Version
ProxySQL is one of the advanced software load balancer that we have in market. ProxySQL has an in-built abilty to identify the reads,writes and route the write traffic to master and read traffic between the available slaves. One occurence of a Replication delay or server crash or replication breakag