Fixing Perl warning: setlocale: LC_CTYPE: cannot change locale

I use iTerm and SSH to connect to servers for executing various deployment and scripts for my daily basis activities. Basically, I spent 80% of my work hours on this black screen. Recently, I started seeing this error on my macOS: This is because if you are using SSH, there are 2…

Export The Slow_log Table To Slow Query Log File To Apply The Pt-query-digest

Working on customer cases always brings challenges. This week I got one where the customer provided the dump of mysql.slow_log table and it was necessary to analyze it. Unfortunately, pt-query-digest does not work with this format. Imagine the common scenario: you have AWS RDS instance running and the slow log…

Deploying Percona MySQL Server container in one command line

That’s it? Do I have to execute only this line? A: Yes. This article is a silver bullet for those who want to deploy a Percona Server MySQL to quickly test something and don’t want to waste time launching an EC2/RDS instance or installing MySQL in bare metal. So, let’s…

DBA Talk – What is Isolation Level

This week I came across a topic in a group of DBAs where the following statement was made: Oracle is the only DB where writing does not block reading and reading does not block writing Before we discuss whether Oracle is, in fact, the only RDBMS doing the above, what…

MongoDB: Execute backup + incremental restore using the oplog

I had a case a few days ago where the secondary node of a replica set went out-of-sync for days and could not recover because the oplog was rotated on the other nodes. However, the customer had the backup of the oplog and wanted to replay it since the full…

Webinar: Enhancing MySQL Security

A few days ago, I presented a webinar about security over MySQL. I covered a few topics and discussed the pros and cons of implementing those features. Below is the description of the webinar: Security is always a challenge when it comes to data. More so, regulations like GDPR add…

Ressincronizar Slave MySQL sem downtime com Percona Toolkit

Recentemente, trabalhei em um caso extremo em que um slave ficou dessincronizado, mas não pôde ser reconstruído do zero porque o slave estava agindo como um servidor master para uma aplicação e havia dados sendo gravados nele. Foi um erro de projeto e isso não é recomendado, mas aconteceu. Então,…

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

In this post, we will discuss a new feature – the MySQL 8.0.17 clone plugin. Here I will demonstrate how easy it is to use to create the “classic” replication, building the standby replica from scratch. The clone plugin permits cloning data locally or from a remote MySQL server instance. The…

A new blog is born

Welcome, everyone! This post is my first and brand new blog, and I hope that in this space, you might find useful content where you can learn, enjoy, and expand your knowledge. This blog is a democratic space where I hope to not only speak but listen and grow together.…