Migrate database to eu-west-1 - Githubissues

dracidoupe / graveyard

Open Source reimplementation of https://www.dracidoupe.cz/

https://nove.dracidoupe.cz/

MIT License

6 stars 4 forks source link

Migrate database to eu-west-1 #389

Closed Almad closed 2 years ago

Almad commented 2 years ago

[x] Turn off old version (lighty)
[x] Heroku maintenance mode
[x] DB export on the node
- [x] Local back up
[x] Terraform RDS in a new region (and related network etc.) https://github.com/dracidoupe/ddcz-box/commit/22a067b14460bd2edea69ea6a20b825474ccfeec
[x] Load data (and hope all encodings went well 😬 )
[x] Verify everybody is using the correct database
[x] Heroku maintenance off & lighty up
[x] Terraform delete old resources https://github.com/dracidoupe/ddcz-box/commit/32336b1ee13b8c516e48e87ec4f670e286480c10

Almad commented 2 years ago

Forgot to prepare on the various instance sizes, ahem.

SSD, 20 GB, oh with autoscale to 1TB:

HDD, 5GB:

SSD, 20GB gp2, no autoscale:

Almad commented 2 years ago

Going for magnetic now: let's think about SSD when migrating to postgres as that will require RDS cluster redo

Almad commented 2 years ago

ERROR 1044 (42000) at line 7367: Access denied for user 'root'@'%' to database 'mysql'

meh...so manual indeed

Almad commented 2 years ago

Old version now only having CRUD privileges