How to change k8-pxc operator Proxysql server weight?

Lalit_Choudhary · December 30, 2025, 1:18pm

Description:

In the K8-PXC with proxysql by default we have this weight for servers and hostgroups,

Here Writes and reads will go to pxc-0 pod always due to high weight configuration, How we can change weight so we can use pxc-1, pxc2 pods with higher weight for reads.

Keeping Writes and Reads on single pod with high weight is not good I think for performance.

Version:

k8-pxc 1.18.0

How can we change weight for server in proxysql ?

Note: Updating mysql_servers with LOAD RUNTIME & SAVE DISK will not work as operator will reset weight as mentioned in the code.

github.com/percona/percona-xtradb-cluster-operator

build/proxysql_add_pxc_nodes.sh

254249e5b


      
          		pod_id=$(echo $pod_name | awk -F'-' '{print $NF}')
          
          		wait_for_mysql "${host}"
          
          		hosts=$((hosts + 1))
          
          		write_weight=1000
          		read_weight=1000
          		case ${pod_id} in
          			0)
          				write_weight=1000000
          				read_weight=600
          				;;
          			*)
          				write_weight=$((write_weight - pod_id))
          				read_weight=$((read_weight - pod_id))
          				;;
          		esac
          
          		update_weights="${update_weights} UPDATE mysql_servers SET weight=${read_weight} WHERE hostgroup_id IN (10, 8010) AND hostname LIKE \"${pod_name}%\"; UPDATE mysql_servers SET weight=${write_weight} WHERE hostgroup_id IN (11, 8011) AND hostname LIKE \"${pod_name}%\";"
          	done

Lalit_Choudhary · December 30, 2025, 1:26pm

Lalit_Choudhary · December 31, 2025, 4:22am

Ok I see , this is the real issue for k8-pxc operator if we are using ProxySQL for load balancing.

Ongoing topic:

Topic		Replies	Views
PXC on Kubernetes - ProxySQL load balancing Percona XtraDB Cluster 8.x	7	1717	January 1, 2026
Proxysql configuration automatically overwritten Percona Operator for MySQL	3	693	November 24, 2023
[ProxySQL]Change of weight value on mysql_servers table Other Tools	4	5601	June 12, 2018
Question about proxysql weighting ProxySQL	5	1869	October 29, 2020
How to split reads/writes with ProxySQL Percona Operator for MySQL mysql , percona	6	3583	May 6, 2022

How to change k8-pxc operator Proxysql server weight?

Description:

Version:

How can we change weight for server in proxysql ?

Related topics