Ghost icon indicating copy to clipboard operation
Ghost copied to clipboard

Added innodb_force_recovery config to local mysql

Open allouis opened this issue 1 year ago • 0 comments

ref https://dev.mysql.com/doc/refman/8.4/en/forcing-innodb-recovery.html

Docker on MacOS can sometimes force quit the container and we end up with a broken MySQL container which can't boot. This config forced MySQL to attempt to recover the DB. The value of 6 is suggested by the logs when MySQL breaks - but this will open InnoDB in a readonly mode, which isn't suitable for us.

I think we wanna have a way to run this just once, and then exit, maybe with like yarn recover-db

allouis avatar Jul 02 '24 07:07 allouis