+1 (844) 533-0409

Home

Backup and Data Recovery for MySQL

MySQL users management using ProxySQL Tools

By Maksym Kryva/on July 26, 2017/in MySQL, TwinDB/ tags mysql, proxysql, twindb / No Comments

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:

1

2

3

4

5

6

7

8

9

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 can be set at time of creation with —-password option or later on with set_password sub-command. Create user Let’s add MySQL […]

Logical MySQL Backup Tool Mydumper 0.9.1 Packages

By Aleksandr Kuzminsky/on July 5, 2017/in MySQL Backup/ tags mydumper / No Comments

The latest Mydumper 0.9.1 version is around for a while but we didn’t get to build packages for it. New features and bugfixes 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 Bugfixes. Good news we now build […]

How we use ProxySQL Tools

By Aleksandr Kuzminsky/on June 26, 2017/in MySQL/ tags aws, best practices, proxysql / No Comments

When we started working with a customer they asked us to setup for them more reliable and performant MySQL database. At the time they were using Percona XtraDB cluster with ELB to balance read traffic between PXC nodes. There was no writer redundancy – if a writer node was down, the app was down. The […]

How to backup MySQL 5.7

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

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:

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

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

Home

MySQL users management using ProxySQL Tools

Logical MySQL Backup Tool Mydumper 0.9.1 Packages

How we use ProxySQL Tools

How to backup MySQL 5.7

Setup high availability for ProxySQL via KeepAlived in AWS

Search

Find us on Facebook

Recent Posts

Categories

Home

MySQL users management using ProxySQL Tools

Logical MySQL Backup Tool Mydumper 0.9.1 Packages

How we use ProxySQL Tools

How to backup MySQL 5.7

Setup high availability for ProxySQL via KeepAlived in AWS

Search

Find us on Facebook

Recent Posts

Categories

Tags