Not the answer you need?
Register and ask your own question!

MySQL instance Corruption

geofreyrgeofreyr EntrantInactive User Role Beginner
I have a 3 node cluster and one of the instances appears to be corrupted with the following during partial startup followed by instance crash:

InnoDB: is in the future! Current system log sequence number 139654003953.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files

I am wondering if I am able to recover this instance with the following methodology:

1. remove instance from cluster
2. start instance with force recovery parameter
3. identify corrupted table
4. drop table
5. import table from another instance
6. start instance
7. add back into cluster

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.