slider

Category: MySQL

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 details. Look, even if the six steps are simple, together they constitute something I cannot call simple. We decided to fix that. Our TwinDB Backup tool can take backups, can restore them, can copy files over the […]

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 command line. There are commands:

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

Read More

Show differences found by pt-table-checksum

pt-table-checksum perfectly solves problem of checking if master and its slaves are in-sync. It answers the question “Are the slaves consistent with the master?”. However if the answer is “No” pt-table-checksum doesn’t actually tell what exactly is different.

pt-table-sync may give a partial answer. It can print SQL statements to sync the replication cluster. Reading the SQL […]

Read More

Temporary table naming scheme in 5.6 and before

Benchmarking is a popular topic. People love drawing graphs as much as watching how X is 10% faster than Y; there must be something special in measurements. For a DBA, however, more tangible improvements come from less popular area of database maintenance. While MariaDB spreads FUD around InnoDB (nonetheless still uses it) I have to […]

Read More