ducnm

  ProxySQL Native Support for Percona XtraDB Cluster (PXC) ProxySQL in its versions up to 1.x did not natively support Percona XtraDB Cluster (PXC). Instead, it relied on the flexibility offered by the scheduler. This approach allowed users to implement their own preferred way to manage the ProxySQL behaviour in relation to the Galera events. From version 2.0 we can use native ProxySQL support for PXC.. The mechanism to activate native support is very similar to the one already in place for group replication. In brief it is based on the table [runtime_]mysql_galera_hostgroups and the information needed is mostly the same: writer_hostgroup : the hostgroup ID that refers to the WRITER backup_writer_hostgroup : the hostgoup ID referring to the Hostgorup that will contain the candidate servers reader_hostgroup : The reader Hostgroup ID, containing the list of servers that need to be taken in consideration offline_hostgroup : The Hostgroup ID that w...