proxysql

Commit Graph

Author	SHA1	Message	Date
Rene Cannao	f8c64142cb	Fix cluster CI: remove duplicate primary INSERT and add sync_algorithm=3 - Remove redundant INSERT of primary into proxysql_servers on nodes. Commit `b02147b92` added the primary to the shared PROXYSQL_SERVERS_SQL but didn't remove the pre-existing per-node INSERT, causing a UNIQUE constraint violation that broke all multi-node CI groups. - Add cluster_mysql_servers_sync_algorithm=3 to test_cluster_sync config files and update hardcoded datadir paths to match current workspace.	3 months ago
Rene Cannao	72a1c5dd4a	Set cluster_mysql_servers_sync_algorithm=3 in test_cluster_sync replica config The replica used the default algorithm (1) which syncs runtime mysql_servers — including monitor-shunned status. The test checks the config table (mysql_servers) for status='ONLINE', but the runtime sync overwrites the config table with SHUNNED status. With auto_select (3) and monitor enabled (-M flag), the replica uses mysql_servers_v2 sync which preserves the configured status.	3 months ago
Rene Cannao	91e95fddd0	Updated gitignore	3 months ago
Rene Cannao	785fbef3e4	Fix ProxySQL user registration collisions in multi-infra environments (ref #5439 ) - Replace REPLACE INTO with INSERT OR IGNORE INTO for mysql_users. - Prevents subsequent infrastructures from overwriting shared users like testuser/root. - Ensures the first infra in the loading order defines the primary default_hostgroup.	3 months ago
Rene Cannao	6f8598b90b	Implement transient SSL copies for PostgreSQL to preserve repo permissions - Refactor all docker-compose-init.bash scripts to copy SSL files to a transient directory. - Apply strict 0640/999 permissions only to the transient copies. - Update docker-compose.yml to mount SSL volumes from the transient log directory. - This resolves 'Permission denied' errors in git status/diff during active test runs.	3 months ago
Rene Cannao	864fc94b92	Removing files committed by mistake	3 months ago
Rene Cannao	6f2831a59b	Removed cluster_sync_node_stderr.txt	3 months ago
Rene Cannao	242eef0241	Address code review feedback - test_binlog_reader_uses_previous_hostgroup-t.cpp: Use relative path when TEST_DEPS is unset. - test_com_register_slave_enables_fast_forward-t.cpp: Use relative path when TEST_DEPS is unset. - test_ffto_pgsql-t.cpp: Escape credentials before using them in SQL. - charset_unsigned_int-t.cpp: Ensure mysql_b connects and verifies latin1 before reset. - test_cluster_sync-t.cpp: Use mysql_query instead of system() for diagnostics. - test_cluster_sync_config: Replace tracked runtime stderr file with .example and gitignore it. - test_cluster_sync_withmonitor: Use relative path for datadir in config. - test_sqlite3_pass_exts-t.cpp: Use cl.admin_host for admin connection and improve version check. - test_auth_methods-t.cpp: Correctly detect MariaDB and use plan(0) for skip.	3 months ago
Rene Cannao	069d6aca6f	test: Enhance malformed packet stability test and CI configuration - Improve diagnostics and add hostname resolution to malformed packet test. - Fix plan count and credential handling in mysql-test_malformed_packet-t.cpp. - Add Cluster sync test configuration and SSL certificates for regression testing. - Include SIGTERM handler verification script marker.	3 months ago
Rahim Kanji	f35003802e	* The cluster template file now includes "cluster_sync_interfaces=false." * In the event of any failure, it's crucial to call the cleanup function to prevent any orphaned replica instances from remaining active.	3 years ago
Rahim Kanji	625675ddbd	Created TAP test to ensure the cluster synchronization of 'runtime_mysql_servers' and 'mysql_servers_v2' across all nodes. The test involves creating two replica nodes, one with a monitor enabled and the other with a monitor disabled. The test verifies that the correct records are synced among these nodes based on the value of 'admin-cluster_mysql_servers_sync_algorithm'.	3 years ago
Javier Jaramago Fernández	f1494b36b2	Fix 'test_cluster_sync-t' to work with running cluster #3847 - Redesign test for being able to work with an already running cluster. - Add comments and doc about the test itself and new changes. - Remove docker usage.	4 years ago
Javier Jaramago Fernández	05a005f9fb	Add support for syncing 'mysql-variables' and 'admin-variables' #2820 (#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'	6 years ago
Javier Jaramago Fernández	d23254f41f	Path for the 'datadir' field for cluster proxysql instance is now getted from a env variable	6 years ago
Javier Jaramago Fernández	ee5ffd87d0	Fixed paths for 'test_cluster' and other improvements	6 years ago
Javier Jaramago Fernández	7a7427e1fa	Added new test to check that synchronization works in a simple cluster env	6 years ago

16 Commits (mysqlx-plugin-impl)