slider

Tag: mysql

Monitoring MySQL Backups With Datadog and TwinDB Backup Tool

TwinDB + Datadog

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

Read More

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

Read More

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

Read More

Setup High Availability For ProxySQL via KeepAlived In AWS

Usually application don’t 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 […]

Read More