Author - Daniel Guzmán Burgos

Amazon RDS MySQL Minor Upgrades: Not So Fast!

aws rds mysql minor upgrades

The promise of DBaaS like RDS is to reduce operational overhead (among other things) and one of the stellar cases is upgrades (major and minor). The suggested procedure involves just a couple of steps. For example, using AWS Console, you can enable “Auto minor upgrade” or modify the DB instance and schedule the upgrade […]

Read more

MySQL Distributed Logical Backups: a Proof of Concept

MySQL Distributed Backups

The importance of having periodic backups is a given in Database life. There are different flavors: binary ones (Percona XtraBackup), binlog backups, disk snapshots (lvm, ebs, etc) and the classic ones: logical backups, the ones that you can take with tools like mysqldump, mydumper, or mysqlpump. Each of them with a specific purpose, MTTRs, […]

Read more

Contention in MySQL InnoDB: Useful Info From the Semaphores Section

Contention in MySQL InnoDB

In a high concurrency world, where more and more users->connections->threads are used, contention is a given. But how do we identify the contention point easily?
Different approaches had been discussed previously, like the one using SHOW ENGINE INNODB STATUS command output.
SEMAPHORES
The SEMAPHORES section displays all the metrics related to InnoDB mechanics on waits. This section […]

Read more

Grafana Plugins and Percona Monitoring and Management

grafana percona monitoring and management

Percona Monitoring and Management (PMM) is built upon the shoulder of giants like Prometheus and Grafana. And speaking of Grafana, one of the coolest features that come with it is the ability to customize the experience through 3rd party plugins.
Plugins are an easy way to enhance the ability to have specialized graphs. One case […]

Read more

Use MySQL Without a Password (and Still be Secure)

Use MySQL Without a Password

Some say that the best password is the one you don’t have to remember. That’s possible with MySQL, thanks to the auth_socket plugin and its MariaDB version unix_socket.
Neither of these plugins is new, and some words have been written about the auth_socket on this blog before, for example: how to change passwords in MySQL […]

Read more