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 Holland backup framework on Ubuntu. Towards the end of the post, you have the steps to be executed in a single block which includes steps […]

The post MySQL Backup setup, automation using Holland, mysqldump on Ubuntu first appeared on ..::CHANGE is INEVITABLE::...

Recently, we were affected by an ignored configuration option introduced in MySQL 5.6. This incident caused us to perform extended planning of downtime and the rebuilding of the slave. In this post, we’ll discuss our encounter with binlog_error_action and likely bad default. The incident started with an alert from our monitoring platform that a check […]

The post Still have MySQL 5.6 variable binlog_error_action as IGNORE_ERROR? first appeared on ..::CHANGE is INEVITABLE::...

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::...