slider

Category: MySQL Backup

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