Author - Vinicius Grippa

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).
Register Now
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, with […]

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