article thumbnail

Proof of Concept: Horizontal Write Scaling for MySQL With Kubernetes Operator

Percona

Best practices indicate that having ProxySQL closer to the application will be more efficient, especially if we decide to activate the caching feature. FOR UPDATE | NULL | 1 | 1001 | NULL | | 2 | 101 | 2041 | ^SELECT.*$ | NULL | 1 | 1001 | NULL | | 0 | 200 | 2050 | ^SELECT.*FOR NULL | 1 | 0 | NULL | | 0 | 100 | 2040 | ^SELECT.*FOR

Traffic 121