Author - Vinicius Grippa

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

Upcoming Webinar Thurs 3/7: Enhancing MySQL Security

Enhancing MySQL Security Webinar

Join Percona Support Engineer, Vinicius Grippa, as he presents his talk Enhancing MySQL Security on Thursday, March 7th, 2019 at 7:00 AM PST (UTC-8) / 10:00 AM EST (UTC-5).
View the Recording
Security is always a challenge when it comes to data. What’s more, regulations like GDPR add a whole new layer on top of it, […]

Read more

Replicating from MySQL 8.0 to MySQL 5.7

replicate from MySQL 8 to MySQL 5.7

In this blog post, we’ll discuss how to set a replication from MySQL 8.0 to MySQL 5.7. There are some situations that having this configuration might help. For example, in the case of a MySQL upgrade, it can be useful to have a master that is using a newer version of MySQL to an older […]

Read more