slider

Author: Aleksandr Kuzminsky

Data loss after MySQL restart

equipment

Not so long ago I had a customer who experienced data loss after MySQL restart. It was really puzzling. MySQL was up & running for many months, but after the customer restarted MySQL server all tables have gone. The tables were still visible in SHOW TABLES output, but they were not readable:

Read More

Recover corrupted or crashed MySQL database online

Earlier before we blogged about ways to recover corrupt MySQL database with TwinDB Data Recovery Toolkit. However learning curve of the toolkit is rather steep. It takes time to get familiar with InnoDB internals and the tool. And let’s be honest nobody gets prepared for data loss – people who prepare for disaster recovery take […]

Read More

How to recover table structure from FRM files online

Recently we announced MySQL Data Recovery Portal. Here we automated some data recovery routines and published web interface to them. First, it was a tool to estimate recovery chances from corrupted InnoDB tablespaces. Now it’s even more exciting and useful feature – recovery table structure from FRM files online. There are several methods to recover MySQL table […]

Read More

How to evaluate if MySQL table can be recovered

What are odds MySQL table can be recovered? This is the most asked question. Every single customer asks if their MySQL table can be recovered. Although it’s not possible to answer that with 100% confidence there are ways to estimate recovery chances. I will describe few tricks. Generally speaking, if data is on media there […]

Read More

Encrypting MySQL Backups

Encryption is important component of secure environments. While being intangible property security doesn’t get enough attention when it comes to describing various systems. “Encryption support” is often the most of details what you can get asking how secure the system is. Other important details are often omitted, but the devil in details as we know. […]

Read More

Building XtraBackup for Mac OS

Percona XtraBackup is free and open source backup tool for MySQL. Percona distributes XtraBackup via package repositories for RedHat and Debian. Unfortunately there are no packages for Mac OS. In this post I will describe how to build XtraBackup for Mac OS. Dependencies To build and use XtraBackup on Mac OS you need to install some additional packages. I will […]

Read More

How to setup MySQL incremental backup

TwinDB console

Incremental backups in MySQL were always a tricky exercise. Logical backup tools like mysqldump or mydumper don’t support incremental backups, although it’s possible to emulate them with binary logs. And with snapshot-based backup tools it’s close to impossible to take incremental copies. Percona’s XtraBackup does support incremental backups, but you have to understand well how […]

Read More