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…
The post MySQL 8 utf8mb4_0900_ai_ci collation confusion first appeared on Change Is Inevitable.
Interpreting the results and exit codes of your upgrade tests is essential for assessing the process’s outcome. In this blog, we’ll explore the significance of pt-upgrade return codes and how…
The post Understanding Return Codes of pt-upgrade: A quick guide first appeared on Change Is Inevitable.
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…
The post A year in MySQL Blogging – top blogs, summary and review first appeared on Change Is Inevitable.
This ProxySQL post is sourced from an error I faced recently ProxySQL has become one of the popular choice as the “proxy” for MySQL databases. This post is tipping you…
The post Can not connect to ProxySQL: reasons and fixtures first appeared on Change Is Inevitable.
This post is for the backup script for MySQL database on Linux with mail. It’s a linux shell script for taking logical backup using mysqldump and sending status email. The…
The post MySQL backup shell script with status email first appeared on Change Is Inevitable.
How to Restore A Table / Database From Full Backup using MySQL Grants & mysqldump.
The post Restore A Table / Database From Full Backup – Yet Another Way first appeared on Change Is Inevitable.
Today lets talk a little about converting a MySQL table to CSV (Excel). My friend was looking to export MySQL to Excel, I saw couple of questions for export MySQL…
The post Export MySQL database table to CSV (delimited / Excel) file first appeared on Change Is Inevitable.
FATAL: Cannot connect to MySQL server on 'localhost': Cacti Error - Solution to the issue while setting-up.
The post Cannot connect to MySQL server on ‘localhost’: Cacti Error first appeared on Change Is Inevitable.
I really enjoy using cloud-based virtual servers for testing MariaDB and MySQL deployments. With automation scripts, it's fast and easy to create environments that match what customers are using to solve issues quicker. For example, with just a couple of commands, we can bring up a replication cluster with one master and two slaves, running a specific MySQL version, and run tests to find a memory leak.
MariaDB 5.5.38 was recently released (it is the latest MariaDB 5.5), and is available for download here:
https://downloads.mariadb.org/mariadb/5.5.38/
This is a maintenance release, and so there are not too many big changes of note, just a number of normal bug fixes. However, there are a few items worth mentioning: