Proxysql: mysql_galera_hostgroups table doesn't exist

[Buzut]

In the docs it says that for Galera setups, users should make use of the mysql_galera_hostgroups table.

In case Group Replication / InnoDB Cluster or Galera / Percona XtraDB Cluster is used for replication the mysql_group_replication_hostgroups or mysql_galera_hostgroups should be used instead.

This table doesn't exist and it is unclear wether users should use any of mysql_group_replication_hostgroups or mysql_galera_hostgroups for a Galera setup or only the latter one.

As the mysql_galera_hostgroups doesn't exist, I used mysql_group_replication_hostgroups and it seems to work. But I'm still unsure as the sentence doesn't make it very clear.

Version 1.4.12 Ubuntu.

[peterschutt]

I ran into the same issue. It's a 2.0 feature, as mentioned here.

Also:

https://github.com/sysown/proxysql/blob/297321ef433c5b683285f829fc5e0c3c79686652/include/MySQL_HostGroups_Manager.h#L37

Doesn't exist in https://github.com/sysown/proxysql/blob/v1.4.12/include/MySQL_HostGroups_Manager.h

I haven't been able to find any version specific docs but have found a precedent of noting version differences in the wiki (SSL Support) so I will add a change to the Main (runtime) wiki page mentioning that the galera table is only available in 2.x, which will hopefully save others the hassle of having to find this out for themselves.

[Buzut]

Awesome! Thank you for the detailed explanation.