Comments on: How to Use ProxySQL 2 on Percona XtraDB Cluster for Failover https://www.percona.com/blog/how-to-use-proxysql-2-on-percona-xtradb-for-failover/ Fri, 10 Jan 2020 20:11:33 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: Jon K. https://www.percona.com/blog/how-to-use-proxysql-2-on-percona-xtradb-for-failover/#comment-10971671 Fri, 10 Jan 2020 20:11:33 +0000 https://www.percona.com/blog/?p=63794#comment-10971671 Hola Walter, I don’t like that ProxySQL uses the “weight” to define who is the node WRITER.
Imagine, according to your example, that node pxc1 goes down abnormally…which node will be the new WRITER, pxc2 or pxc3 (both have same “weight”) ?

If you have only one ProxySQL it is indifferent whether it is the pxc2 or the pxc3 the new WRITER but if you have several ProxySQL (not in Cluster), it could happen that pxc2 and pxc3 will remain as WRITER in different ProxySQLat the same time and this can be a big problem if max_writers=1.

Thanks.

]]>