Compiling MySQL (Desmistifying)
Today we are going to talk about a topic that many people are afraid of. We know that MySQL is open-source, but there are some steps from the code until …
Percona MongoDB incremental backup and PITR feature
Percona released Percona Backup MongoDB version 1.3.1 and it brings a feature that was hugely expected by the community. It’s the ability to perform consistent incremental backups. This allows us …
How To Ask For Help and How To Help
We as homo sapiens own our great success as a specie due to our capacity of collaboration in a group rather than being individualists. For example, a simple pencil requires …
The 5th dimension of MongoDB: Adjusting Eviction Threads
In certain situations, MongoDB can’t keep up with the dirty cache flushing. For these cases where the pressure on the cache is high, it might be necessary to adjust the …
Melhorando a performance da replicação do MySQL
Este post é o meu primeiro após o blog ter um novo design! Yayyy! Espero que vocês gostem e lembre-se: o feedback é sempre bem-vindo! Uma das perguntas mais comuns …
Boosting MySQL Replication
This post is my first one after the blog got a new design! Yayyy! I hope you guys enjoy it and remember: feedback is always welcome! One of the most …
Create a XFS filesystem using LVM
In this blog post, I will demonstrate how to use LVM to create flexible XFS filesystems where it allows us to extend or reduce its size without disrupting services. Instructions …
Stop Fake News! The most common fake news about MySQL (contains bad language)
Since I have been working with MySQL, I saw a lot of comments about the MySQL ecosystem, which, if they are not made in a bad intention to sell commercial …
Toss a coin to your DBA: Estimate MySQL Redo Log Size
Having a right REDO log size is fundamental for MySQL to run smoothly without struggling. An undersized REDO can even lead to errors in operations! For example, this week, a …
Install Valgrind
This post is intended to demonstrate how to install Valgrind in a Centos/Red Hat and Debian/Ubuntu environment. Valgrind is a programming tool for memory debugging, memory leak detection, and profiling. The …