A brief about Mysql Storage Engine

A storage engine is a software Component that a database management system uses to create CRUD operation. Different Type of… Read More

Facebook Chatbot Architecture

Use Case: We required to build a standalone chatbot server. Since we need to incorporate a reasonable amount of intelligence… Read More

To remove leading zeros in MySql

To remove leading zeros from field following is the solution select TRIM(Leading ‘0’ from FIELD) from Table

How to set up Mysql Master-Slave Replication

Replication consists of following 3 parts…. The master records changes to its data in its binary log (Binary Log Events)…. Read More

Recovering database from MySQL 4.x

Recently I was involved with a task to recover a database on MySQL 4.x that crashed. Below are the steps… Read More