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:
- remove instance from cluster
- start instance with force recovery parameter
- identify corrupted table
- drop table
- import table from another instance
- start instance
- add back into cluster
Regards,
Geofrey.