Importing large MySQL tables from command line

As you may think this is a trivial thing, it actually isn’t. You can try and import 100GB .sql file and you will fail trying (Assuming you use default MySQL configuration). Recently I had some issues importing really large databases/tables, so I decided to share some of my settings that helped me import faster and

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

Howto: Libvirt, Vyatta, Failover IP and Hetzner

Overview We will use 2 Vyatta routers, make one primary gateway for all internal servers and when primary Vyatta crashes, the backup router will take gateway IP with help of VRRP and aditionally switch frontend Failover IP from one server to another. Prerequisites 2 physical servers on Hetzner Failover IP Internal NIC in both servers, to

LVM Snapshots

What’s purpose of LVM snapshot? Purpose of LVM snapshots is quite simple. We want “point in time” copy of our LV, and snapshot helps us with that, by writing only differences on the snapshot. Why would I do that? It’s ideal for backing up virtual machines or other servers during their operation, since snapshot takes

Loadbalancing / failover with IPVS and keepalived

Introduction Correct failover and loadbalancing is crucial for high availablility environment. With proper setup we can eliminate single points of failure in case of server crash. I use linux kernel’s support for load balancing, since that seems as well documented and scalable method. What I want to achieve here, is actually fully redundant architecture, so