Author - Daniel Guzmán Burgos

Deploying the Percona Kubernetes Operator for XtraDB Cluster in Amazon (AWS)

Percona Kubernetes Operator for Percona XtraDB Cluster in AWS

Being that Amazon is one of the most-used cloud vendors, it is only natural that one may ask “How can Kubernetes be used in AWS?“. And the answer is – not that different than with other cloud vendors. What one needs is two things (and this applies universally): a Kubernetes cluster + the Percona […]

Read more

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