Browsing Category

MySQL-Articles

59 posts

MySQL related blog posts

Still have MySQL 5.6 variable binlog_error_action as IGNORE_ERROR?

Kedar
April 10, 2020

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…

View Post

ProxySQL Configuration File & Startup Process Explained

Kedar
October 8, 2019

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

View Post

MySQL backup shell script with status email

Kedar
April 9, 2019

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…

View Post

MySQL 8 Resource Group – introduction and dynamic allocation

Kedar
September 7, 2018

Introduction to resource groups in MySQL 8 and dynamical allocation to threads

View Post

Galera cluster to AWS Aurora migration & HA_ERR_FOUND_DUPP_KEY

Kedar
August 13, 2018

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…

View Post

Restore A Table / Database From Full Backup – Yet Another Way

Kedar
June 29, 2018

How to Restore A Table / Database From Full Backup using MySQL Grants & mysqldump.

View Post

Export MySQL database table to CSV (delimited / Excel) file

Kedar
January 29, 2018

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…

View Post

A tale of Corrupt InnoDB table, MySQL crash & recovery

Kedar
January 18, 2018

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…

View Post

Reset root password on Galera Cluster (Percona or MariaDB)

Kedar
April 11, 2017

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

View Post

MySQL to Galera Cluster Migration, Deadlock, Back to basics

Kedar
March 2, 2017

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…

View Post

MySQL-Articles

Still have MySQL 5.6 variable binlog_error_action as IGNORE_ERROR?

ProxySQL Configuration File & Startup Process Explained

MySQL backup shell script with status email

MySQL 8 Resource Group – introduction and dynamic allocation

Galera cluster to AWS Aurora migration & HA_ERR_FOUND_DUPP_KEY

Restore A Table / Database From Full Backup – Yet Another Way

Export MySQL database table to CSV (delimited / Excel) file

A tale of Corrupt InnoDB table, MySQL crash & recovery

Reset root password on Galera Cluster (Percona or MariaDB)

MySQL to Galera Cluster Migration, Deadlock, Back to basics

Recent Posts

Recent Comments