ProxySQL best practice method for 3node multimaster cluster

General Questions
,
1

Hi Experts,

Any recommended/best practice ProxySQL configuration for 3node multi master percona xtraDB cluster? thanks in advance.

thanks
Venakta

1 Like
2

Hi @Venkata,
The recommended/best practice in a 3-node PXC is to use proxysql to set up a single writer and use all 3 for reads. It is NOT recommended to load-balance writes to all nodes.

2 Likes