Monitoring MySQL Backups With Datadog and TwinDB Backup Tool
- ByMaksym Kryva•
- onJan 10, 2018•
- in Monitoring, MySQL Backup, TwinDB •
- tags backup, backup validation, datadog, monitoring, mysql, mysql monitoring, python integration, restore backup, xtrabackup
Monitoring MySQL backups is a vital part of any reliable backup solution. By monitoring the most common disaster recovery metrics, the Recovery Time Objective and the Recovery Point Objective, you can find out if a backup job was successful and produced a usable backup copy. The TwinDB Backup Tool along with Datadog allows monitoring both […]
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 […]
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 detail. Even if at first glance the six steps are simple, together they constitute something that is everything but easy to grasp. What’s Our Solution We decided to fix that. As a result, our very own TwinDB […]
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 the command line. Following commands are available:
proxysql-tools galera user list
proxysql-tools galera user create username [—-options]
proxysql-tools galera user delete username
proxysql-tools galera user modify username [—-options]
proxysql-tools galera user set_password username
You can set a user’s password at the time of creation with —-password option, or later on with the set_password sub-command. Create user Let’s add a […]
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:
# innobackupex ./
170623 05:58:43 innobackupex: Starting the backup operation
IMPORTANT: Please check that the backup run completes successfully.
At the end of a successful backup run innobackupex
prints "completed OK!".
170623 05:58:44 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' as 'dba' (using password: YES).
170623 05:58:44 version_check Connected to MySQL server
170623 05:58:44 version_check Executing a version check against the server...
170623 05:58:44 version_check Done.
170623 05:58:44 Connecting to MySQL server host: localhost, user: dba, password: set, port: not set, socket: not set
Error: Unsupported server version: '5.7.18-15'. Please report a bug at https://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 […]
ProxySQL Monitoring With Datadog
ProxySQL is a high performance proxy for MySQL and its forks. One of its key features is the 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. In addition, it’s the only open source proxy that […]
Show Differences Found by Pt-Table-Checksum
First of all,pt-table-checksum is perfect for checking if the master and its slaves are in-sync. It answers the question “Are the slaves consistent with the master?”. However, if they’re not, pt-table-checksum doesn’t actually tell you what exactly is wrong.
[root@master vagrant]# pt-table-checksum -q
TS ERRORS DIFFS ROWS CHUNKS SKIPPED TIME TABLE
09-03T22:21:10 0 1 2 1 0 0.013 mysql.proxies_priv
09-03T22:21:10 0 1 9 1 0 0.010 mysql.user
Frompt-table-checksum to pt-table-sync Nevertheless, pt-table-sync may give you a partial answer. It can print SQL statements to sync the replication […]
TwinDB Talks On Percona Live 2016
Percona Live is Christmas in the MySQL world. Naturally, it’s the time when friends and family come together. Everyone is talking about achievements of the year and making New Year’s resolutions. TwinDB at Percona This year, TwinDB does two talks. One about data recovery and the other about backups. The first one will be a […]
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 […]
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 […]