fix(ci): enable Group Replication recovery SSL in multi-db-docker-env and fix DB_PASS resolution in test_ha.sh

[jmrenouard]

Description

Fix Group Replication SSL recovery setting (group_replication_recovery_use_ssl=ON) in multi-db-docker-env and synchronize DB_PASS resolution with .env file in test_ha.sh to ensure all HA E2E tests (galera, innodb_cluster, replication) pass.

Changes Made

• multi-db-docker-env: Set group_replication_recovery_use_ssl=ON during InnoDB Cluster bootstrap and node join.
• build/test_ha.sh: Resolve DB_PASS dynamically from vendor/multi-db-docker-env/.env if present.

Assignee: @jmrenouard

[jmrenouard]

🛠️ Status Update

Resolution:
Group Replication SSL recovery setting (group_replication_recovery_use_ssl=ON) and DB_PASS resolution in test_ha.sh have been integrated.

🧪 Automated Test Proof

• Verified in test suite: tests/unit_ha_cluster.t

---

Tracked in MySQLTuner-perl v2.9.3.

[jmrenouard]

🛠️ Status Update

Resolution:
Group Replication SSL recovery setting (group_replication_recovery_use_ssl=ON) and DB_PASS resolution in test_ha.sh have been integrated.

🧪 Automated Test Proof

• Verified in test suite: tests/unit_ha_cluster.t

---

Tracked in MySQLTuner-perl v2.9.3.