slider

Category: TwinDB

How we manage WordPress website with Terraform, Chef and GitHub

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 setup a replication slave with TwinDB Backup tool

Setting up a replication slave is pretty straightforward, yet cumbersome process that needs a lot of attention to details. Look, even if the six steps are simple, together they constitute something I cannot call simple. We decided to fix that. Our TwinDB Backup tool can take backups, can restore them, can copy files over the […]

Read More

MySQL users management using ProxySQL Tools

Recently, we have implemented a set of new commands in ProxySQL Tools to manage MySQL users. You can create, delete, and modify users from command line. There are commands:

You can set a user’s password can be set at time of creation with —-password option or later on with  set_password sub-command. Create user Let’s add MySQL […]

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

Show differences found by pt-table-checksum

pt-table-checksum perfectly solves problem of checking if master and its slaves are in-sync. It answers the question “Are the slaves consistent with the master?”. However if the answer is “No” pt-table-checksum doesn’t actually tell what exactly is different.

pt-table-sync may give a partial answer. It can print SQL statements to sync the replication cluster. Reading the SQL […]

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 […]

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