Change Is Inevitable

MySQL Tools for Performance Tuning and Test Data Generation

Kedar — Mon, 06 Apr 2026 14:00:00 +0000

As a MySQL consultant, I keep running into the same two problems: reviewing MySQL configurations and generating realistic test data for validation. So I built two focused MySQL tools to…

The post MySQL Tools for Performance Tuning and Test Data Generation first appeared on Change Is Inevitable.

How to fix write latency in MySQL 8.4 Upgrade

Kedar — Sat, 04 Apr 2026 17:01:09 +0000

During any MySQL major version upgrade, especially when moving from 8.0 to 8.4, it’s not just about compatibility checks. Subtle default changes can directly impact MySQL performance tuning, and if…

The post How to fix write latency in MySQL 8.4 Upgrade first appeared on Change Is Inevitable.

MySQL 8.4 disables AHI – Why and What you need to know

Kedar — Mon, 19 Jan 2026 18:18:11 +0000

MySQL 8.4 changed the InnoDB adaptive hash index (innodb_adaptive_hash_index) default from ON to OFF, a major shift after years of it being enabled by default. Note that the MySQL adaptive hash index (AHI) feature remains fully available…

The post MySQL 8.4 disables AHI – Why and What you need to know first appeared on Change Is Inevitable.

How to checksum on AWS RDS for MySQL Replication 8.0 > 8.4

Kedar — Tue, 04 Nov 2025 11:45:00 +0000

During a MySQL upgrade process the RDS replication between MySQL 8.0 and 8.4 was configured. I wanted to ensure the data was consistent for any random reason. This post is…

The post How to checksum on AWS RDS for MySQL Replication 8.0 > 8.4 first appeared on Change Is Inevitable.

What MySQL configuration you hate the most?

Kedar — Tue, 23 Sep 2025 12:30:00 +0000

Ever spent your weekend debugging a MySQL production issue that could have been avoided with better configuration? I have, and it’s beyond frustrating. I have prepared my list of the…

The post What MySQL configuration you hate the most? first appeared on Change Is Inevitable.

MySQL Podcast: InnoDB Cluster Group Replication

Kedar — Mon, 15 Sep 2025 12:26:07 +0000

I’m working on sharing MySQL tips, tricks, and other related tech topics in my MySQL podcast. It’s a bit of a challenge to stay consistent, but I’m pushing through. Finally…

The post MySQL Podcast: InnoDB Cluster Group Replication first appeared on Change Is Inevitable.

How to use tmux, a cheat sheet

Kedar — Mon, 18 Aug 2025 06:38:03 +0000

I think we know that screen is officially old news and most modern Linux systems switched to tmux as the recommended multiplexer with RHEL 8. Recently I had a discussion…

The post How to use tmux, a cheat sheet first appeared on Change Is Inevitable.

How to migrate PMM (Grafana) users

Kedar — Mon, 04 Aug 2025 12:05:00 +0000

You’ve got a shiny new Percona Monitoring & Management instance standing by and want to move existing users over. This blog is a quick work around for migrating PMM users…

The post How to migrate PMM (Grafana) users first appeared on Change Is Inevitable.

A Unique Foreign Key issue in MySQL 8.4

Kedar — Thu, 24 Apr 2025 08:30:00 +0000

Recently, a friend reached out to me for help after encountering an error while restoring a MySQL dump during an upgrade from MySQL 8.0 to 8.4. The error read: At…

The post A Unique Foreign Key issue in MySQL 8.4 first appeared on Change Is Inevitable.

How to Resolve Disk Space Issues in PMM: Case Study

Kedar — Tue, 22 Apr 2025 12:46:31 +0000

Recently, I encountered a Percona Monitoring and Management (PMM) server that was rapidly approaching complete disk exhaustion. This post outlines the steps taken to identify the issue and reclaim disk…

The post How to Resolve Disk Space Issues in PMM: Case Study first appeared on Change Is Inevitable.

MySQL Data Archiving basics – considerations, mistakes, best practices

Kedar — Sun, 13 Apr 2025 10:35:33 +0000

This blog is dedicated to MySQL data archiving; we’ll break down from the basics of what data archival is, why it matters, best practices and scenarios. We will also see…

The post MySQL Data Archiving basics – considerations, mistakes, best practices first appeared on Change Is Inevitable.

Killer Blog for MySQL Administrators

Kedar — Mon, 09 Dec 2024 07:00:00 +0000

This is by far the most killer MySQL blog that I wanted to write for really long as a part of a Killer DBA series. Time is hard to find,…

The post Killer Blog for MySQL Administrators first appeared on Change Is Inevitable.

MySQL 8 utf8mb4_0900_ai_ci collation confusion

Kedar — Mon, 18 Nov 2024 07:45:08 +0000

Recently I was asked a question: Why am I getting utf8mb4_0900_ai_ci as the default collation in MySQL 8, despite setting the server to use utf8mb4_general_ci? With the upgrade to MySQL…

The post MySQL 8 utf8mb4_0900_ai_ci collation confusion first appeared on Change Is Inevitable.

AI tools – technology and kids

Kedar — Fri, 15 Nov 2024 09:56:01 +0000

AI tools like ChatGPT, GROK, Meta and Gemini are taking off, and as parents, it’s easy to feel the pressure to keep our kids up to speed. The message out…

The post AI tools – technology and kids first appeared on Change Is Inevitable.

Podcast: Duplicate Indexes in MySQL

Kedar — Thu, 14 Nov 2024 13:24:27 +0000

In this podcast, we’ll explore the issue of duplicate indexes in MySQL; including redundant index, foreign keys, left-prefixed secondary index /w primary key, and how to tackle the issue at…

The post Podcast: Duplicate Indexes in MySQL first appeared on Change Is Inevitable.

MySQL Podcast – Practical Learning & Training

Kedar — Wed, 06 Nov 2024 13:01:12 +0000

Hello, readers! I’m excited to announce the launch of my latest project: a dedicated MySQL Podcast! As a long-time MySQL enthusiast with extensive hands-on experience in database management, I understand…

The post MySQL Podcast – Practical Learning & Training first appeared on Change Is Inevitable.

MySQL Change Buffer – What When and FAQ

Kedar — Mon, 04 Nov 2024 17:08:30 +0000

In the world of database management, efficiency is key. MySQL’s change buffer is a powerful feature that helps optimize how secondary index changes are managed. The idea of introducing a…

The post MySQL Change Buffer – What When and FAQ first appeared on Change Is Inevitable.

Understanding Return Codes of pt-upgrade: A quick guide

Kedar — Mon, 14 Oct 2024 06:47:25 +0000

Interpreting the results and exit codes of your upgrade tests is essential for assessing the process’s outcome. In this blog, we’ll explore the significance of pt-upgrade return codes and how…

The post Understanding Return Codes of pt-upgrade: A quick guide first appeared on Change Is Inevitable.

Troubleshooting MySQL: Encryption can’t find Master Key

Kedar — Mon, 23 Sep 2024 11:30:27 +0000

If you’ve encountered the “Encryption can’t find master key” error while starting MySQL, you’re likely facing issues with the keyring plugin. I recently faced a similar issue on my server,…

The post Troubleshooting MySQL: Encryption can’t find Master Key first appeared on Change Is Inevitable.

MySQL 8 upgrade may fail using checkForServerUpgrade

Kedar — Thu, 07 Mar 2024 04:28:41 +0000

These days MySQL consultants around me are busy assisting with MySQL 8 upgrades for those who couldn’t board the train before EoL.I was recently involved in one of the MySQL…

The post MySQL 8 upgrade may fail using checkForServerUpgrade first appeared on Change Is Inevitable.

How to avoid data loss in MySQL Primary Key change

Kedar — Fri, 01 Mar 2024 12:17:14 +0000

Learn how to safely change primary keys in MySQL using pt-online-schema-change. This blog highlights tips to avoid data loss during online alter of primary key.

The post How to avoid data loss in MySQL Primary Key change first appeared on Change Is Inevitable.

MySQL Benchmarking and error in my_thread_global_end()

Kedar — Tue, 20 Feb 2024 08:12:20 +0000

I encountered this error, “Error in my_thread_global_end(): xx threads didn’t exit“, while working on MySQL benchmarking using sysbench. In this blog I’ll share my experience, reveal the fix, and help…

The post MySQL Benchmarking and error in my_thread_global_end() first appeared on Change Is Inevitable.

How to save money in AWS RDS – Upgrade to MySQL 8

Kedar — Thu, 08 Feb 2024 05:51:42 +0000

MySQL 8 is around us for 5 years now. I believe you’re surely considering an upgrade. But if you’re on AWS and still on an older version of MySQL, this…

The post How to save money in AWS RDS – Upgrade to MySQL 8 first appeared on Change Is Inevitable.

How MySQL Binary Log Gets Its Number

Kedar — Sun, 28 Jan 2024 11:37:36 +0000

In this blog I share how MySQL binary logs get their unique numbers after noting my observations with MySQL binary logs sequencing. Recently I noted an odd binary log sequencing…

The post How MySQL Binary Log Gets Its Number first appeared on Change Is Inevitable.

Node has dropped from cluster error in Galera Cluster

Kedar — Tue, 16 Jan 2024 14:01:39 +0000

Recently I noted a strange MySQL replication error in a Percona XtraDB Cluster (PXC) node replicating from a standard MySQL instance. “Node has dropped from cluster”. This is a quick blog…

The post Node has dropped from cluster error in Galera Cluster first appeared on Change Is Inevitable.

A year in MySQL Blogging – top blogs, summary and review

Kedar — Thu, 04 Jan 2024 11:38:34 +0000

The year 2023 surely was a successful year in MySQL blogging. I managed to publish 24 MySQL blogs in total both personal and Percona blog. This post is a reflection…

The post A year in MySQL Blogging – top blogs, summary and review first appeared on Change Is Inevitable.

How to filter MySQL slow queries using pt-query-digest

Kedar — Sat, 30 Dec 2023 07:03:33 +0000

The pt-query-digest is my go-to tool in order to perform slow query analysis, improve query performance and thus overall MySQL performance. In this blog post, I’m going to highlight the…

The post How to filter MySQL slow queries using pt-query-digest first appeared on Change Is Inevitable.

What do you need to debug MySQL issues – a checklist

Kedar — Mon, 11 Dec 2023 14:20:42 +0000

Welcome to the ultimate guide for MySQL issues debugging — your comprehensive MySQL checklist for tackling MySQL database environment challenges. This checklist for MySQL debugging is as useful to a…

The post What do you need to debug MySQL issues – a checklist first appeared on Change Is Inevitable.

How to get MySQL Primary Keys in one minute

Kedar — Thu, 30 Nov 2023 14:43:17 +0000

This blog post talks about one of the important MySQL configuration, sql_generate_invisible_primary_key, available in MySQL 8.0.30. This will save you from performance bottlenecks due to tables without Primary Key. If…

The post How to get MySQL Primary Keys in one minute first appeared on Change Is Inevitable.

Quick Look – MySQL Data Directory Files

Kedar — Mon, 25 Sep 2023 12:21:03 +0000

Do you know what lies inside your MySQL Data Directory? This article is a quick guide about the files stored inside MySQL data directory. Data managed by the MySQL server…

The post Quick Look – MySQL Data Directory Files first appeared on Change Is Inevitable.

How to fix Percona XtraDB Cluster 8.0 Upgrade issues

Kedar — Tue, 05 Sep 2023 10:08:34 +0000

Are you planning an upgrade for your Percona XtraDB Cluster (PXC)? Upgrading to PXC 8.0 can be a smooth process, but sometimes challenges arise that require careful troubleshooting. In this…

The post How to fix Percona XtraDB Cluster 8.0 Upgrade issues first appeared on Change Is Inevitable.

One MySQL blog a day challenge

Kedar — Mon, 31 Jul 2023 14:20:39 +0000

In this blog post, I want to share my experience and learning after challenging myself on my MySQL blog writing spree in recent past. I invite you to comment on…

The post One MySQL blog a day challenge first appeared on Change Is Inevitable.

How to fix MySQL federated table error

Kedar — Fri, 28 Jul 2023 18:24:31 +0000

This blog is about a very odd case of a Federated table error causing unable reach the remote MySQL server and causing to error. I’ll share the approach I tool…

The post How to fix MySQL federated table error first appeared on Change Is Inevitable.

How to replicate without binary logs in MySQL

Kedar — Thu, 27 Jul 2023 14:47:44 +0000

“How can we replicate without using binary logs” just a thought popped up in my brain during a casual discussion. This blog post is a brain dump of the possible…

The post How to replicate without binary logs in MySQL first appeared on Change Is Inevitable.

MySQL fragmentation and how to defragment

Kedar — Wed, 26 Jul 2023 15:31:57 +0000

In a MySQL database, fragmentation can occur over time as data is inserted, updated, and deleted. Fragmentation refers to the inefficient storage and organization of data within database objects, such…

The post MySQL fragmentation and how to defragment first appeared on Change Is Inevitable.

How to Fix Connection attributes of length xxx were truncated

Kedar — Tue, 25 Jul 2023 07:40:53 +0000

MySQL, a widely-used database management system, may show the warning “[Warning] Connection attributes of length 571 were truncated” in its error log. In this blog, we will explore the reasons…

The post How to Fix Connection attributes of length xxx were truncated first appeared on Change Is Inevitable.

How to overcome Throttling and Rate Exceeded Errors in DownloadDBLogFilePortion

Kedar — Mon, 24 Jul 2023 06:28:07 +0000

I was attempting to download the MySQL slow query logs to perform a slow query review. In this blog we will explore the issue I faced while downloading the slow…

The post How to overcome Throttling and Rate Exceeded Errors in DownloadDBLogFilePortion first appeared on Change Is Inevitable.

How to meet Signal 11 bug in MariaDB

Kedar — Sun, 25 Jun 2023 12:36:39 +0000

Bugs in database management systems can be a nightmare for administrators and developers. In my recent experiments, I discovered a Signal 11 bug in multiple versions of MariaDB, resulting in…

The post How to meet Signal 11 bug in MariaDB first appeared on Change Is Inevitable.

How To Install specific version of MySQL 8 on Ubuntu

Kedar — Thu, 08 Jun 2023 04:38:25 +0000

This blog post serves as a work-log detailing the process of uninstalling and installing a specific version of Percona MySQL Server on Ubuntu. The post includes instructions for installation using…

The post How To Install specific version of MySQL 8 on Ubuntu first appeared on Change Is Inevitable.

How to MySQL Replication setup, Master GTID & SSL Encryption

Kedar — Sun, 04 Jun 2023 12:01:57 +0000

Setting up replication in MySQL is a common DBA task. The replication could be traditional binary log replication or based on GTID replication. This blog is a work log and…

The post How to MySQL Replication setup, Master GTID & SSL Encryption first appeared on Change Is Inevitable.

Install exact version of Percona Server for MySQL on CentOS

Kedar — Tue, 30 May 2023 11:01:13 +0000

This blog post serves as a work-log detailing the process of uninstalling and installing a specific version of Percona MySQL Server on CentOS. The post includes instructions for installation using…

The post Install exact version of Percona Server for MySQL on CentOS first appeared on Change Is Inevitable.

MySQL Slow query log export and download in RDS

Kedar — Tue, 30 May 2023 09:05:57 +0000

A friend needed to analyze slow queries and for that he decides to use pt-query-digest tool. Though he got stuck at exporting slow queries from slow logs in RDS for…

The post MySQL Slow query log export and download in RDS first appeared on Change Is Inevitable.

How to fix 1030 Unknown generic error from engine in MySQL

Kedar — Mon, 10 Apr 2023 04:39:36 +0000

In this blog, I will share the steps I took to debug an error ‘ERROR 1030 (HY000): Got error 168 – ‘Unknown (generic) error from engine’ from storage engine’ while…

The post How to fix 1030 Unknown generic error from engine in MySQL first appeared on Change Is Inevitable.

MySQL 8 – timestamp cannot be null and explicit_defaults_for_timestamp

Kedar — Mon, 20 Mar 2023 14:54:44 +0000

A friend’s application started failing with MySQL causing error about timestamp columns and it needs urgent fixing from the database side. A timestamp column was not accepting the null values…

The post MySQL 8 – timestamp cannot be null and explicit_defaults_for_timestamp first appeared on Change Is Inevitable.

Restore single MySQL table (ibd) from Xtrabackup (video demo)

Kedar — Wed, 14 Dec 2022 17:39:51 +0000

In this blog we will create MySQL backup and then restore single table from Percona Xtrabackup without doing full restore. This post is basically a work-log in response to a…

The post Restore single MySQL table (ibd) from Xtrabackup (video demo) first appeared on Change Is Inevitable.

MySQL Interview – ChatGPT is not your DBA

Kedar — Wed, 14 Dec 2022 13:51:58 +0000

Given the recent surge of interest in ChatGPT and the AI capabilities it offers, I decided to conduct an interview with it to assess its suitability for a MySQL Consultant…

The post MySQL Interview – ChatGPT is not your DBA first appeared on Change Is Inevitable.

Securing MySQL: Data Encryption with Percona Server and Vault

Kedar — Sat, 10 Dec 2022 00:00:25 +0000

Percona Tech Days are free, half-day events dedicated to the most popular open source database technologies: PostgreSQL, MongoDB and MySQL. This talk for MySQL was related to MySQL Encryption with…

The post Securing MySQL: Data Encryption with Percona Server and Vault first appeared on Change Is Inevitable.

Can not connect to ProxySQL: reasons and fixtures

Kedar — Tue, 11 Oct 2022 10:53:12 +0000

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. This post is tipping you…

The post Can not connect to ProxySQL: reasons and fixtures first appeared on Change Is Inevitable.

Providing Friday Proofs to MySQL Consultants | Scripts Functions Routines

Kedar — Sat, 24 Sep 2022 11:50:04 +0000

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 appeared on Change Is Inevitable.

The Low Hanging Fruits of MySQL – Percona Live Community 2022

Kedar — Wed, 13 Jul 2022 09:43:51 +0000

MySQL is one of the top used database system and with highly active community. Though without proper configuration you may not squeeze the most out of it.This will be a…

The post The Low Hanging Fruits of MySQL – Percona Live Community 2022 first appeared on Change Is Inevitable.

Relay log read failure | 2 many dots can break your replication only once

Kedar — Thu, 19 Aug 2021 13:12:49 +0000

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,…

The post Relay log read failure | 2 many dots can break your replication only once first appeared on Change Is Inevitable.

MySQL Backup setup, automation using Holland, mysqldump on Ubuntu

Kedar — Tue, 23 Mar 2021 05:27:16 +0000

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…

The post MySQL Backup setup, automation using Holland, mysqldump on Ubuntu first appeared on Change Is Inevitable.

Still have MySQL 5.6 variable binlog_error_action as IGNORE_ERROR?

Kedar — Fri, 10 Apr 2020 15:49:13 +0000

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…

The post Still have MySQL 5.6 variable binlog_error_action as IGNORE_ERROR? first appeared on Change Is Inevitable.

ProxySQL Configuration & Startup Process explained

Kedar — Tue, 08 Oct 2019 17:55:35 +0000

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

The post ProxySQL Configuration & Startup Process explained first appeared on Change Is Inevitable.

MySQL backup shell script with status email

Kedar — Tue, 09 Apr 2019 06:11:17 +0000

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…

The post MySQL backup shell script with status email first appeared on Change Is Inevitable.

दुर्गे दुर्घट भारी – श्री देवीची आरती | Aarti Durge Durghat Bhari | Marathi

Kedar — Mon, 01 Oct 2018 05:00:00 +0000

दुर्गे दुर्घट भारी – श्री देवीची आरती Durge Durghat Bhari दुर्गे दुर्घट भारी तुजविण संसारी ।अनाथनाथे अंबे करुणा विस्तारी ॥वारी वारीं जन्ममरणाते वारी ।हारी पडलो आता संकट नीवारी ॥ १…

The post दुर्गे दुर्घट भारी – श्री देवीची आरती | Aarti Durge Durghat Bhari | Marathi first appeared on Change Is Inevitable.

MySQL 8 Resource Group – introduction and dynamic allocation

Kedar — Fri, 07 Sep 2018 12:03:57 +0000

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.

Galera cluster to AWS Aurora migration & HA_ERR_FOUND_DUPP_KEY

Kedar — Mon, 13 Aug 2018 06:15:05 +0000

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…

The post Galera cluster to AWS Aurora migration & HA_ERR_FOUND_DUPP_KEY first appeared on Change Is Inevitable.

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

Kedar — Fri, 29 Jun 2018 15:43:55 +0000

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

The post Restore A Table / Database From Full Backup – Yet Another Way first appeared on Change Is Inevitable.

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

Kedar — Mon, 29 Jan 2018 18:18:27 +0000

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…

The post Export MySQL database table to CSV (delimited / Excel) file first appeared on Change Is Inevitable.

A tale of Corrupt InnoDB table, MySQL crash & recovery

Kedar — Thu, 18 Jan 2018 14:54:29 +0000

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…

The post A tale of Corrupt InnoDB table, MySQL crash & recovery first appeared on Change Is Inevitable.

How to Pause (Suspend) a process in Linux with kill signals

Kedar — Tue, 09 Jan 2018 13:12:17 +0000

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

The post How to Pause (Suspend) a process in Linux with kill signals first appeared on Change Is Inevitable.

Decoding Siebel Audit Trail with PLSQL

Kaushik Vaijanapurkar — Thu, 14 Dec 2017 10:30:57 +0000

In this post we will understand how to decode Seibel Audit Trail using PLSQL. Siebel Audit Trail is feature in Siebel CRM which allows customer to track changes to important…

The post Decoding Siebel Audit Trail with PLSQL first appeared on Change Is Inevitable.

Reset root password on Galera Cluster (Percona or MariaDB)

Kedar — Tue, 11 Apr 2017 07:41:53 +0000

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.

MySQL to Galera Cluster Migration, Deadlock, Back to basics

Kedar — Thu, 02 Mar 2017 12:34:30 +0000

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…

The post MySQL to Galera Cluster Migration, Deadlock, Back to basics first appeared on Change Is Inevitable.

MySQL database restore issues using xtrabackup – facepalm moments

Kedar — Mon, 13 Jun 2016 13:53:18 +0000

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

The post MySQL database restore issues using xtrabackup – facepalm moments first appeared on Change Is Inevitable.

corrupted / crashed MyISAM + mysql_repair_threads = stuck “Repair with N threads”

Kedar — Mon, 07 Dec 2015 11:25:49 +0000

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 Inevitable.

Fixing inconsistency on MySQL Slave of Galera Cluster

Kedar — Fri, 04 Dec 2015 07:40:19 +0000

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.

Setting-up second MySQL instance & replication on Linux in 10 steps

Kedar — Wed, 04 Nov 2015 11:59:09 +0000

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.

The post Setting-up second MySQL instance & replication on Linux in 10 steps first appeared on Change Is Inevitable.

pt-table-checksum & Waiting to check replicas for differences: 0% 00:00 remain

Kedar — Mon, 19 Oct 2015 19:51:17 +0000

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

The post pt-table-checksum & Waiting to check replicas for differences: 0% 00:00 remain first appeared on Change Is Inevitable.

How to Add Remote MySQL Server to Nagios Monitoring

Kedar — Mon, 17 Aug 2015 11:47:46 +0000

We already have seen two articles for setting up MySQL Monitoring with Nagios and Percona Monitoring Tools for Nagios. Those posts covers configuration of nagios on single instance. Though following…

The post How to Add Remote MySQL Server to Nagios Monitoring first appeared on Change Is Inevitable.

MySQL Permission denied error 13 and solution

Kedar — Mon, 20 Jul 2015 14:57:29 +0000

MySQL ERROR 1018 (HY000): Can't read dir of './sakila/' (errno: 13 - Permission denied) caused due to moving database to a different partition and using softlink on CentOS and it's fix for SELinux.

The post MySQL Permission denied error 13 and solution first appeared on Change Is Inevitable.

How to monitor MySQL backups

Kedar — Wed, 01 Jul 2015 06:45:20 +0000

It’s important to monitor the (database) backups after you set-it-up. In this post we will answer a few how to monitor MySQL Database backups solutions – monitoring methods. We should…

The post How to monitor MySQL backups first appeared on Change Is Inevitable.

Install Percona Monitoring Tools for Nagios – MySQL Plugins

Kedar — Tue, 30 Jun 2015 12:47:16 +0000

Recently a friend asked about Installing Percona Monitoring Tools for Nagios as he was facing a few issues. I managed to set-it-up on my ubuntu VM. Sharing the the work-log…

The post Install Percona Monitoring Tools for Nagios – MySQL Plugins first appeared on Change Is Inevitable.

UMASK & UMASK_DIR – changing default MySQL file dir permissions

Kedar — Wed, 24 Jun 2015 07:06:06 +0000

UMASK and UMASK_DIR are amongst few MySQL Environment variables which defines directory and file creation modes (file permissions). In this post we will understand using UMASK & UMASK_DIR for changing the database directory and file permissions from it's default to what we need.

The post UMASK & UMASK_DIR – changing default MySQL file dir permissions first appeared on Change Is Inevitable.

XML to JSON converter in Siebel

Kaushik Vaijanapurkar — Sun, 07 Jun 2015 09:42:49 +0000

Often we come across requirement for Siebel to integrate with external applications. Siebel provides various ways to integrate through EAI (Enterprise Application Integration) like EIM, Prebuilt connectors, various queues like…

The post XML to JSON converter in Siebel first appeared on Change Is Inevitable.

Setup and configure MySQL backup using Holland and Xtrabackup

Kedar — Tue, 02 Jun 2015 07:10:54 +0000

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. With right tools…

The post Setup and configure MySQL backup using Holland and Xtrabackup first appeared on Change Is Inevitable.

Cannot connect to MySQL server on ‘localhost’: Cacti Error

Kedar — Wed, 20 May 2015 10:32:15 +0000

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

The post Cannot connect to MySQL server on ‘localhost’: Cacti Error first appeared on Change Is Inevitable.

How-to extract from mysqldump | mysql-dump-splitter recipes

Kedar — Tue, 28 Apr 2015 10:28:58 +0000

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

The post How-to extract from mysqldump | mysql-dump-splitter recipes first appeared on Change Is Inevitable.

How to fix definer does not exist error 1449 MySQL

Kedar — Mon, 23 Mar 2015 06:27:41 +0000

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

The post How to fix definer does not exist error 1449 MySQL first appeared on Change Is Inevitable.

10 useful shell script code snippets | Linux

Kedar — Tue, 10 Mar 2015 08:38:37 +0000

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.

The post 10 useful shell script code snippets | Linux first appeared on Change Is Inevitable.

How to Restore / point in time recovery using binary logs MySQL

Kedar — Mon, 23 Feb 2015 12:42:12 +0000

In this post I will share a recovery scenario of a MySQL database restore from the binary logs. This post is also a good example of how we can achieve…

The post How to Restore / point in time recovery using binary logs MySQL first appeared on Change Is Inevitable.

MySQL grant syntax & dynamic database using wildcards

Kedar — Tue, 03 Feb 2015 10:03:23 +0000

The MySQL grant syntax allows you to specify dynamic database names using the wildcard characters. This article explains the usecase of dynamic section of mysql grants.

The post MySQL grant syntax & dynamic database using wildcards first appeared on Change Is Inevitable.

Debugging Percona Xtradb (Galera) Cluster node startup / SST errors

Kedar — Wed, 21 Jan 2015 06:49:24 +0000

A Percona Xtradb (Galera) Cluster node may fail to join it due to many possible mistakes causing SST to fail. It could be a configuration item or purely setup requirement. In this article we will be troubleshooting step by step the SST issues faced.

The post Debugging Percona Xtradb (Galera) Cluster node startup / SST errors first appeared on Change Is Inevitable.

MariaDB slave restore using GTID & xtrabackup bug

Kedar — Wed, 31 Dec 2014 12:06:09 +0000

Restoring MariaDB (MySQL) slave using Xtrabackup & GTID.

The post MariaDB slave restore using GTID & xtrabackup bug first appeared on Change Is Inevitable.

xtrabackup_51: not found & no ‘mysqld’ group in MySQL options

Kedar — Mon, 27 May 2013 05:46:14 +0000

Recently I happen to setup a new MySQL instance with my tools – a standard MySQL 5.1+, xtrabackup setup and last-hotbackup.tar.gz. To restore from the backup we used xtrabackup binaries…

The post xtrabackup_51: not found & no ‘mysqld’ group in MySQL options first appeared on Change Is Inevitable.

Why we need a tester / QA – Software testing

Madhumita — Mon, 04 Mar 2013 07:40:56 +0000

“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 appeared on Change Is Inevitable.

MySQL variable innodb_flush_method – summarized

Kedar — Thu, 10 Jan 2013 11:21:21 +0000

innodb_flush_method variable specifies how InnoDB opens and flushes log and data files. In Innodb optimization, setting the variable innodb_flush_method tweaks the performance most of the times but there are cases…

The post MySQL variable innodb_flush_method – summarized first appeared on Change Is Inevitable.

Is your backup complete? – backup MySQL users privileges / grants – pt-show-grants

Kedar — Mon, 17 Dec 2012 12:48:10 +0000

Everybody knows the criticality of backup. You might have had your database dumped, data directory copied, flat files exported and even config and binary log files backed-up. But did you…

The post Is your backup complete? – backup MySQL users privileges / grants – pt-show-grants first appeared on Change Is Inevitable.

MySQL function returns dates of specified day & between date range

Kedar — Thu, 13 Sep 2012 07:49:24 +0000

This mysql stored function will return you all the dates between given dates having specified day. In short if you say: give me all Sundays in this month. I have…

The post MySQL function returns dates of specified day & between date range first appeared on Change Is Inevitable.

How To Generate Random test Data In MySQL

Kedar — Thu, 05 Jul 2012 07:51:20 +0000

Are you tired of manually generating test data for your MySQL tables? If you’re looking for random data generator, look no further! Introducing the MySQL Random Data Generator, a powerful…

The post How To Generate Random test Data In MySQL first appeared on Change Is Inevitable.

Men in Black-3 (MiB-3) – Xtreme Movie Review

Kedar — Sat, 26 May 2012 06:51:35 +0000

“I just learned that Agent K has been assassinated by Boris from future, an alien criminal in 1969. I must travel through a time and stop him and save young…

The post Men in Black-3 (MiB-3) – Xtreme Movie Review first appeared on Change Is Inevitable.

Load columnar text file into MySQL table

Kedar — Thu, 03 May 2012 16:21:08 +0000

Ever come accoss a situation where you have to load a flat text file into MySQL with data provided in single column! Say, your data to be loaded in table…

The post Load columnar text file into MySQL table first appeared on Change Is Inevitable.

MySQL – Alter table-change datatype of column with foreign key

Kedar — Mon, 23 Apr 2012 12:08:30 +0000

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 key first appeared on Change Is Inevitable.

Selenium vs QTP differences and usage-quick reference

Madhumita — Sat, 17 Mar 2012 16:20:22 +0000

This article will describe you about QTP vs Selenium point by point in a easy to understand way. In the field of Software Quality Assurance (QA) automation tools, Selenium and…

The post Selenium vs QTP differences and usage-quick reference first appeared on Change Is Inevitable.

Access Control in MySQL Stored Routines: DEFINER, INVOKER & SQL SECURITY

Kedar — Mon, 30 Jan 2012 16:29:03 +0000

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. This post briefs…

The post Access Control in MySQL Stored Routines: DEFINER, INVOKER & SQL SECURITY first appeared on Change Is Inevitable.

JaxtrSMS-Send Free SMS Worldwide | Download for iPhone, Android, BlackBerry, Java

Kedar — Fri, 18 Nov 2011 03:06:04 +0000

Introducing JaxtrSMS, The world’s first free and open texting app is a revolutionary product from co-founders Sabeer Bhatia & Yogesh Patel. Sending free text messages or free SMS is now…

The post JaxtrSMS-Send Free SMS Worldwide | Download for iPhone, Android, BlackBerry, Java first appeared on Change Is Inevitable.

Software Quality Attributes-Parameters Explained

Madhumita — Fri, 04 Nov 2011 08:10:07 +0000

What is a software quality and what attributes are used to measure it? A very common question you might have faced during Testing or QA Interviews. Many of the Software…

The post Software Quality Attributes-Parameters Explained first appeared on Change Is Inevitable.

Bug / Defect Priority vs Severity Matrix

Madhumita — Sun, 09 Oct 2011 18:41:41 +0000

In Software Testing, deciding how important the defect is and how soon the defect should be fixed is as important as finding a defect! This depends on how you actually…

The post Bug / Defect Priority vs Severity Matrix first appeared on Change Is Inevitable.

What Music mean to you?

Kedar — Sun, 11 Sep 2011 15:47:05 +0000

What music mean to you? Well, surealy this is one of those questions for which you know the answer but you just can’t describe satisfactorily. So, here is my try.…

The post What Music mean to you? first appeared on Change Is Inevitable.

MySQL Binary logs Generated Per Hour | Growth Estimate

Kedar — Fri, 29 Jul 2011 04:33:00 +0000

The MySQL binary log is a set of log files that contain information about data modifications made to a MySQL server instance. At times we need to understand the disk…

The post MySQL Binary logs Generated Per Hour | Growth Estimate first appeared on Change Is Inevitable.

Extreme Movie Review: Singham (2011) Ajay Devgn

Kedar — Tue, 26 Jul 2011 19:41:28 +0000

Dhing chika, Dhing chika, Dhing chika… This is what I got from singham, a ringtone… I hated Dabangg even more when it got National Award! Don’t want to continue it…

The post Extreme Movie Review: Singham (2011) Ajay Devgn first appeared on Change Is Inevitable.

Light Writing or Painting Photography with Sony DSC HX1

Kedar — Thu, 21 Jul 2011 14:41:01 +0000

It always feels good to have a capable camera and it feels even better to explore new capacities of my Sony DSC-HX1 🙂 After entering into manual mode and understanding…

The post Light Writing or Painting Photography with Sony DSC HX1 first appeared on Change Is Inevitable.

Capturing with Manual Mode – Sony DSC HX1 Photography

Kedar — Sun, 01 May 2011 13:42:56 +0000

“Auto mode is for kids and manual is for photographers” Well, One must take out time to learn & for those owning camera, this is definitly a must do thing.…

The post Capturing with Manual Mode – Sony DSC HX1 Photography first appeared on Change Is Inevitable.

Extreme Movie Review – Dum Maro Dum (2011)

Kedar — Tue, 26 Apr 2011 15:43:30 +0000

And finally, Rohan Sippy’s “Dum Maaro Dum” ended the series of poor movies in 2011. The best parts of the movie are Direction & Music, alongwith the good mixture of…

The post Extreme Movie Review – Dum Maro Dum (2011) first appeared on Change Is Inevitable.

Place to visit | Nature Discovery Centre, Sundarvan, Ahmedabad

Kedar — Mon, 11 Apr 2011 08:50:07 +0000

Are you in Ahmedabad, looking for a short visit to a natural place? Sundarvan can surely surprise you. A Nature Discovery Centre is like a small zoo located in the…

The post Place to visit | Nature Discovery Centre, Sundarvan, Ahmedabad first appeared on Change Is Inevitable.

Extreme Movie Review-Yeh Saali Zindagi (2011)

Kedar — Fri, 18 Feb 2011 16:58:17 +0000

Yeh Saali Zindagi… Hmm… So how do you feel if I start my review from the time when the director decided to make ‘Yeh Saali Zindagi’!! That’s what happened with…

The post Extreme Movie Review-Yeh Saali Zindagi (2011) first appeared on Change Is Inevitable.

Mad WWE Fan Destroying Kid With Chokeslam | Don’t try this

Kedar — Tue, 01 Feb 2011 18:46:08 +0000

There are a lot of speculations around WWE and its effect on kids. I personally love watching the Stars and their action and dedication towards the World Wrestling Entertainment! Though…

The post Mad WWE Fan Destroying Kid With Chokeslam | Don’t try this first appeared on Change Is Inevitable.

Kedar’s Blog Performance Statistics-Year 2010

Kedar — Fri, 21 Jan 2011 12:18:49 +0000

This post is dedicated to blog performance and statistics by analytical numbers. So, how did the blog perform in 2010? Below is the simple statistics to explain the blog performance…

The post Kedar’s Blog Performance Statistics-Year 2010 first appeared on Change Is Inevitable.

Escaping “Lesson Learned” dealing with MySQL Databases & Case Sensitivity

Kedar — Mon, 06 Dec 2010 09:16:54 +0000

Do you ever need to transfer databases between servers? Different OSes? Two common ways of data migration:1. Create mysqldump and load it.2. File transfer using SCP. MySQL Case Sensitivity and…

The post Escaping “Lesson Learned” dealing with MySQL Databases & Case Sensitivity first appeared on Change Is Inevitable.

Life At Rest – A few lines for her

Kedar — Mon, 06 Dec 2010 08:10:55 +0000

:Life at rest: Oh my Dear, insomniac for ur sleep, u’r awesome when its deep, pale skin, nighty hair, mighty life and u’r so near… warm breath, and ur charm,…

The post Life At Rest – A few lines for her first appeared on Change Is Inevitable.

Kedar and Madhumita Wedding Invitation 25 Dec 2010

Kedar — Sun, 05 Dec 2010 10:51:55 +0000

Dear God, You’re almighty and kind. You know everything about me and us. Still I’m writing this formally to you. With blessings of our parents we’ve decided to “join” each…

The post Kedar and Madhumita Wedding Invitation 25 Dec 2010 first appeared on Change Is Inevitable.

MySQL Load Data Infile with Stored Procedure

Kedar — Tue, 30 Nov 2010 06:58:36 +0000

Did you ever need to run LOAD DATA INFILE in a procedure? May be to automate or dynamically perform the large data file load to the MySQL database. In this…

The post MySQL Load Data Infile with Stored Procedure first appeared on Change Is Inevitable.

10 Steps: MySQL Monitoring through Nagios: Install & Configure

Kedar — Thu, 18 Nov 2010 10:42:52 +0000

Nagios is a powerful monitoring system and here we will learn how to monitor MySQL through Nagios. We will be installing Nagios, required plugins and configuring it to monitor MySQL…

The post 10 Steps: MySQL Monitoring through Nagios: Install & Configure first appeared on Change Is Inevitable.

How to Get Stock Quote on Linux using Google ,Curl, Grep, Awk

Kedar — Fri, 12 Nov 2010 11:58:56 +0000

If you are a Stock Market Addict and a Techie; normally working on Linux(es); this post will interest you as you still can get quote of your stock on your…

The post How to Get Stock Quote on Linux using Google ,Curl, Grep, Awk first appeared on Change Is Inevitable.

Installing MySQL On Mac OS X (Darwin Kernel)

Kedar — Thu, 28 Oct 2010 14:43:16 +0000

Recently I happen to install MySQL on Mac OS X (Darvin Kernel). Below are the quick 5 steps to accomplish the task. Step 1: Check Mac Version Very first step…

The post Installing MySQL On Mac OS X (Darwin Kernel) first appeared on Change Is Inevitable.

Top 10 Suresh Kalmadi-CWG Jokes-Delhi 2010

Kedar — Wed, 29 Sep 2010 05:40:19 +0000

A lot of SMSes and Jokes I’ve received and read online about Mr. Suresh Kalmadi and CWG. Well, it’s quite a bit serious matter but such a huge mess gave…

The post Top 10 Suresh Kalmadi-CWG Jokes-Delhi 2010 first appeared on Change Is Inevitable.

Extreme Movie Review n Poll – Salman's Dabangg 2010

Kedar — Wed, 22 Sep 2010 07:45:42 +0000

Friends, I saw movie dabangg and this is what I think about it. Dabangg…It’s a bad movie… I don’t understand how come it became so “popular”…It’s typical South Indian styled…

The post Extreme Movie Review n Poll – Salman's Dabangg 2010 first appeared on Change Is Inevitable.

MySQL Function to Convert Date To Words

Kedar — Thu, 16 Sep 2010 13:08:24 +0000

Recently I saw a MySQL Stored Function requirement on Experts-Exchange for converting date into some specific words format. You may find MySQL function for date to words conversion online; even…

The post MySQL Function to Convert Date To Words first appeared on Change Is Inevitable.

Computer usage and maintenance-my 10 practices

Kedar — Fri, 27 Aug 2010 12:54:42 +0000

I have already written a post for my list of must have softwares. I’ve now decided to share how I use my machine. In this post I will post my…

The post Computer usage and maintenance-my 10 practices first appeared on Change Is Inevitable.

Shutter Speed & F-stop: Sony DSC HX1 Photography

Kedar — Wed, 25 Aug 2010 13:16:25 +0000

Yesterday I was traveling from Ahmedabad to Vadodara and luckily I carried my DSC HX1 with me. I was even lucky that I was incapable of driving and was on…

The post Shutter Speed & F-stop: Sony DSC HX1 Photography first appeared on Change Is Inevitable.

My list of must have free softwares-2010

Kedar — Sat, 07 Aug 2010 15:48:34 +0000

As soon as I got a pc I start looking at Configuration, Connectivity [;)] and Installations. As for humans Food, Air, Water are basic necessities; for my computer I always…

The post My list of must have free softwares-2010 first appeared on Change Is Inevitable.

My worst mathematical program in perl

Kedar — Wed, 04 Aug 2010 18:02:23 +0000

I have a Mathe-crap-matical friend. Who keeps digging into graves of dead formulas and equations and all possible Math related stuffs. Since I started understanding Mathematics (that it’s not my…

The post My worst mathematical program in perl first appeared on Change Is Inevitable.

EPIC-First Indian Web browser-Free with Antivirus

Kedar — Fri, 16 Jul 2010 19:28:41 +0000

Recently India got it’s own Currency Symbol for Indian Rupee! But do we know, we also got our own “Made in India” browser on 15th July 2010?!! EPIC – Yes…

The post EPIC-First Indian Web browser-Free with Antivirus first appeared on Change Is Inevitable.

Extreme Movie Review: I hate Luv Stories-2010

Kedar — Tue, 13 Jul 2010 14:17:51 +0000

I hate Luv Stories. No! it’s not a spell mistake, they have intentionally made it “LUV” as they love LOVE stories.Since I heard the name, I started hating the movie…

The post Extreme Movie Review: I hate Luv Stories-2010 first appeared on Change Is Inevitable.

A User review-Apple IPhone-4: I

Kedar — Mon, 05 Jul 2010 10:02:21 +0000

Techie nerds, geeks or even company reviews are quite interesting and have their importance but a “User Review” is something which you won’t like to ignore; you should not. IPhone-4…

The post A User review-Apple IPhone-4: I first appeared on Change Is Inevitable.

Extreme Movie Review-Raavan 2010-Bonus Poster

Kedar — Sat, 26 Jun 2010 11:24:11 +0000

I always admire Maniratnam … Never doubt his movies… A R Raheman is a Gem – whole world admits… I simply love his music. No one can doubt Gulzar’s capabilities…

The post Extreme Movie Review-Raavan 2010-Bonus Poster first appeared on Change Is Inevitable.

Extreme Movie Review – Prince of Persia (2010)

Kedar — Sun, 06 Jun 2010 10:34:43 +0000

As soon as Prince of Persia name appears I recall my colleage days of P.O.P. 3D the game of Late 2000 Era. I used to play em’ a lot. Later…

The post Extreme Movie Review – Prince of Persia (2010) first appeared on Change Is Inevitable.

My Sony DSC HX1 Performance, Learning and Photos – I

Kedar — Thu, 27 May 2010 06:28:12 +0000

After a lot of ifs, buts, confusions and questions I’ve bought Sony’s DSC HX1 . Well I’m not that good at photography but yes I like that. Here I will post…

The post My Sony DSC HX1 Performance, Learning and Photos – I first appeared on Change Is Inevitable.

Java termwork connect Access Database and operations

Kedar — Mon, 24 May 2010 15:40:37 +0000

Prologue: Long back there were golden days of post graduation in the “great” DDIT (Now Dharamsinh Desai University), Nadiad. Assignments, termwork and journals or everything similar was in demand –…

The post Java termwork connect Access Database and operations first appeared on Change Is Inevitable.

Extreme Movie Review: Housefull 2010

Kedar — Mon, 10 May 2010 11:44:40 +0000

Housefull!! The best movie, the best comedy, the best dialogues, the best jokes… So in this first line of Housefull review “I’m a joking” Actually it’s totally reverse. If you’ve…

The post Extreme Movie Review: Housefull 2010 first appeared on Change Is Inevitable.

How to generate Insert Statement in MySQL

Kedar — Wed, 05 May 2010 11:14:28 +0000

A lot of places I saw people asking for ways to generate Insert statements. We do have GUI Tool which can extract insert statements for us readily. Some of the…

The post How to generate Insert Statement in MySQL first appeared on Change Is Inevitable.

My Digital confusion for Camera

Kedar — Tue, 04 May 2010 20:55:21 +0000

In the huge task of selecting a digital camera, one more day has passed. I’m still not decided. Yes, I have now felt an extreme need of purchasing a digital…

The post My Digital confusion for Camera first appeared on Change Is Inevitable.

Steps to Move Copy Rename MySQL Database

Kedar — Tue, 04 May 2010 16:54:19 +0000

Moving, copying or renaming database is a very basic activity. I have just noted a few commands for reference to quickly follow the required operation. 1. Rename database on Linux…

The post Steps to Move Copy Rename MySQL Database first appeared on Change Is Inevitable.

Google:Earth View on Google maps

Kedar — Tue, 27 Apr 2010 09:30:49 +0000

When have you lastly visited Google Maps? Google have now Introduced Google Earth on Google Maps. Now using Browser you can see 3D maps online; they named it “Earth View”.…

The post Google:Earth View on Google maps first appeared on Change Is Inevitable.

MySQL Load Data Infile Syntax Generator Tool Download

Kedar — Thu, 08 Apr 2010 13:00:28 +0000

MySQL LOAD DATA INFILE is a common command used to load delimited data to MySQL database. Here’s a tool to generate the Syntax for MySQL’s LOAD DATA INFILE command. I…

The post MySQL Load Data Infile Syntax Generator Tool Download first appeared on Change Is Inevitable.

In the world of NoSQL-Hands on Mongodb-1

Kedar — Mon, 05 Apr 2010 05:44:00 +0000

I’m hearing a lot of “NoSQL” these days. To really understand how (and) does it works, I decided to give a try on MongoDB. MongoDB (hu*mongo*us) is an open source,…

The post In the world of NoSQL-Hands on Mongodb-1 first appeared on Change Is Inevitable.

Place to visit Mumbai: Alibaug day tour weekend picnic

Kedar — Sat, 03 Apr 2010 11:10:35 +0000

Think about one day tour and a lot of fun in Mumbai? A place to visit in Mumbai in short trip? Alibaug is a good choice. One Day Tour in Mumbai |…

The post Place to visit Mumbai: Alibaug day tour weekend picnic first appeared on Change Is Inevitable.

MySQL related file types and basic information

Kedar — Mon, 29 Mar 2010 18:13:14 +0000

This post covers the basic information of files that MySQL Server uses / creates for various tasks. Update: Various files in MySQL 8.0 Refer following updated article for latest information…

The post MySQL related file types and basic information first appeared on Change Is Inevitable.

Earth Hour March 27 2010-India-Switch off lights for future

Kedar — Sat, 27 Mar 2010 08:34:20 +0000

Earth Hour is a global event organized by WWF (World Wide Fund for Nature). Earth Hour held on the last Saturday of March annually, asking households and businesses to turn…

The post Earth Hour March 27 2010-India-Switch off lights for future first appeared on Change Is Inevitable.

Working with EditPlus Text Editor-Regular Expression How To

Kedar — Sat, 20 Mar 2010 09:41:06 +0000

Editplus is a lot better than the regular text editor, Notepad. From all it’s features I like RegExp Support the most, and than comes the block select feature. Here are…

The post Working with EditPlus Text Editor-Regular Expression How To first appeared on Change Is Inevitable.

batch script to add remove prefix zero pad bulk file rename

Kedar — Thu, 18 Mar 2010 07:52:47 +0000

This post has two batch scripts: 1. Batch script to rename files with zero padded number series-prefix 2. Batch script to remove prefix of perticular length 1. Batch script to…

The post batch script to add remove prefix zero pad bulk file rename first appeared on Change Is Inevitable.

SQL syntax with /*! c-style comments in MySQLdump

Kedar — Thu, 11 Mar 2010 12:57:24 +0000

In mysql we have — , /* and /*! comments. This post is mainly about very basic c-style comments. /*! : C-Style comments in MySQL We normally see comments in…

The post SQL syntax with /*! c-style comments in MySQLdump first appeared on Change Is Inevitable.

Ideas for select all columns but one mysql stored procedure

Kedar — Fri, 05 Mar 2010 13:35:40 +0000

Assume we’ve a table with 100 rows and we need to select all columns but one.The problem is headache of actually typing out all 99 required columns!! In this blog…

The post Ideas for select all columns but one mysql stored procedure first appeared on Change Is Inevitable.

No More Spool Space Teradata Query Solution

Kedar — Tue, 02 Mar 2010 14:06:26 +0000

Have you ever come across a situation called NO MORE SPOOL SPACE? My friend does and hence I studied a bit about Teradata. The error: “NO MORE SPOOL SPACE”. Correct, the problem…

The post No More Spool Space Teradata Query Solution first appeared on Change Is Inevitable.

5 useful MySQL Command Options-pager-prompt-rehash-tee-system

Kedar — Sat, 27 Feb 2010 17:34:40 +0000

There are set of commands that MySQL itself interprets. You may use “help” or “\h” at the mysql> prompt to list them. Below are the 5 most useful MySQL Command…

The post 5 useful MySQL Command Options-pager-prompt-rehash-tee-system first appeared on Change Is Inevitable.

QA-Testing Definitions-Interview Questions: Part-III

Madhumita — Fri, 26 Feb 2010 21:26:20 +0000

QA-Testing Definitions-Interview Questions: III (T – Z): Race Condition: A cause of concurrency problems. Multiple accesses to a shared resource, at least one of which is a write, with no…

The post QA-Testing Definitions-Interview Questions: Part-III first appeared on Change Is Inevitable.

QA-Testing Definitions-Interview Questions: Part-II

Madhumita — Fri, 26 Feb 2010 21:23:12 +0000

QA-Testing Definitions-Interview Questions: II (F – S): Data Dictionary: A database that contains definitions of all data items defined during analysis. Data Flow Diagram: A modeling notation that represents a…

The post QA-Testing Definitions-Interview Questions: Part-II first appeared on Change Is Inevitable.

QA-Testing Definitions-Interview Questions: Part-I

Madhumita — Fri, 26 Feb 2010 21:17:22 +0000

QA-Testing Definitions-Interview Questions: I (A – I) Acceptance Testing: Testing conducted to enable a user/customer to determine whether to accept a software product. Normally performed to validate the software meets…

The post QA-Testing Definitions-Interview Questions: Part-I first appeared on Change Is Inevitable.

God-Sachin Tendulkar takes Cricket on New Heights-Records Machine

Kedar — Thu, 25 Feb 2010 09:55:56 +0000

They say, If cricket is a religion Sachin is the God. It’s been 2,961 matches and 39 years when the first ODI was played. On 24th February 2010, Sachin Tendulkar…

The post God-Sachin Tendulkar takes Cricket on New Heights-Records Machine first appeared on Change Is Inevitable.

codeorgan-give sound to your webpage-website

Kedar — Fri, 19 Feb 2010 15:52:40 +0000

UPDATE: This project seems to be closed. Today I found an interesting site which plays your website!! Yep… it’s codeorgan.com. The codeorgan analyzes the body content of any website /…

The post codeorgan-give sound to your webpage-website first appeared on Change Is Inevitable.

Ash Wednesday:Repent, and believe the Gospel and MySQL

Kedar — Wed, 17 Feb 2010 16:04:11 +0000

It’s Ash Wednesday today (Feb 17th 2010) !! I learnt that Ash Wednesday derives its name from the practice of placing ashes as a Sign of the Cross on the…

The post Ash Wednesday:Repent, and believe the Gospel and MySQL first appeared on Change Is Inevitable.

Audit-Checking login history-to know WHO DID THAT on Redhat Linux

Kedar — Tue, 16 Feb 2010 15:51:22 +0000

I’m using Redhat Linux (RHEL 5). Yesterday I saw a bit suspicious activities and data movements under my “home” (/home/username directory). I thought of investigate / audit through my Redhat linux…

The post Audit-Checking login history-to know WHO DID THAT on Redhat Linux first appeared on Change Is Inevitable.

Buzz: Google buys Aardvark for Social Questioning

Kedar — Mon, 15 Feb 2010 19:19:00 +0000

Google announced acquisition of Aardvark – The new kind of social search. Through the “social search” term I thought it has to do something with what Google’s has said earlier…

The post Buzz: Google buys Aardvark for Social Questioning first appeared on Change Is Inevitable.

MyDumpSplitter-Extract split database or tables from mysqldump

Kedar — Thu, 11 Feb 2010 13:05:57 +0000

The Mysqldumpsplitter can extract database, table, all databases, all tables or tables matching on regular expression from a mysqldump. It can produce the compressed output of sqls in specified directories.…

The post MyDumpSplitter-Extract split database or tables from mysqldump first appeared on Change Is Inevitable.

FIFA Football World Cup-2010 South Africa-Winner Announced!

Kedar — Wed, 10 Feb 2010 06:14:25 +0000

Wikipedia says: “The 2010 FIFA World Cup will be the 19th FIFA World Cup, the premier international football tournament. It is scheduled to take place between 11 June and 11…

The post FIFA Football World Cup-2010 South Africa-Winner Announced! first appeared on Change Is Inevitable.

Whats New-Google Buzz in Gmail Inbox, Mobile

Kedar — Wed, 10 Feb 2010 09:48:19 +0000

This morn one more way of e-socializing introduced by google – Google Buzz. It’s a one of the trending topic on twitter… How to get Google buzz: Well it’s being…

The post Whats New-Google Buzz in Gmail Inbox, Mobile first appeared on Change Is Inevitable.

How to bulk rename table MySQL

Kedar — Mon, 08 Feb 2010 14:26:19 +0000

Are you tired of manually renaming MySQL tables, one by one, especially when dealing with a large number of them? In this guide, we’ll introduce you to a MySQL stored…

The post How to bulk rename table MySQL first appeared on Change Is Inevitable.

How music can rescue-Help for Haiti-Download to Donate campaign

Kedar — Mon, 08 Feb 2010 07:06:06 +0000

Barely a week after tragedy hit Haiti in the form of a massive earthquake, my favourites Linkin Park along with many other artists have stepped forward to help the country’s…

The post How music can rescue-Help for Haiti-Download to Donate campaign first appeared on Change Is Inevitable.

Oracle query-eliminate duplicate but one using rowid

Kedar — Mon, 08 Feb 2010 12:02:09 +0000

Yesterday a friend came across an oracle query problem: Consider below table: cid cname.... cdata 1 x xxxx 1 x xxxx .. 2 xzzz fjnd 3 a evddd Now the…

The post Oracle query-eliminate duplicate but one using rowid first appeared on Change Is Inevitable.

Jokes Fun One-liners: Anti-bored Dose – I

Kedar — Sat, 06 Feb 2010 15:30:19 +0000

It’s been long I have read jokes online, but last week I happen to read a few best jokes. Mostly these are all realted to technology / IT / Computers…

The post Jokes Fun One-liners: Anti-bored Dose – I first appeared on Change Is Inevitable.

How to Load Delimited Data CSV Excel to MySQL

Kedar — Mon, 11 Jan 2010 12:11:55 +0000

Loading CSV to MySQL or any delimited data files to MySQL database is a very common task frequently questioned about and almost every-time LOAD DATA INFILE come into rescue. I’ll…

The post How to Load Delimited Data CSV Excel to MySQL first appeared on Change Is Inevitable.

My Google Exploitation – Web History Graphs 2009

Kedar — Fri, 08 Jan 2010 14:52:27 +0000

Well no doubt I’m a google freak. I’ve learnt a lot through it and I have searched a lot. But I wasn’t much aware about my intencity of googling stuffs.…

The post My Google Exploitation – Web History Graphs 2009 first appeared on Change Is Inevitable.

crontab not working with dynamic date filename – rhel linux

Kedar — Thu, 07 Jan 2010 09:34:05 +0000

I have done it for so many times, setting a cronjob. Today I was tring to set a simple cronjob which will output the log file with timestamp attached filename.…

The post crontab not working with dynamic date filename – rhel linux first appeared on Change Is Inevitable.

3 idiot text of speech from Mr. Chatur Silencer

Kedar — Mon, 04 Jan 2010 16:23:50 +0000

Well 3 idiot was no doubt one of the best movie of last decade (Released 2009). Apart from everything I laughed a lot at speech from Mr. Silencer, where Rancho…

The post 3 idiot text of speech from Mr. Chatur Silencer first appeared on Change Is Inevitable.

waiting for another Avatar – discussion

Kedar — Sat, 02 Jan 2010 20:59:32 +0000

Are we waiting for another “Avatar”?? As per Hindu mythology, lord Vishnu took 10 different avatars to save our world. As per mythology, lord Vishnu will take avatar when Rakshasas…

The post waiting for another Avatar – discussion first appeared on Change Is Inevitable.

Petition – Help saving MySQL – II

Kedar — Tue, 29 Dec 2009 05:21:28 +0000

And I looked back and thought of updating this post… Recently Monty has posted again and I completely convinced with whatever Monty has conveyed now or earlier. The explainations he has provided under self-interview,…

The post Petition – Help saving MySQL – II first appeared on Change Is Inevitable.

MySQL Memory Usage Limits on 32 bit Linux

Kedar — Fri, 18 Dec 2009 00:34:50 +0000

I’m having RHEL 5 (32-bit) and MySQL-5. I was trying to check how much is the Memory Utilization limits for MySQL 5 on 32bit OS. We can easily calculate the…

The post MySQL Memory Usage Limits on 32 bit Linux first appeared on Change Is Inevitable.

MySQL Certification Free Retake: Get TWO chances to get MySQL Certified

Kedar — Tue, 15 Dec 2009 11:56:52 +0000

Recently MySQL has offered MySQL Certification Free Retake on both DBA or Developer Certifications for a limited time. For MySQL Certifications: 1. MySQL 5.0 Data Base Administrator Certification (SCMDBA) –…

The post MySQL Certification Free Retake: Get TWO chances to get MySQL Certified first appeared on Change Is Inevitable.

Monty: Help Saving MySQL – The Oracle & EC

Kedar — Mon, 14 Dec 2009 06:46:16 +0000

And I looked back and thought of updating this post… We all are aware about the acquisition happened to MySQL; Sun and now Oracle. A common understanding tells me that…

The post Monty: Help Saving MySQL – The Oracle & EC first appeared on Change Is Inevitable.

Stored procedure to Find database objects

Kedar — Sat, 05 Dec 2009 15:13:34 +0000

This procedure lists available database objects under passed database name. It lists present Tables, Views, Stored Procedures, Functions and Triggers under particular database. It also lists storage engine of tables.…

The post Stored procedure to Find database objects first appeared on Change Is Inevitable.

MySQL Stored procedure – Split Delimited string into Rows

Kedar — Sat, 05 Dec 2009 19:58:35 +0000

This procedure will split a “;” separated column in to new fields preserving ids. This is very specific problem, lets check it with example. Consider a sample table test: And…

The post MySQL Stored procedure – Split Delimited string into Rows first appeared on Change Is Inevitable.

MySQL Stored procedure – Execute query if table or Column exists

Kedar — Sat, 05 Dec 2009 19:42:01 +0000

Well procedures mainly carried out working with information schema and it’s usage in stored procedure. Procedures are fairly simple and easy to understand. 1. Edit_table – following procedure executes queries to…

The post MySQL Stored procedure – Execute query if table or Column exists first appeared on Change Is Inevitable.

How to echo colored text in linux shell script

Kedar — Fri, 04 Dec 2009 21:24:28 +0000

Having a colourful display on shell script is something that’d beautify your experience. Using colour text and echos will help you to highlight and distinguish the shell output on a…

The post How to echo colored text in linux shell script first appeared on Change Is Inevitable.

MySQL master master replication monitor with php code

Kedar — Fri, 04 Dec 2009 19:26:52 +0000

For monitoring replication we know a lot of tools and codes – but this one is different because I wrote it 😉 Well this is fairly simple php code for…

The post MySQL master master replication monitor with php code first appeared on Change Is Inevitable.

Using VLookup like Batch script to compare two excel / csv

Kedar — Tue, 24 Nov 2009 15:35:04 +0000

Using Vlookup: I have two csv files; File1 has Id and Value Columns and File2 has Id. Problem: I need to compare both files and put respective values to File2…

The post Using VLookup like Batch script to compare two excel / csv first appeared on Change Is Inevitable.

bat – batch file to create formatted date time (ddmmyyyy) directory

Kedar — Wed, 18 Nov 2009 10:19:45 +0000

In batch scripting, generating file and directory names with current date and time stamps can greatly enhance organization and workflow. This tutorial will walk you through various code snippets and…

The post bat – batch file to create formatted date time (ddmmyyyy) directory first appeared on Change Is Inevitable.

Calculate MySQL Memory Usage – Quick Stored Procedure

Kedar — Mon, 16 Nov 2009 21:41:28 +0000

In this post we will look into the MySQL memory utilization estimation or calculation based on the global variables. Using a simple stored procedure call you can get the memory…

The post Calculate MySQL Memory Usage – Quick Stored Procedure first appeared on Change Is Inevitable.

Scheduled Backup MySQL Administrator & Windows Scheduler – Odd

Kedar — Thu, 12 Nov 2009 09:04:35 +0000

Creating scheduled backup using administrator is an easy task. Follow the GUI and you’re done. But I observed something different! MySQL Version: 5.0.83 Community MySQL Administrator: 1.2.17 Machine: Intel P4,…

The post Scheduled Backup MySQL Administrator & Windows Scheduler – Odd first appeared on Change Is Inevitable.

Monitor multiple mysql replication using php: Updated

Kedar — Wed, 11 Nov 2009 15:21:25 +0000

Monitoring a replication is an important aspect. As replication includes multiple nodes, it is essential to track activity and status across all mysql servers involved in replication. To monitor replication…

The post Monitor multiple mysql replication using php: Updated first appeared on Change Is Inevitable.

Movie review: Ajab Prem Ki Gajab Kahani

Kedar — Mon, 09 Nov 2009 12:59:32 +0000

Yes !! It is a Gajab Kahani, the name is perfectly chosen by the director Rajkumar Santoshi but it would have been better if he had taken a better script and…

The post Movie review: Ajab Prem Ki Gajab Kahani first appeared on Change Is Inevitable.

Buy Zune HD at Low Rates – Free Discount Coupon $15

Kedar — Wed, 04 Nov 2009 11:30:12 +0000

Hi All,I have figured out a way to get Zune HD discounted 15$ … Yes 15 $.What you have to do is go to dell site using following coupon link below:http://2b592ab2.linkbucks.comAdd…

The post Buy Zune HD at Low Rates – Free Discount Coupon $15 first appeared on Change Is Inevitable.

London dreams – 2009 – xtreme Movie review

Kedar — Wed, 04 Nov 2009 05:08:22 +0000

Simply tragedic, pityful, disgusting and many words… Movie is far from reality and close to cruelty. The best thing about London Dreams is that it had an end, though nonsense,…

The post London dreams – 2009 – xtreme Movie review first appeared on Change Is Inevitable.

Install 2 MySQL Server instances replication on Windows

Kedar — Wed, 04 Nov 2009 07:56:02 +0000

At times you need to install multiple MySQL instances on same machine. This article is a brief step-by-step tutorial on the subject task which is divided into the following main…

The post Install 2 MySQL Server instances replication on Windows first appeared on Change Is Inevitable.

Replication slave lag monitoring using heartbeat and windows batch scripts

Kedar — Wed, 04 Nov 2009 07:54:07 +0000

“Show Slave Status” command has a last column “Seconds_Behind_Master”, which gives us idea about how much time slave is lagging behind master. It is an important to be considered parameter…

The post Replication slave lag monitoring using heartbeat and windows batch scripts first appeared on Change Is Inevitable.

how to search / find through all databases, tables, columns in MySQL

Kedar — Thu, 29 Oct 2009 08:04:35 +0000

What will you do if one day some one ask you to find single string in all databases, all tables and in all columns, In MySQL Database? This article presents a practical solution…

The post how to search / find through all databases, tables, columns in MySQL first appeared on Change Is Inevitable.

MySQL Master Master Replication and auto_increment_increment / auto_increment_offset

Kedar — Sun, 20 Sep 2009 07:59:11 +0000

In this post we will see importance of replication related variables auto_increment_increment & auto_increment_offset with respect to MySQL Master Master setup. Consider we’ve already set a master-master replication. Now create…

The post MySQL Master Master Replication and auto_increment_increment / auto_increment_offset first appeared on Change Is Inevitable.

Ganapati Aarti: Sukhkarta Dukhharta – With English Translation | download mp3

Kedar — Sat, 22 Aug 2009 10:48:20 +0000

Ganapati Aarti: Sukhkarta Dukhharta ।। श्री गणेशाय नमः ।। सुखकर्ता दुखहर्ता वार्ता विघ्नाची |नुरवी पूर्वी प्रेम कृपा जयाची |सर्वांगी सुंदर उटी शेंदुराची |कंठी झळके माळ मुक्ताफळाची || १ || जय…

The post Ganapati Aarti: Sukhkarta Dukhharta – With English Translation | download mp3 first appeared on Change Is Inevitable.

Unique birthday card wishes for My dear Brother

Kedar — Sat, 11 Jul 2009 11:56:30 +0000

This is an online birthday card wish to my dear brother. Click to view the Online Birthday Card: Happy Birthday Kaushik. Most people find it little difficult to guess the…

The post Unique birthday card wishes for My dear Brother first appeared on Change Is Inevitable.

The Dos Chat – Lan Messenger

Kedar — Fri, 08 May 2009 08:14:45 +0000

This is a LAN Messenger which allows you to chat with friends on local network. The Dos based chat program is just like a chat program but only for LAN.…

The post The Dos Chat – Lan Messenger first appeared on Change Is Inevitable.

Selected Oscar Wilde Quotes

Kedar — Wed, 01 Apr 2009 04:22:46 +0000

Oscar Fingal O’Flahertie Wills Wilde!! Oscar Wilde is well known for his biting wit. And he has an extraordinary way of representing the things. Here is some collection of famous…

The post Selected Oscar Wilde Quotes first appeared on Change Is Inevitable.

Gulaal movie – music and lyrics

Kedar — Sat, 07 Mar 2009 10:54:32 +0000

Its been long since i’ve heard such contentful, meaningful, provoking and great lyrics with such gr8 musical representation.The lines they’ve written are just mind-blowing. Music is awesome and vocals as…

The post Gulaal movie – music and lyrics first appeared on Change Is Inevitable.

Regular Expression Basics – Quick Reference

Kedar — Wed, 04 Mar 2009 09:31:11 +0000

Characters Character Description Example Any character except [\^$.|?*+() All characters except the listed special characters match a single instance of themselves. { and } are literal characters, unless they’re part…

The post Regular Expression Basics – Quick Reference first appeared on Change Is Inevitable.

Quick look at subversion / svn commands – overview

Kedar — Wed, 04 Mar 2009 08:12:52 +0000

About Subversion: Subversion, also known as svn, is a version control system much like the Concurrent Versions System (CVS). Version control systems allow many individuals (who may be distributed geographically)…

The post Quick look at subversion / svn commands – overview first appeared on Change Is Inevitable.

Delhi 6 – Movie review

Kedar — Sat, 21 Feb 2009 05:26:46 +0000

Delhi 6…It was a regular weekend and as usual i was expecting a good time with Delhi 6! Movie starts with a “Kala Bandhar” [monkey-man] fear in Delhi. A parallel shot…

The post Delhi 6 – Movie review first appeared on Change Is Inevitable.

Dev D – Movie review

Kedar — Thu, 12 Feb 2009 05:31:41 +0000

Hi all,I don’t know why but just wanted to talk about the movie dev-d. I a lot of fun.TOI reports were 5-stars and we were damn eager to know the…

The post Dev D – Movie review first appeared on Change Is Inevitable.

Funny Computer laws – quotes

Kedar — Wed, 04 Feb 2009 07:23:42 +0000

Amdahl’s Law: The speed-up achievable on a parallel computer can be significantly limited by the existence of a small fraction of inherently sequential code which cannot be parallelised. (Gene Amdahl)…

The post Funny Computer laws – quotes first appeared on Change Is Inevitable.

Collection for insulting – one liners

Kedar — Wed, 04 Feb 2009 01:53:02 +0000

Collection of insulting one-liners: A demitasse would fit his head like a sombrero. (Thanks, Chris Cole) A guy with your IQ should have a low voice too! A half-wit gave…

The post Collection for insulting – one liners first appeared on Change Is Inevitable.