Incident: Database table lost

This is a forum about all kind of information about TrashMail.net related information, news and outages.

Post Reply
Admin
Site Admin
Posts: 1241
Joined: 16 Jun 2006, 08:55
Location: Germany
Contact:

Incident: Database table lost

Post by Admin » 10 Oct 2012, 09:33

We noticed this morning (thanks to a TrashMail customer for emailing us) that we lost a database table on our MySQL database server. It was an InnoDB table which has disappeared and could not be re-created again.
The whole system was unable to create new disposable email addresses or to let customers to log into the web address manager.

A dropping of the whole database and re-creating was not possible due the mysql internal structure was corrupt.
I had to delete the whole MySQL database directory, to recreate it and to play latest MySQL backup from our MySQL slave replication database.

I think it was a hardware or software failure which caused this corruption.
Now all is back online, replication service will be re-syncrhonized.

Thanks for the MySQL replication feature. Without that, there would had bee some data loss.
Best regards,
Stephan Ferraro
Founder of TrashMail.com
CEO of Aionda GmbH

Post Reply