database dump Archive

MySQL – Corrupted InnoDB tables recovery – Step by step guide

InnoDB tables don’t get corrupted easily, but when they do, it usually happens because of hardware issues, power outages or MySQL bug. It leaves you with corrupted pages in InnoDB tablespace and recovering from that might be problem. When your MySQL properly crashes and doesn’t want to come back, you may see looping of ┬ásimilar

Migrating MongoDB databases

MongoDB (from “humongous”) is a scalable, high-performance, open source NoSQL database. Written in C++. A while ago I had to move some servers with MongoDB replica set from our current colocation to new provider Hetzner. There are few different ways to get this done: Get one member of replica set removed, create new MongoDB server