Multi-Primary Write problem with ProxySQL in the Percona MySQL Operator on Kubernetes

Arsenal_Dong · January 13, 2026, 4:23am

kedarpercona · January 13, 2026, 4:40am

Welcome to Percona Forum @Arsenal_Dong ,

I see that you’re querying mysql_servers table. That’s for configuration but when you “apply that configuration”, proxysql loads it to runtime and that is the table you should check for active status.

Please rerun your query as:

SELECT hostgroup_id, hostname, status FROM runtime_mysql_servers ORDER BY hostgroup_id;

Thanks,
K

Refer:

Arsenal_Dong · January 13, 2026, 5:06am

looks like 3 nodes all be written nodes, right？

kedarpercona · January 13, 2026, 5:35am

hmmm! Can you share galera hostgroups configuration? (or the steps that you followed to set this up)

select * from runtime_mysql_galera_hostgroups;

Arsenal_Dong · January 13, 2026, 6:04am

kedarpercona · January 13, 2026, 7:46am

So as per your configuration 11 is writer hostgroup. There you only have 1 node ONLINE. Does this looks OK to you? I think you’re wrongly looking at 10.

Thanks,
K

Arsenal_Dong · January 14, 2026, 2:45am

Ops! It’s my fault. Thanks for your patience guidance!

Topic		Replies	Views
How to split reads/writes with ProxySQL Percona Operator for MySQL mysql , percona	6	3527	May 6, 2022
Hostgroup id different on mysql_servers and runtime_mysql_servers ProxySQL community , mysql	1	2370	November 9, 2020
Getting error while trying to execute basic queries like show databases / select version, etc Percona Operator for MySQL mysql	11	3338	November 3, 2020
Increased amount of deadlocks with Percona XtraDB Cluster with the PXC Operator & ProxySQL Percona Operator for MySQL mysql , percona , kubernetes	4	368	July 1, 2025
proxysql looses server after restart of mysqld (percona xtradb cluster) ProxySQL	8	2614	February 12, 2018

Multi-Primary Write problem with ProxySQL in the Percona MySQL Operator on Kubernetes

Related topics