Fix group replication for MySQL 8.4+: removed/deprecated options

[renecannao]

Bug Report

Group replication deployment fails on MySQL 8.4+ with:

unknown variable 'transaction_write_set_extraction=XXHASH64'

Root Cause

MySQL 8.3+ removed transaction_write_set_extraction (deprecated since 8.0.26). Several other deprecated options exist in group replication templates.

Issues found

Critical (causes startup failure):

1. transaction_write_set_extraction=XXHASH64 in sandbox/templates/group/group_repl_options.gotxt:9 — removed in 8.3+

Deprecated (warnings, will break in future):
2. log_slave_updates=ON in sandbox/templates/group/group_repl_options.gotxt:4 — should be log_replica_updates=ON for 8.0.26+
3. log_slave_updates=ON in sandbox/pxc_replication.go:228 — same issue

Removed SQL commands:
4. reset master in sandbox/templates/group/init_nodes.gotxt:11 — removed in 8.4+, should be RESET BINARY LOGS AND GTIDS
5. reset master in sandbox/templates/single/clear.gotxt:46 — same
6. reset master in sandbox/templates/single/replicate_from.gotxt:153 — same
7. reset master in sandbox/templates/replication/multi_source.gotxt:7 — same

Fix approach

• Version-conditional in group_repl_options.gotxt: omit transaction_write_set_extraction for 8.3+, use log_replica_updates for 8.0.26+
• Shell-based version detection for RESET MASTER vs RESET BINARY LOGS AND GTIDS in affected templates
• Same approach used for SHOW MASTER STATUS fix in PR Fix MySQL 8.4+/9.x replication compatibility #21

Tested

# Fails on 8.4.4 and 9.1.0:
dbdeployer deploy replication 8.4.4 --topology=group --sandbox-binary=$HOME/opt/mysql

[coderabbitai]

🔗 Related PRs

#22 - Add MySQL integration tests (8.0, 8.4, 9.1) [closed]
#23 - Fix remaining templates for MySQL 8.4+ replication syntax [closed]

---

📝 Issue Planner

_{Check the box below or use the @coderabbitai plan command to generate an implementation plan and prompts that you can use with your favorite coding assistant.}

• Create Plan

---

🧪 Issue enrichment is currently in open beta.

You can configure auto-planning by selecting labels in the issue_enrichment configuration.

To disable automatic issue enrichment, add the following to your .coderabbit.yaml:

issue_enrichment:
  auto_enrich:
    enabled: false

💬 Have feedback or questions? Drop into our discord!