DB Cluster version update (upgrade from Aurora 1)

wellcomecollection / goobi-infrastructure

Wellcome Collection digital workflow infrastructure

MIT License

0 stars 3 forks source link

DB Cluster version update (upgrade from Aurora 1) #428

Closed mgeerdsen closed 2 years ago

mgeerdsen commented 2 years ago

We are currently using RDS with Aurora 1.22.x (based on MySQL 5.6), this should be updated to at least Aurora 2. Aurora 1 is supposed to be EOL'ed by end of 2/2023

mgeerdsen commented 2 years ago

Also the mariadb connector is dropping Aurora failover support. We will have to consider moving to https://awslabs.github.io/aws-mysql-jdbc/ e.g.

mgeerdsen commented 2 years ago

Both prod and staging are running on new Aurora 3 clusters. The old clusters have been deleted, final snapshots are available. Also the DB connector in Goobi workflow has been switched to the AWS MySQL one.

Staging is now running the latest Goobi workflow version with database performance fixes.

Prod is currently running a hotfix version and should be upgraded soon as well. Leaving this issue open, until prod has been updated as well.

mgeerdsen commented 2 years ago

Prod has been updated yesterday, so finally closing this.