Upgrade MongoDB/PSMDB Standalone 3.4 to 3.6
In this blog post, I will share the necessary steps for a smooth upgrade from MongoDB (or Percona Server MongoDB) standalone version 3.4 to 3.6. I have plans to publish …
Blog
Monitor MySQL memory usage – Part 1 (Performance Schema)
On my day-to-day activities, one of the most classic cases that I get is: I think that my database has a memory leak. Where MySQL is spending so much memory? …
MySQL built-in function x user-defined function performance
In this article, I’m going to cover the use of built-in functions. The idea is to use the functions that MySQL has available instead of making custom functions (aka user-defined …
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. …
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 …
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 …
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 …
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 …
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 …
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 …