Incident: Database table lost

This is a general forum about all topics, i.e. TrashMail.net, spam mails, email protection, privacy and other things.

Post Reply
Admin
Site Admin
Posts: 1286
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

Who is online

Users browsing this forum: Bing [Bot] and 1 guest