Not the answer you need?
Register and ask your own question!

Proxysql2 and Native PXC Cluster

simtardifsimtardif ContributorCurrent User Role Novice
Hi I'm trying to upgrade our Proxysql to version 2 with native galera support with our 3 pxc nodes (pxc 5.7.23). With proxysql 1.4 to shutdown a node without dropping existing connection we use SET GLOBAL pxc_maint_mode=MAINTENANCE; and waiting before the shutdown of the server because the monitor script by percona was checking this variable and was doing an offline_soft with the node.
How can we do the same thing with the Native Galera support of proxysql2 ?
Can't find anything about that. Every test I made with different parameter like with wsrep_reject_queries or wsrep_desync if i check proxysql log,proxysql do an offline_hard of the node.

So is someone here using proxysql 2 with native galera support and if yes how are you doing maintenance on your pxc nodes when you have to, without an offline hard of the node ?
Thanks for your help
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.