Mysql servers are deleted

[Adrian Birladeanu]

I have installed proxysql 1.4.9 on a Debian 8.6. Then I created a replication hostgroup with writer 1 and reader 2. Then I added in the 2 entries for each of the 3 nodes of a Percona XtraDB Cluster (one for writer, one for reader, with the writers having different weights). After saving servers to disk, i can see all 6 entries. However, after loading servers to runtime, one of the writers was deleted. There was no error log. Same happens if I save servers to disk and then restart proxysql.

[Nikolaos Vyzas]

Hi Adrian

Regular replication hostgroups are meant for master-slave replication.

In versions 1.4.x you'll need to implement the Galera checker script combined with the scheduler:

• http://www.proxysql.com/blog/galera-awareness-and-proxysql-scheduler
  
• https://severalnines.com/blog/how-set-read-write-split-galera-cluster-using-proxysql
  

ProxySQL 2.0 will have improved native support for Galera / PXC and support a new table mysql_galera_hostgroups for fine tuning of hostgroup behaviour without external tools.

• https://github.com/sysown/proxysql/wiki/Main-(runtime)#mysql_replication_hostgroups
• https://github.com/sysown/proxysql/wiki/Main-(runtime)#mysql_galera_hostgroups
  

Nick