How to avoid data loss in MySQL Primary Key change
Kedar
Learn how to safely change primary keys in MySQL using pt-online-schema-change. This blog highlights tips to avoid data loss during online alter of primary key.
Browsing Category
MySQL
124 posts
Articles related to MySQL, Percona Server, MariaDB
MySQL Benchmarking and error in my_thread_global_end()
I encountered this error, “Error in my_thread_global_end(): xx threads didn’t exit“, while working on MySQL benchmarking using sysbench. In this blog I’ll share my experience, reveal the fix, and help…
How to save money in AWS RDS – Upgrade to MySQL 8
MySQL 8 is around us for 5 years now. I believe you’re surely considering an upgrade. But if you’re on AWS and still on an older version of MySQL, this…
How MySQL Binary Log Gets Its Number
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 an odd binary log sequencing…
Node has dropped from cluster error in Galera Cluster
Recently I noted a strange MySQL replication error in a Percona XtraDB Cluster (PXC) node replicating from a standard MySQL instance. “Node has dropped from cluster”. This is a quick blog…
A year in MySQL Blogging – top blogs, summary and review
The year 2023 surely was a successful year in MySQL blogging. I managed to publish 24 MySQL blogs in total both personal and Percona blog. This post is a reflection…