Relay log read failure | 2 many dots can break your replication only once
Kedar
Two or more dots in your relay log or binary log names can break replication; but worry not, it will only do it once. If you request to start again,…
Browsing Category
MySQL
86 posts
MySQL
MySQL Backup setup, automation using Holland, mysqldump on Ubuntu
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…
Still have MySQL 5.6 variable binlog_error_action as IGNORE_ERROR?
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…
ProxySQL Configuration File & Startup Process Explained
This post covers Proxysql start up process, Layers and configuration file.
MySQL 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…
MySQL 8 Resource Group – introduction and dynamic allocation
Introduction to resource groups in MySQL 8 and dynamical allocation to threads
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…
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…
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…
Recent Comments