How to checksum on AWS RDS for MySQL Replication 8.0 > 8.4
Kedar
During a MySQL upgrade process the RDS replication between MySQL 8.0 and 8.4 was configured. I wanted to ensure the data was consistent for any random reason. This post is…
Browsing Category
MySQL tools
12 posts
MySQL tools
How to avoid data loss in MySQL Primary Key change
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.
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 filter MySQL slow queries using pt-query-digest
The pt-query-digest is my go-to tool in order to perform slow query analysis, improve query performance and thus overall MySQL performance. In this blog post, I’m going to highlight the…
Securing MySQL: Data Encryption with Percona Server and Vault
Percona Tech Days are free, half-day events dedicated to the most popular open source database technologies: PostgreSQL, MongoDB and MySQL. This talk for MySQL was related to MySQL Encryption with…
MySQL Backup setup, automation using Holland, mysqldump on Ubuntu
This post will guide you to set up and automate the MySQL logical backups using mysqldump on Ubuntu Linux. We will set-up MySQL backup using mysqldump and automate it with…