Change Is Inevitable

This ProxySQL post is sourced from an error I faced recently ProxySQL has become one of the popular choice as the “proxy” for MySQL databases.

In the MySQL world, I am surrounded by some of the best database consultant, it brings them immense joy about having a “Friday”, so much so that they cannot believe… The post Providing Friday Proofs to MySQL Consultants | Scripts Functions Routines first…

MySQL is one of the top used database system and with highly active community.

Two or more dots in your relay log or binary log names can break replication; but worry not, it will only do it once.

This post will guide you to set up and automate the MySQL logical backups using mysqldump on Ubuntu Linux.

Recently, we were affected by an ignored configuration option introduced in MySQL 5.6.

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

This post is for the backup script for MySQL database on Linux with mail.

दुर्गे दुर्घट भारी – श्री देवीची आरती Durge Durghat Bhari दुर्गे दुर्घट भारी तुजविण संसारी ।

Introduction to resource groups in MySQL 8 and dynamical allocation to threads 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.

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

Today lets talk a little about converting a MySQL table to CSV (Excel).

I’m going to narrate you a story that happened around a crashing MyQL, Corrupted InnoDB table and finally the recovery by table restore.

In this post we will see how to pause (suspend) and start a linux process using signals (SIGTSTP and SIGCONT) via kill command.

In this post we will understand how to decode Seibel Audit Trail using PLSQL.

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.

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.

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

This post explains on the usage of mysql_repair_threads for repairing myisam table & the processlist status Repair with N threads The post corrupted / crashed MyISAM + mysql_repair_threads = stuck “Repair with N threads” first appeared on Change Is Inevit…

This blog post explores the syncing options for an inconsistent MySQL slave of Galera cluster node using pt-table-sync The post Fixing inconsistency on MySQL Slave of Galera Cluster first appeared on Change Is Inevitable.

This is a quick setup guide of 10-steps to install and configure (multiple) MySQL instance on 3307 port, and make it slave from MySQL running on port 3306.

This post discuss the pt-table-checksum & error "Waiting to check replicas for differences: 0% 00:00 remain" with a use-case and solution.

We already have seen two articles for setting up MySQL Monitoring with Nagios and Percona Monitoring Tools for Nagios.

MySQL ERROR 1018 (HY000): Can't read dir of '.

It’s important to monitor the (database) backups after you set-it-up.

Recently a friend asked about Installing Percona Monitoring Tools for Nagios as he was facing a few issues.

UMASK and UMASK_DIR are amongst few MySQL Environment variables which defines directory and file creation modes (file permissions).

Often we come across requirement for Siebel to integrate with external applications.

Setting up a database backup is a primary task for database administrators and we see perl and shell scripts wrapped around few of the backup-tools in practice.

FATAL: Cannot connect to MySQL server on 'localhost': Cacti Error - Solution to the issue while setting-up.

This post will answer how to extract database, tables etc from mysqldumpsplitter utility.

Explaining and providing solutions of MySQL error 1449: The user specified as a definer does not exist using SQL SECURITY INVOKER and DEFINER.

10+ useful code snippets of Linux shell scripts for how-to color, sendmail, log, change dir, parse parameters, loop, configuration file, switch..case and more.

In this post I will share a recovery scenario of a MySQL database restore from the binary logs.

The MySQL grant syntax allows you to specify dynamic database names using the wildcard characters.

A Percona Xtradb (Galera) Cluster node may fail to join it due to many possible mistakes causing SST to fail.

Restoring MariaDB (MySQL) slave using Xtrabackup & GTID.

Recently I happen to setup a new MySQL instance with my tools – a standard MySQL 5.1+, xtrabackup setup and last-hotbackup.tar.gz.

“Why Testing”, “Importance of Software testing”, “Scope of testing”, “How to become a tester”, “Training for software quality assurance / software testing” … Stop there… Above are the topics well… The post Why we need a tester / QA – Software testing first

innodb_flush_method variable specifies how InnoDB opens and flushes log and data files.

Everybody knows the criticality of backup.

This mysql stored function will return you all the dates between given dates having specified day.

Are you tired of manually generating test data for your MySQL tables?

“I just learned that Agent K has been assassinated by Boris from future, an alien criminal in 1969.

Ever come accoss a situation where you have to load a flat text file into MySQL with data provided in single column!

Schema alteration is a big headache especially when it has already reached to production and things get worse when the relations are involved.Below is a short example for altering tables… The post MySQL – Alter table-change datatype of column with foreign…

This article will describe you about QTP vs Selenium point by point in a easy to understand way.

MySQL Stored Routines (functions and procedures) are not only used for improving performance but also they’re handy when it comes to enhancing security and restricting user access.

Introducing JaxtrSMS, The world’s first free and open texting app is a revolutionary product from co-founders Sabeer Bhatia & Yogesh Patel.