slider

Category: Infrastructure as Code

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

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

Show Differences Found by Pt-Table-Checksum

Louvre Museum

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

Read More

Efficient Use Of Indexes In MySQL

These are the slides of the “Efficient Use Of Indexes In MySQL” talk we delivered on the SFMySQL Meetup. This is an introductory talk for developers on MySQL indexes. In my opinion, it’s quite important to understand how InnoDB organizes data. If you know how MySQL accesses data, it’s easier to write optimal queries. When working […]

Read More