On cluster mode it synchronizes only runtime rules, and as side effect if we disable rules on one node, we can't reenable it on different node since here is no config in memory layer.
Disable rules: UPDATE mysql_query_rules SET active=0; LOAD MYSQL QUERY RULES TO RUNTIME;
Enable rules: UPDATE mysql_query_rules SET active=1; LOAD MYSQL QUERY RULES TO RUNTIME;
Proxysql Version: 2.7.1 OS: Ubuntu 22
On cluster mode it synchronizes only runtime rules, and as side effect if we disable rules on one node, we can't reenable it on different node since here is no config in memory layer.
UPDATE mysql_query_rules SET active=0; LOAD MYSQL QUERY RULES TO RUNTIME;UPDATE mysql_query_rules SET active=1; LOAD MYSQL QUERY RULES TO RUNTIME;