proxysql

Commit Graph

Author	SHA1	Message	Date
Rene Cannao	801a44399a	Split clickhouse tests into separate legacy-clickhouse group Move 3 clickhouse TAP tests (clickhouse_php_conn-t, test_clickhouse_server-t, test_clickhouse_server_libmysql-t) from legacy-g1/g3 to legacy-clickhouse-g1. Remove infra-clickhouse23 from legacy/infras.lst. This eliminates the clickhouse container from all legacy-g1..g4 runs, reducing container count per group.	2 months ago
Rene Cannao	6769ea4845	Make legacy/pre-proxysql.bash a no-op	2 months ago
Rene Cannao	6fcb8fd631	Run ProxySQL cluster nodes inside a single container Instead of spawning 1+9 Docker containers for the ProxySQL cluster, run all instances as background processes inside the primary container. Each node gets its own port pair (admin=6032+i10, mysql=6033+i10) and data directory. This eliminates 9 Docker containers per group, avoiding Docker networking/iptables contention that caused "no route to host" errors under parallel test execution. Changes: - start-proxysql-isolated.bash: starts cluster nodes as background processes inside the container, then initializes the cluster and installs the scheduler — all in one script - check_all_nodes.bash: polls 127.0.0.1 on different ports instead of container hostnames - env-isolated.bash: TAP_CLUSTER_NODES uses proxysql:PORT format - default/pre-proxysql.bash, legacy/pre-proxysql.bash: no longer call cluster_start.bash/cluster_init.bash (handled by start-proxysql) Co-Authored-By: Claude Opus 4.6 (1M context) <noreply@anthropic.com>	2 months ago
Rene Cannao	0c58d1c645	Fix REPO_ROOT derivation: 4 levels up from test/tap/groups/<name>/ Scripts are at test/tap/groups/<name>/pre-proxysql.bash, need 4 parent traversals to reach repo root, not 3. Co-Authored-By: Claude Opus 4.6 (1M context) <noreply@anthropic.com>	2 months ago
Rene Cannao	75d958f29d	Fix hardcoded /home/rene/proxysql paths in pre-proxysql.bash scripts Replace hardcoded absolute paths with dynamically derived REPO_ROOT so these scripts work on any machine (CI runners, other developers). Co-Authored-By: Claude Opus 4.6 (1M context) <noreply@anthropic.com>	2 months ago
Rene Cannao	60b5aff5c4	Fix tests not running after infrastructure setup in multi-group runner The heredoc in run-multi-group.bash was causing bash to exit prematurely after ensure-infras.bash completed, without executing the test commands. This was due to shell expansion issues with the heredoc structure. Changes: - Replace heredoc with temp file approach in run-multi-group.bash - Add pre-proxysql hook call to ensure-infras.bash for cluster setup - Create legacy/pre-proxysql.bash for cluster node startup - Update mysql84/pre-proxysql.bash with cluster startup calls - Fix coverage collection to work correctly in parallel execution	2 months ago
Rene Cannao	758b8116c8	Fix reg_test_3223 RESTAPI test by adding TAP group setup hook Fix reg_test_3223-restapi_return_codes-t failure: 1. Created test/tap/groups/legacy/setup-infras.bash: - TAP group hook that copies RESTAPI scripts to ProxySQL data directory - Sets execute permissions on all scripts EXCEPT script_no_permissions - Keeps script_no_permissions without execute permissions for EACCES test 2. Modified test/tap/groups/legacy/env.sh: - Added REGULAR_INFRA_DATADIR=/var/lib/proxysql - Points to where scripts are mounted inside ProxySQL container This follows the architectural principle that test-specific setup belongs in TAP group hooks, not in the generic test runner or infrastructure scripts.	2 months ago
Rene Cannao	33aae3b1c2	Fix reg_test_3223 RESTAPI scripts path and add group env inheritance Fix reg_test_3223-restapi_return_codes-t failure by properly configuring REGULAR_INFRA_DATADIR in group environment files: 1. test/tap/groups/legacy/env.sh: Add REGULAR_INFRA_DATADIR pointing to test/tap/tests where reg_test_3223_scripts directory exists 2. test/tap/groups/mysql84/env.sh: Same REGULAR_INFRA_DATADIR setting 3. Create env.sh for feature-specific groups: - mysql-auto_increment_delay_multiplex=0 - mysql-multiplexing=false - mysql-query_digests=0 - mysql-query_digests_keep_comment=1 4. test/scripts/bin/proxysql-tester.py: Add fallback logic to load base group env.sh when subgroup env.sh doesn't exist (e.g., legacy-g1 falls back to legacy). This follows the same pattern as ensure-infras.bash. This follows the architectural principle that test-specific setup belongs in TAP group configuration, not in the generic test runner.	2 months ago
Rene Cannao	c7ce6b5b92	Eliminate global infrastructure defaults and implement context-aware host derivation - Refactor env-isolated.bash to remove hardcoded mysql84/pgsql16 fallbacks. - Update run-tests-isolated.bash to automatically derive DEFAULT_MYSQL_INFRA and DEFAULT_PGSQL_INFRA from infras.lst. - Create test/tap/groups/legacy/env.sh to explicitly map targets for the legacy group. - Ensure context-correct host resolution for all TAP tests.	2 months ago
Rene Cannao	c98f544db5	Enhance infrastructure stability and dynamic configuration - Implement clean slate logic in docker-compose-init.bash (stop containers + wipe data dirs). - Dynamically patch Orchestrator configurations with INFRA_ID-derived ROOT_PASSWORD. - Ensure all literal placeholders are preserved across all infrastructures. - Fix permission issues for PostgreSQL and MySQL log directories. - Verified successful infra-mysql57 initialization and ProxySQL registration.	2 months ago

10 Commits (mysqlx-plugin-impl)