slider

Author: Aleksandr Kuzminsky

TwinDB Talks On Percona Live 2016

planets

Percona Live is Christmas in the MySQL world. Naturally, it’s the time when friends and family come together. Everyone is talking about achievements of the year and making New Year’s resolutions. TwinDB at Percona This year, TwinDB does two talks. One about data recovery and the other about backups. The first one will be a […]

Read More

Data Loss After MySQL Restart

equipment

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

Read More

Recover Corrupted Or Crashed MySQL Database Online

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

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 a matching web interface. At first, it was a tool to estimate recovery chances from corrupted InnoDB tablespaces. Now, it’s an even more exciting and useful feature – recovery table structure from FRM files online. There are several methods to recover […]

Read More

How To Evaluate If MySQL Table Can Be Recovered

What Are the Odds a 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 it with 100% confidence, there are ways to estimate recovery chances. I will describe a few tricks. Generally speaking, if data is […]

Read More

Encrypting MySQL Backups

Encryption is an 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 as detailed as it gets, if you ask how secure the system is. Other important facts are often omitted, but, as we know, the devil is in […]

Read More

How To Setup MySQL Incremental Backup

TwinDB console

Incremental backups in MySQL have always been 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 […]

Read More