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…
Author: Vinicius Grippa
How to Add a New MySQL Server Node 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…
How to Execute a 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…
How to Rotate MySQL Slow and Error Logs Using 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…
The Ins and Outs of innodb_flush_log_at_trx_commit
Today, we’re going to take a journey through one of MySQL’s performance guardians – the innodb_flush_log_at_trx_commit. The innodb_flush_log_at_trx_commit has 3 valid values: 0, 1, and 2. Let’s see each of them. Option 1: The Safe Harbor (innodb_flush_log_at_trx_commit = 1) By default, MySQL is set up with a focus on safety. Imagine this as saving your…
How To Estimate Redo Log Capacity
With MySQL 8.0.30 comes a feature that is a game changer in ensuring optimal MySQL performance – the dynamic redo log sizing. Overcoming Previous Limitations Before version 8.0.30 came into play, redo log configuration was static, set once during database setup and rarely touched thereafter due to the MySQL restart required to effect any changes…