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 […]
Verify MySQL Backups With TwinDB Backup Tool
If you don’t verify backups you may safely assume you don’t have them. It often happens that MySQL backups can be invalid or broken due to a software bug, or some hidden corruption. If you are lucky enough, hours and days will be needed to resurrect a database from a bad backup copy. If you […]
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 […]
Logical MySQL Backup Tool Mydumper 0.9.1 Packages
The latest Mydumper 0.9.1 version has been around for a while, but we didn’t get to build packages for it. New features and bug fixes were announced in Mydumper 0.9.1 Release Note. Briefly, the new features are: Full schema support for Mydumper/Myloader Locking reduce options GTIDs and Multisource Slave Myloader single database restore Bug fixes Good news […]
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 […]
How To Encrypt MySQL Backups on S3
TwinDB Backup supports encrypted backup copies since version 2.11.0. As usual the tool supports natively backup and restore operations, if backup copies are encrypted the tool takes care of decryption.
Building RPM On Travis-CI In Docker Containers
Travis-CI is a crucial component of Continuous Integration/Continuous Deployment. We use it a lot to run unit tests and build/upload Python modules. Recently I had to solve a problem of building RPMs on Travis-CI with Docker containers. In this post I will describe step-by-step how to do that. We distribute our backup tool as RPM packages […]
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 […]
Mydumper RPM Now Available For CentOS/RHEL 6 and 7
Mydumper is a a tool for fast reliable logical backups. It’s an alternative to mysqldump that has many advantages over it, some of which you can find below: Unlike mysqldump, mydumper is a multi-threaded backup tool, which makes it a lot faster. This is especially helpful if you have very fast storage like SSDs. And you can utilize […]