Just found out that the #Percona MySQL #Operator, which deploys a Percona XtraDB/Galera Cluster on #Kubernetes quite nicely and sets up #ProxySQL to be able to split traffic between read and write queries, does not, actually, loadbalance over the nodes. There's a bug open since May 2021 which just disables this feature by providing incorrect config in ProxySQL. So this killer feature, which is still advertised in the docs, simply does not work at all. And there's no way to fix it manually.

Interesting weekend, with wirk on #checkmk and its API, and now #proxysql .

How to Install a Load Balancing #MySQL Server with #ProxySQL on #Debian 11 :debian:

https://www.howtoforge.com/how-to-set-up-load-balancing-mysql-server-with-proxysql-on-debian-11/

Not sure I ever did one of these, so using the suggestion from https://mastodon.ie/@davey_cakes/109525794316079346

Hello I'm Bobby

I do #software #platform #kubernetes #proxysql and #othercoolstuff

In my spare time I #parent my three awesome kids, #read, do #history research and #sitonmyass

Oh and I love #archeology

And that’s about it.

Marco Tusa from #Percona was recently asked "Can we use #ProxySQL with #MySQL 8 authorization mechanism?" His short answer was "Yes", however, don’t expect to have full caching_sha2_password support. Here’s what you should know.

https://www.percona.com/blog/proxysql-support-for-mysql-caching_sha2_password/

I’ve asked about this on that other service but didn’t get any responses. Anyone familiar with using #proxysql with #wordpress? I would prefer to use ProxySQL over the usual hyperdb for load balancing.

RT @dimitrik_fr@twitter.com

Wow ! #ProxySQL is going to be more and more reach in features! Kudos @rene_cannao@twitter.com for delivering v.2.0 ! #PerconaLive great stuff for @MySQL@twitter.com ;-))

🐦🔗: https://twitter.com/dimitrik_fr/status/1133788895164981250