Author - Vinicius Grippa

Analyzing MySQL with strace

Analyzing MySQL with strace

In this blog post, we will briefly explore the OS tool strace. It is not widely used due to its performance impacts, and we don’t recommend using it in production. Still, it is amazing at helping you understand some things that happen in MySQL, where the OS is involved, and as a last case […]

Read more

MongoDB Best Practices 2020 Edition

MongoDB Best Practices 2020

In this blog post, we will discuss the best practices on the MongoDB ecosystem applied at the Operating System (OS) and MongoDB levels. The main objective of this post is to share my experience over the past years tuning MongoDB and centralize the diverse sources that I crossed in this journey in a unique […]

Read more

Enable LDAP on Percona Monitoring and Management (PMM)

Percona Monitoring and Management (PMM) has been on the road for a while now, and it brings exciting new features and improvements. For those who are not familiar with the tool, PMM allows deep insight into the performance of applications and databases. The most crucial highlight: it is 100% open-source. Also, the source code is […]

Read more

MySQL 8.0.17 Clone Plugin: How to Create a Slave from Scratch

MySQL 8.0.17 Clone Plugin

In this post, we will discuss a new feature – the MySQL 8.0.17 installing other plugins. Below is the command line to install the clone plugin:

MySQL

master [localhost:45008] {msandbox} ((none)) > INSTALL PLUGIN clone SONAME ‘mysql_clone.so’;
Query OK, 0 rows affected (0.00 sec)

12

master [localhost:45008] {msandbox} ((none)) > INSTALL PLUGIN clone SONAME ‘mysql_clone.so’;Query OK, 0 rows affected […]

Read more

Live MySQL Slave Rebuild with Percona Toolkit

MySQL slave data out of sync

Recently, we had an edge case where a MySQL slave went out-of-sync but it couldn’t be rebuilt from scratch. The slave was acting as a master server to some applications and it had data was being written to it. It was a design error, and this is not recommended, but it happened. So how do […]

Read more