Currently the game uses a single-instance PostgreSQL in RDS, but I'd like to switch it over to my "serverless" Aurora cluster that is more robust because it's a cluster. Unfortunately, the Aurora is set to MySQL compatibility.
This will require a database wipe. I'm not interested in writing a complicated migration at this point.
All the Flyway scripts need to be updated to work on MySQL.
The docker-compose YAML needs to be switched to launch a MySQL container.
The PostgreSQL database driver needs to be switched to the MariaDB connector.
I think that's it?
The plan is to do this as soon as the "Map Generators" project is done.
Currently the game uses a single-instance PostgreSQL in RDS, but I'd like to switch it over to my "serverless" Aurora cluster that is more robust because it's a cluster. Unfortunately, the Aurora is set to MySQL compatibility.
The plan is to do this as soon as the "Map Generators" project is done.