Emergency

MySQL instance Corruption

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • MySQL instance Corruption

    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

    Regards,
    Geofrey.
Working...
X