MySQL Data Archiving basics – considerations, mistakes, best practices
Kedar
This blog is dedicated to MySQL data archiving; we’ll break down from the basics of what data archival is, why it matters, best practices and scenarios. We will also see…
Browsing Category
MySQL
127 posts
Articles related to MySQL, Percona Server, MariaDB
Killer Blog for MySQL Administrators
This is by far the most killer MySQL blog that I wanted to write for really long as a part of a Killer DBA series. Time is hard to find,…
MySQL 8 utf8mb4_0900_ai_ci collation confusion
Recently I was asked a question: Why am I getting utf8mb4_0900_ai_ci as the default collation in MySQL 8, despite setting the server to use utf8mb4_general_ci? With the upgrade to MySQL…
Podcast: Duplicate Indexes in MySQL
In this podcast, we’ll explore the issue of duplicate indexes in MySQL; including redundant index, foreign keys, left-prefixed secondary index /w primary key, and how to tackle the issue at…
MySQL Podcast – Practical Learning & Training
Hello, readers! I’m excited to announce the launch of my latest project: a dedicated MySQL Podcast! As a long-time MySQL enthusiast with extensive hands-on experience in database management, I understand…
MySQL Change Buffer – What When and FAQ
In the world of database management, efficiency is key. MySQL’s change buffer is a powerful feature that helps optimize how secondary index changes are managed. The idea of introducing a…