Verify MySQL Server support (may already exist)

[remcostoeten]

Summary

Confirm the state of MySQL Server support — it may already exist.

Context

• MySQL was added as a provisionable engine (commit bd9e56b).

Action

• Verify MySQL is fully wired (connect, query, mutate, provision via Docker manager).
• If anything is missing, file follow-ups; otherwise close as already-supported.

[remcostoeten]

Verified — MySQL Server support is fully wired, closing as already-supported:

• Connect: services/connection.rs builds a mysql_async pool from the URL (with connect timeouts and sane pool sizing since fix(rust): connection hygiene — redact secrets, connect timeouts, monitor deregistration, sane MySQL pooling #214)
• Query: database/mysql/execute.rs + parser.rs
• Schema: database/mysql/schema.rs (incl. is_primary_key metadata)
• Mutate: adapter/write_mysql.rs (canonical identifier quoting since fix(rust): canonical identifier quoting — escape TRUNCATE/INSERT/UPDATE paths across all dialects #216)
• Live monitor / seeding / dialect handling: wired, with a distinct MySqlDialect::MariaDb variant
• Provision via Docker manager: packages/studio/src/features/docker-manager/types.ts supports a mysql provider with version selection

As of PR #221 there is also live proof, not just inspection: tests/live_db_tests.rs runs the full grid mutation lifecycle (insert → update → delete → truncate) through the real MySqlAdapter against MySQL 8.4 and MariaDB 11.4 from docker-compose.databases.yml — both pass, and a weekly CI job (live-db-tests.yml) keeps them honest.