Implement In-Place Migration from MySQL 8.X to MariaDB 11X LTS

We want to provide a seamless in-place migration path from MySQL (focusing on version 8.x) to MariaDB to reduce dependency on Oracle, leverage MariaDB's open-source enhancements, and minimize downtime for users. This update refines the migration to target specific MariaDB versions: 11.4.x and 11.8.x.

Proposed Migration Behavior:

1. The user stops the MySQL service.
2. Uninstall MySQL packages.
3. Install MariaDB packages (targeting 11.4.x or 11.8.x).
4. Run a "reader capability" (e.g., an automated script or tool leveraging mariadb-upgrade) to interpret the existing MySQL data dictionary and system tables, converting them into MariaDB format without full data export/import. Account for version-specific incompatibilities, such as those in JSON handling, optimizer hints, or spatial functions between MySQL 8 and MariaDB 11.4/11.8.
5. Start the MariaDB service, which takes over the existing data directory.
6. Post-migration, the system runs exclusively on MariaDB, with automatic upgrades to system tables if needed.

To do:
1. Create sub-tasks for research on reader capability and other related compatibility issues (e.g. JSON), and implementation tickets

This approach leverages MariaDB's drop-in compatibility, allowing seamless upgrades from MySQL 8.

Acceptance Criteria:

1. Migration completes with zero data loss for standard schemas, tested on MySQL 8 to MariaDB 11.4.x and 11.8.x.
2. Handles databases >40GB without requiring full mysqldump (use in-place datadir preservation).
3. Includes validation checks for version-specific incompatibilities (e.g., pre-scan for MySQL 8 features not fully supported in 11.4/11.8, like certain JSON functions or authentication plugins).
4. Test on MySQL 8.0+ to MariaDB 11.4.8+ and 11.8.3+.