Category: MySQL-Articles

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.

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.

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. To restore from the backup we used xtrabackup binaries and ran into issues following standard commands (assuming no changes): To prepare the backup I used apply-log as follows: $] innobackupex-1.5.1 –defaults-file=/usr/local/mysql/data/backup-my.cnf –apply-log  /usr/local/mysql/data –ibbackup […]

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 backup your MySQL user privileges? One can easily forget to backup the user privileges but it is much easier to do and you should backup […]

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 looks something like this: Company1 Street Name City, MyState 8582 (999)999-999 another_Company Another Street 2 New City, NWSTATE 8582 (111)111-1111 So how’d you go about […]

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 having foreign key constraints. SQL for tables used in example: create database temp;use temp; drop table if exists city; drop table if exists country; […]

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 you about security aspects of stored routines by means of example. By the definition of a Stored Routine, – DEFINER clause specifies the creator of […]

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. Case Sensitivity and Issue: Yes, that can create big issues when you have to deal with systems having different case sensitivity. E.g. on linux you can create […]