This post covers Proxysql start up process, Layers and configuration file.

The post ProxySQL Configuration File & Startup Process Explained 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 backup shell script works as follows: – The script takes backup using mysqldump and compresses it. – Upon success, it will attempt to ship the […]

The post mysql database backup shell script with status email first appeared on ..::CHANGE is INEVITABLE::...

This blog post gives an introduction to resource groups in MySQL 8 and dynamical allocation to threads, as well as a related bug report.

The post MySQL 8 Resource Group - introduction and dynamic allocation first appeared on ..::CHANGE is INEVITABLE::...

In this post we will see a case study of a Galera Cluster migration to AWS Aurora and quick solution to the replication issue. A friend received an error in a Master-Master replication as follows: Could not execute Write_rows event on table _database._table; Duplicate entry '65eJ8RmzASppBuQD2Iz73AAy8gPKIEmP-2018-08-03 08:30:03' for key 'PRIMARY', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; […]

The post Galera cluster to AWS Aurora migration & HA_ERR_FOUND_DUPP_KEY 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 tables to CSV on forums. Since I saw the question often, I thought of writing out all the ways I can think of for exporting […]

The post Export MySQL database table to CSV (delimited / Excel) file first appeared on ..::CHANGE is INEVITABLE::...

I’m going to narrate you a story that happened around a crashing MyQL, Corrupted InnoDB table and finally the recovery by table restore. We will see how our database administrator detected the issue and what he did to resolve it. A day in MySQL Database Consultant’s day was taking its shape while a friend called […]

The post A tale of Corrupt InnoDB table, MySQL crash & recovery first appeared on ..::CHANGE is INEVITABLE::...

Reset MySQL root password for Galera Cluster ( Percona Xtradb / MariaDB )

The post Reset root password on Galera Cluster (Percona or MariaDB) first appeared on ..::CHANGE is INEVITABLE::...

This post is a lab experiment learning from migration to the Percona Xtradb Cluster (Galera) and a very unexpected DEADLOCK scenario which took me back to basics. (root@localhost) [test]>insert into app values (1); ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction Little background: We needed to work on migrating the […]

The post MySQL to Galera Cluster Migration, Deadlock, Back to basics first appeared on ..::CHANGE is INEVITABLE::...

Learning from facepalm moments of a MySQL database restore from Percona Xtrabackup.

The post Restoring MySQL Database from xtrabackup - facepalm moments first appeared on ..::CHANGE is INEVITABLE::...