Stop dumping all galera nodes status to the log

46 views
Skip to first unread message

Danny

unread,
Aug 16, 2024, 7:33:23 AMAug 16
to proxysql
We can configure mysql-hostgroup_manager_verbose=0 to prevent the hostgroups from dumping to the logs:
2024-08-15 17:54:54 [INFO] Dumping mysql_servers: HG 4
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+


But what is the setting to stop dumping the Galera node status?

2024-08-16 01:07:18 [INFO] Galera: Node status changed by ProxySQL, dumping all galera nodes status:
+--------------------+------+------------------+------------+-------------------+-----------+------------------------+-------------------+--------------+----------------------+------------------------
---------+----------------+-------+
| hostname           | port | start_time       | check_time | primary_partition | read_only | wsrep_local_recv_queue | wsrep_local_state | wsrep_desync | wsrep_reject_queries | wsrep_sst_donor_rejects
_queries | pxc_maint_mode | error |
+--------------------+------+------------------+------------+-------------------+-----------+------------------------+-------------------+--------------+----------------------+------------------------
---------+----------------+-------+

Danny

unread,
Sep 4, 2024, 7:48:05 AMSep 4
to proxysql
FYI: The above was solved with the 2.6.4 update: https://github.com/sysown/proxysql/issues/4612

Unfortunately, the 2.6.5 appears to have brought in some new dumps:
2024-09-03 13:52:37 [INFO] Dumping fetched 'mysql_group_replication_hostgroups'
2024-09-03 13:52:37 [INFO] Dumping fetched 'mysql_galera_hostgroups'
2024-09-03 13:52:37 [INFO] Dumping fetched 'mysql_aws_aurora_hostgroups'
2024-09-03 13:52:37 [INFO] Dumping fetched 'mysql_hostgroup_attributes'
2024-09-03 13:52:37 [INFO] Dumping fetched 'mysql_servers_ssl_params'

René Cannaò

unread,
Sep 4, 2024, 8:22:02 AMSep 4
to Danny, proxysql
Hi Danny,

Yes, the dump itself was fixed in 2.6.4 !
But the "info" message are not introduced in 2.6.5 . This is the complete diff between 2.6.4 and 2.6.5 :

INFO "Dumping fetched" messages are coming from ProxySQL Cluster module .
Therefore my guess is that in 2.6.4 you didn't have Cluster enabled, and you enabled it in 2.6.5 .

Thanks,
René

--
You received this message because you are subscribed to the Google Groups "proxysql" group.
To unsubscribe from this group and stop receiving emails from it, send an email to proxysql+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/proxysql/1844a00a-8684-4053-89a0-8e304753d49an%40googlegroups.com.

Danny

unread,
Sep 11, 2024, 7:36:03 AMSep 11
to proxysql
Wow, you're good. That is absolutely correct, and I had forgotten I did in fact enable Cluster module during the transition to 2.6.4. Then got pulled away (literally to a different country) and everything got pushed back. Now I'm back, and noticed that the initial issue was gone, but you're correct, these new ones are from the Cluster module. I'm checking the docs to see if there's a specific Cluster setting that disabled these from dumping to the log files, but so far not finding it. Is there a specific cluster setting to disable those dumps?
Reply all
Reply to author
Forward
0 new messages