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 […]
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 […]
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:
# innobackupex ./
17062305:58:43innobackupex:Starting the backup operation
IMPORTANT:Please check that the backup run completes successfully.
Atthe endofasuccessful backup run innobackupex
17062305:58:44version_check Connecting toMySQL server with DSN'dbi:mysql:;mysql_read_default_group=xtrabackup'as'dba'(using password:YES).
17062305:58:44version_check Connected toMySQL server
17062305:58:44version_check Executingaversion check against the server...
17062305:58:44Connecting toMySQL server host:localhost,user:dba,password:set,port:notset,socket:notset
Error:Unsupported server version:'5.7.18-15'.Please reportabug athttps://bugs.launchpad.net/percona-xtrabackup
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 […]
Introduction ProxySQL is a high performance proxy for MySQL and its forks. One of the key features is its ability to handle hundreds of thousands of connections with very low overhead. Some of the other key features are query caching, traffic mirroring, query routing and pluggable architecture. It is also the only open source proxy […]
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.
[root@master vagrant]# pt-table-checksum -q
TS ERRORS DIFFS ROWS CHUNKS SKIPPED TIMETABLE
pt-table-sync may give a partial answer. It can print SQL statements to sync the replication cluster. Reading the SQL […]
Percona Live is a Christmas in MySQL world. It’s time when all friends and family gather over a glass of beer. Everyone is talking about achievements of the last year and make New Year resolutions for a next one. There will be two talks from TwinDB this year. One is about data recovery and one […]
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 […]
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 […]
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 […]