Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Cluster checksum is not supported for mysql variables #2820

Open
TONYHOKAN opened this issue May 23, 2020 · 0 comments · Fixed by #2856
Open

Cluster checksum is not supported for mysql variables #2820

TONYHOKAN opened this issue May 23, 2020 · 0 comments · Fixed by #2856

Comments

@TONYHOKAN
Copy link

Hi, i was playing ProxySQL 2.0.10 cluster related feature and found that when i updated mysql variable and load to run, other nodes were not pulling the update.

I checked wiki https://github.com/sysown/proxysql/wiki/ProxySQL-Cluster doc said
Only 4 of the 6 modules generate a checksum for now.

May i know any milestone or when mysql variables cluster config sync will be supported?
As i am going to deploy ProxySQL to each of our service instance.

pondix pushed a commit that referenced this issue Oct 21, 2020
…#2856)

* Added forgotten metric increase in case of 'sync conflict' on proxysql_servers

* Added support for 'global_variables' sync in proxysql_cluster

- Added several for getting the peers to be sync.
- Added function to pull the target 'global_variables' to sync.
- Added metrics for 'global_variables' sync:
    + Number of syncs done / failed.
    + Sync conflicts.
    + Sync warnings.

* Removed unnecesary escaping for '%' char

* Fixed issue due to 'flush_mysql_variables___runtime_to_database' being called without proper locking

* Added simple helper function to get the output from a command execution

* Multiple changes to 'cluster_synct' test

+ Spawned proxysql instance now runs inside a docker container.
+ Simplified launching and logging of spawned proxysql instance.
+ Added more verbose logging about the tables state.
+ Added new tests for 'global_variables' synchronization.

* Commented several variables known to not-sync and fixed port for replica 'proxysql_server'

* Removed deprecated and non-syncable variables from 'test_cluster_sync-t'

* Added extra logging for variables sync for 'test_cluster_sync-t'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant