Proxysql: Should cluster synchronize all tables required for mysql_servers checksum?

[samiahlroos]

Hi,
Not sure whether this is a bug or a feature request to be honest. Maybe there even is a good reason for this behavior and I'm just not seeing it.

When calculating checksum for mysql_servers ProxySQL seems to also use these tables:

• mysql_replication_hostgroups
• mysql_group_replication_hostgroups
• mysql_galera_hostgroups
• mysql_aws_aurora_hostgroups

But when synchronizing mysql_servers from peer it only pulls mysql_servers and mysql_replication_hostgroups which leads to checksum mismatches and diff_check increasing forever if there are differences in some of those other related tables.

Shouldn't ProyxSQL pull all tables required to calculate checksum of mysql_servers when synchronizing that table?

How to repeat:

• set up cluster
• add some entries to mysql_servers
• on one node add a row to for example mysql_galera_hostgroups
• LOAD MYSQL SERVERS TO RUNTIME
• see checksums mismatching and diff_check increasing forever in stats_proxysql_servers_checksums

Tested with 2.0.5.

I think operating system and error log are irrelevant here but do let me know if you want any of those.

Cheers,
Sami

[renecannao]

Hi @samiahlroos .
Looking at the code, it seems you are correct.
In this case, it is a bug.