slider

Category: TwinDB

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