slider

Category: TwinDB

How we manage WordPress website with Terraform, Chef and GitHub

water drop falling

Our website twindb.com is built on WordPress software and has always been. A while ago we decided the website needs a better look. But not only that. Managing our old website was quite laborious and manual process which goes strongly against our culture at TwinDB to do things right. Few weeks ago we migrated to […]

Read More

How to Backup MySQL 5.7

If you ever tried to backup MySQL 5.7 with Percona Xtrabackup that comes in percona-xtrabackup package most likely you got error message like this:

This happens because percona-xtrabackup actually installs version 2.3 that doesn’t support MySQL 5.7. To take copies from MySQL 5.7 you need to use Percona XtraBackup version 2.4 and higher. Starting from […]

Read More

TwinDB Really Loves Backups

A week or two ago, one of my former colleagues at Percona Jevin Real gave a talk titled Evolving Backups Strategy, Deploying pyxbackup at Percona Live 2015 in Amsterdam. I think Jervin raised some very good points about where MySQL backup solutions in general fall short. There are definitely a lot of tools and scripts out there that claim to […]

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