How to setup and use Percona Binlog Server (PBS)
Kedar
Earlier last week I was working with Percona Binlog Server, Percona’s tool for archiving the MySQL binary log (binlog) outside of a traditional replica and exploring what it can do.…
Browsing Category
MySQL
127 posts
Articles related to MySQL, Percona Server, MariaDB
MySQL Major Version Upgrade Checklist – how to
This article provides MySQL Major Version Upgrade Checklist along with video, one may follow to ease the upgarde task.
InnoDB Flushing is simple – explained
As a junior once I asked a seasoned MySQL DBA (Abuelo) “How do you stay so calm in critical situations?”Abuelo DBA then uttered golden words: “Son, I keep my dirty…
MySQL Tools for Performance Tuning and Test Data Generation
As a MySQL consultant, I keep running into the same two problems: reviewing MySQL configurations and generating realistic test data for validation. So I built two focused MySQL tools to…
How to fix write latency in MySQL 8.4 Upgrade
During any MySQL major version upgrade, especially when moving from 8.0 to 8.4, it’s not just about compatibility checks. Subtle default changes can directly impact MySQL performance tuning, and if…
MySQL 8.4 disables AHI – Why and What you need to know
MySQL 8.4 changed the InnoDB adaptive hash index (innodb_adaptive_hash_index) default from ON to OFF, a major shift after years of it being enabled by default. Note that the MySQL adaptive hash index (AHI) feature remains fully available…