Change Is Inevitable
  • Home
  • MySQL
    • MySQL-Articles
    • MySQL-Scripts
    • MySQL Resources
  • Technical
    • QA-Testing
  • General
    • Review
    • Just for fun
    • Personal
  • Contact Me
    • Copyright
Change Is Inevitable

Kedar Vaijanapurkar's Blog for MySQL, technology and various subjects

  • Home
  • MySQL
    • MySQL-Articles
    • MySQL-Scripts
    • MySQL Resources
  • Technical
    • QA-Testing
  • General
    • Review
    • Just for fun
    • Personal
  • Contact Me
    • Copyright

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

Posts navigation

Previous 1 2 3 … 6 Next
Search:
... ...

Latest Posts

  • Install exact version of Percona Server for MySQL on CentOS
  • MySQL Slow query log export and review in RDS
  • 1030 Unknown generic error from engine in MySQL
  • MySQL 8 – timestamp cannot be null and explicit_defaults_for_timestamp
  • Restore single MySQL table (ibd) from Xtrabackup (video demo)
Recent Posts
  • Install exact version of Percona Server for MySQL on CentOS
  • MySQL Slow query log export and review in RDS
  • 1030 Unknown generic error from engine in MySQL
  • MySQL 8 – timestamp cannot be null and explicit_defaults_for_timestamp
  • Restore single MySQL table (ibd) from Xtrabackup (video demo)
Recent Comments
  • Shubham Sahu on MySQL database restore issues using xtrabackup – facepalm moments
  • Kedar on Download MySQL’s Automatic Random Test Data Generator
  • Kedar on MySQL to Galera Cluster Migration, Deadlock, Back to basics
  • offpageanil@gmail.com on MySQL to Galera Cluster Migration, Deadlock, Back to basics
  • Sarthak on Computer usage and maintenance-my 10 practices
Change Is Inevitable
Designed & Developed by Code Supply Co.