Showing entries 1 to 10 of 47
10 Older Entries »
Displaying posts with tag: MySQL-Articles (reset)
ProxySQL Configuration File & Startup Process Explained

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

mysql database backup shell script with status email

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 […]

MySQL 8 Resource Group – introduction and dynamic allocation

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

Galera cluster to AWS Aurora migration & HA_ERR_FOUND_DUPP_KEY

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; […]

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

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

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

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 […]

A tale of Corrupt InnoDB table, MySQL crash & recovery

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 […]

Reset root password on Galera Cluster (Percona or MariaDB)

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

MySQL to Galera Cluster Migration, Deadlock, Back to basics

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 […]

Restoring MySQL Database from xtrabackup – facepalm moments

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

Showing entries 1 to 10 of 47
10 Older Entries »