Change Is Inevitable

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.… The post How to setup and use Percona Binlog Server (PBS) first appeared…

This article provides MySQL Major Version Upgrade Checklist along with video, one may follow to ease the upgarde task.

As a junior once I asked a seasoned MySQL DBA (Abuelo) “How do you stay so calm in critical situations?”

As a MySQL consultant, I keep running into the same two problems: reviewing MySQL configurations and generating realistic test data for validation.

During any MySQL major version upgrade, especially when moving from 8.0 to 8.4, it’s not just about compatibility checks.

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.

During a MySQL upgrade process the RDS replication between MySQL 8.0 and 8.4 was configured.

Ever spent your weekend debugging a MySQL production issue that could have been avoided with better configuration?

I’m working on sharing MySQL tips, tricks, and other related tech topics in my MySQL podcast.

I think we know that screen is officially old news and most modern Linux systems switched to tmux as the recommended multiplexer with RHEL 8.

You’ve got a shiny new Percona Monitoring & Management instance standing by and want to move existing users over.

Recently, a friend reached out to me for help after encountering an error while restoring a MySQL dump during an upgrade from MySQL 8.0 to 8.4.

Recently, I encountered a Percona Monitoring and Management (PMM) server that was rapidly approaching complete disk exhaustion.

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.

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.

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?

AI tools like ChatGPT, GROK, Meta and Gemini are taking off, and as parents, it’s easy to feel the pressure to keep our kids up to speed.

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… The post Podcast: Duplicate Indexes in MySQL first appeared on C…

Hello, readers!

In the world of database management, efficiency is key.

Interpreting the results and exit codes of your upgrade tests is essential for assessing the process’s outcome.

If you’ve encountered the “Encryption can’t find master key” error while starting MySQL, you’re likely facing issues with the keyring plugin.

These days MySQL consultants around me are busy assisting with MySQL 8 upgrades for those who couldn’t board the train before EoL.I was recently involved in one of the MySQL… The post MySQL 8 upgrade may fail using checkForServerUpgrade first appeared on…

Learn how to safely change primary keys in MySQL using pt-online-schema-change.

I encountered this error, “Error in my_thread_global_end(): xx threads didn’t exit“, while working on MySQL benchmarking using sysbench.

MySQL 8 is around us for 5 years now.

In this blog I share how MySQL binary logs get their unique numbers after noting my observations with MySQL binary logs sequencing.

Recently I noted a strange MySQL replication error in a Percona XtraDB Cluster (PXC) node replicating from a standard MySQL instance.

The year 2023 surely was a successful year in MySQL blogging.

The pt-query-digest is my go-to tool in order to perform slow query analysis, improve query performance and thus overall MySQL performance.

Welcome to the ultimate guide for MySQL issues debugging — your comprehensive MySQL checklist for tackling MySQL database environment challenges.

This blog post talks about one of the important MySQL configuration, sql_generate_invisible_primary_key, available in MySQL 8.0.30.

Do you know what lies inside your MySQL Data Directory?

Are you planning an upgrade for your Percona XtraDB Cluster (PXC)?

In this blog post, I want to share my experience and learning after challenging myself on my MySQL blog writing spree in recent past.

This blog is about a very odd case of a Federated table error causing unable reach the remote MySQL server and causing to error.

“How can we replicate without using binary logs” just a thought popped up in my brain during a casual discussion.

In a MySQL database, fragmentation can occur over time as data is inserted, updated, and deleted.

MySQL, a widely-used database management system, may show the warning “[Warning] Connection attributes of length 571 were truncated” in its error log.

I was attempting to download the MySQL slow query logs to perform a slow query review.

Bugs in database management systems can be a nightmare for administrators and developers.

This blog post serves as a work-log detailing the process of uninstalling and installing a specific version of Percona MySQL Server on Ubuntu.

Setting up replication in MySQL is a common DBA task.

This blog post serves as a work-log detailing the process of uninstalling and installing a specific version of Percona MySQL Server on CentOS.

A friend needed to analyze slow queries and for that he decides to use pt-query-digest tool.

In this blog, I will share the steps I took to debug an error ‘ERROR 1030 (HY000): Got error 168 – ‘Unknown (generic) error from engine’ from storage engine’ while… The post How to fix 1030 Unknown generic error from engine in MySQL first appeared on Chan…

A friend’s application started failing with MySQL causing error about timestamp columns and it needs urgent fixing from the database side.

In this blog we will create MySQL backup and then restore single table from Percona Xtrabackup without doing full restore.

Given the recent surge of interest in ChatGPT and the AI capabilities it offers, I decided to conduct an interview with it to assess its suitability for a MySQL Consultant… The post MySQL Interview – ChatGPT is not your DBA first appeared on Change Is Ine…

Percona Tech Days are free, half-day events dedicated to the most popular open source database technologies: PostgreSQL, MongoDB and MySQL.