Buy Percona ServicesBuy Now!

Proxysql2 and Native PXC Cluster

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Proxysql2 and Native PXC Cluster

    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
Working...
X