An SSH key consists of a pair of files: the private key and the public key. The private key is confidential and should never be shared, while the public key enables you to log into the servers, containers, and VMs you set up. When creating these keys using the ssh-keygen command, the keys are stored…
That’s a Wrap: MySQL Belgian Days and FOSDEM 2024
Hey everyone! FOSDEM and MySQL Belgian days are over, and I wanted to share my impressions from an incredible 4-day journey filled with talks about databases and, of course, the famous Belgian beers. 🍻 🛬 Touchdown in Brussels After a whopping 16-hour flight from Sao Paulo, I arrived in Brussels on Wednesday, a day before…
The Power of MySQL Shell: A Guide to Create an InnoDB Cluster
Introduction The efficiency and reliability of database management systems are paramount. This blog post is your step-by-step guide to mastering the creation of an InnoDB Cluster from scratch using MySQL Shell. Let’s dive into the detailed steps. Prerequisites for Setting Up an InnoDB Cluster Laying the Groundwork: What You Need Before You Begin Before creating…
Adding a New MySQL Server to an InnoDB Cluster
Introduction It is possible to expand the capacity and the availability of an InnoDB Cluster by adding more MySQL servers. For example, a 5-node InnoDB cluster can tolerate up to 2 node failures, while a 3-node InnoDB cluster can tolerate only a single failure. Objective This guide will navigate you through the process of integrating…
Executing Switchover in InnoDB Cluster
Introduction The process of executing a switchover operation is important for an InnoDB cluster. It encompasses not merely routine maintenance but extends to recovery from system failures. The core of this operation involves promoting a replica node to the PRIMARY role methodically and securely. Objective This blog post is a comprehensive guide for database engineers…
MySQL Brazil Meetup 2023 – Informações do Evento e Agenda
Salve a todos os nerds! Temos definido nosso dia de banco de dados MySQL! Data: 02 de Dezembro, Sábado, 2023 Horário: 9:00 AM – 5:30 PM (Horário de Brasilia) Local: Oracle do Brasil Sistemas, Rua Dr. José Áureo Bustamante 455, bl. 110, São Paulo, SP, BR, 04710-090 Teremos um dia todo com palestras sobre…
[PT-BR] Rotacionando os logs de erro e consultas lentas do MySQL com logrotate
Banco de dados geram toneladas de logs, e é essencial gerenciá-los corretamente. Os logs ajudam os DBAs a entender o que está acontecendo nos bastidores, rastrear erros e otimizar o desempenho de consultas lentas. No entanto, esses logs podem se tornar um problema ao longo do tempo, especialmente se consumirem muito espaço em disco e…
Rotating MySQL Slow And Error Logs with logrotate
Databases generate tons of logs, and it’s essential to manage them correctly. Logs help DBAs understand what’s happening behind the scenes, trace errors, and optimize the performance of slow queries. However, these logs can become a hassle over time, especially if they consume too much disk space and are not appropriately managed. Why Rotate Logs?…
Understanding and Creating a Deadlock in MySQL for Beginners
Are you new to MySQL and hearing the term “deadlock” for the first time? Don’t worry! This article will explain a deadlock and provide a simple guide on simulating one. What is a Deadlock? A deadlock happens when two transactions block each other, waiting for the other to finish, but neither can proceed. Think of…
Profiling MySQL using perf and Flame Graphs
A common task in performance analysis is identifying which code sections consume the most CPU time. This often requires profiling stack traces. Enter Flame graphs – a game-changer in how we visualize these profiles. They provide an intuitive visual representation of the application’s most CPU-intensive parts. In this article, we’ll take a look at how…