+1 (844) 533-0409

Home

Backup and Data Recovery for MySQL

How to backup MySQL 5.7

By Aleksandr Kuzminsky/on June 23, 2017/in MySQL Backup, TwinDB/ tags backup, mysql, xtrabackup

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

1

2

3

4

5

6

7

8

9

10

11

12

13

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

Setup high availability for ProxySQL via KeepAlived in AWS

By Maksym Kryva/on May 15, 2017/in MySQL/ tags aws, keepalived, mysql, proxysql / No Comments

Usually application do not connect directly to Percona XtraDB Cluster, but go through a proxy – ProxySQL, for instance. However if only one proxy node is used it becomes a single point of failure. Not long ago Marco Tusa wrote about how to configure two ProxySQL nodes in front of XtraDB cluster. If deployed on EC2 instances it […]

RDS vs Aurora vs EC2 benchmark

By Aleksandr Kuzminsky/on April 28, 2017/in MySQL/ tags aurora, ec2, mysql, rds / No Comments

The goal of the benchmark is to compare performance and price/performance of Amazon RDS (Aurora) and MySQL server running on EC2 instance.

Howto Encrypt MySQL Backups on S3

By Aleksandr Kuzminsky/on March 28, 2017/in MySQL Backup/ tags backup, encryption, xtrabackup / No Comments

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.

ProxySQL Monitoring with Datadog

By Ovais Tariq/on January 19, 2017/in Monitoring, TwinDB/ tags datadog, monitoring, proxysql / No Comments

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

Home

How to backup MySQL 5.7

Setup high availability for ProxySQL via KeepAlived in AWS

RDS vs Aurora vs EC2 benchmark

Howto Encrypt MySQL Backups on S3

ProxySQL Monitoring with Datadog

Search

Find us on Facebook

Recent Posts

Categories

Home

How to backup MySQL 5.7

Setup high availability for ProxySQL via KeepAlived in AWS

RDS vs Aurora vs EC2 benchmark

Howto Encrypt MySQL Backups on S3

ProxySQL Monitoring with Datadog

Search

Find us on Facebook

Recent Posts

Categories

Tags