by Vinicius Grippa | Jan 18, 2024 | Insight for DBAs, MySQL
In this blog post, we will discuss how to validate at the operating system level the effects of changing the innodb_flush_method to variations other than the default (particularly for O_DIRECT which is most commonly used) and the use of innodb_use_fdatasync.... by Vinicius Grippa | Aug 1, 2023 | Insight for DBAs, MongoDB, Percona Software, Security
This blog was originally published on August 10, 2020, and was updated on August 1, 2023. “I think most of the time hackers behind the attacks do it just for fun, because they can and because it’s very simple”, — says Diachenko. Source:... by Vinicius Grippa | Jul 10, 2023 | Insight for DBAs, MongoDB, Percona Software
Percona Backup for MongoDB (PBM) is a backup utility developed by Percona to address the needs of customers and users who prefer open source tools over proprietary software like MongoDB Enterprise and Ops Manager. PBM offers comprehensive support and ensures... by Vinicius Grippa | May 2, 2023 | Database Trends, Insight for DBAs, MySQL
Given the increasing popularity of ChatGPT in solving questions of humankind, I decided to take a better look at the current state of AI. At the same time that I see database engineers relying on the tool, sites such as StackOverflow are banning ChatGPT. As the... by Vinicius Grippa | Apr 17, 2023 | Insight for DBAs, MongoDB
In this blog post, we will discuss the best practices on the MongoDB ecosystem applied at the Operating System (OS) and MongoDB levels. We’ll also go over some best practices for MongoDB security as well as MongoDB data modeling. The main objective of this post... by Vinicius Grippa | Aug 10, 2022 | Insight for DBAs, MySQL
This blog post will discuss the newest feature available in MySQL 8.0.30: dynamic redo log sizing. After the InnoDB buffer pool size, we can say that having a proper size for the redo logs is crucial for MySQL performance. There are numerous blog posts about how to... by Vinicius Grippa | Feb 28, 2022 | Insight for DBAs, MySQL, Percona Software
A little bit ago, I released a blog post comparing the backup performance of different MySQL tools such as mysqldump, the MySQL Shell feature called Instance Dump, mysqlpump, mydumper, and Percona XtraBackup. You can find the first analysis here:Backup... by Vinicius Grippa | Dec 27, 2021 | Insight for DBAs, MySQL, Percona Software
In this blog post, we will compare the performance of performing a backup from a MySQL database using mysqldump, MySQL Shell feature called Instance Dump, mysqlpump, mydumper, and Percona XtraBackup. All these available options are open source and free to use for the... by Vinicius Grippa | Jun 3, 2021 | Insight for DBAs, MongoDB, Open Source
by Vinicius Grippa | Apr 28, 2021 | Insight for DBAs, MySQL, Percona Software
This blog post will show how to compile the Percona XtraBackup (PXB) tool for ARM. For this, we are going to use an AWS EC2 ARM instance with Ubuntu 20.04(Focal Fossa).The motivation for this was born in my interest in the new generation of ARM processors and if this... by Vinicius Grippa | Dec 2, 2020 | Insight for DBAs, MySQL, Percona Software
The benefits of jemalloc versus glibc memory allocator for use with MySQL have been widely discussed. With jemalloc (along with Transparent Huge Pages disabled) there is less memory fragmentation, and thus more efficient resource management of the server memory.... by Vinicius Grippa | Jun 30, 2020 | Insight for DBAs, MySQL
In this blog post, we will briefly explore the OS tool strace. It is not widely used due to its performance impacts, and we don’t recommend using it in production. Still, it is amazing at helping you understand some things that happen in MySQL, where the OS is... by Vinicius Grippa | Jan 8, 2020 | Monitoring, MySQL
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... by Vinicius Grippa | Aug 1, 2019 | MySQL
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... by Vinicius Grippa | Mar 13, 2019 | MySQL, Percona Software
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... by Vinicius Grippa | Mar 5, 2019 | Insight for DBAs, MySQL, Security, Webinars
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,... by Vinicius Grippa | Aug 7, 2018 | Insight for DBAs, MySQL
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... by Vinicius Grippa | Mar 28, 2018 | Insight for DBAs, Monitoring, MySQL
In this blog post, we’ll discuss some of the options available when purging binary logs. We’ll look at how to safely purge them when you have slaves in your topology and want to avoid deleting any binary log that still needs to be applied. Safely Purging...