(Andrew Morgan) We’re very pleased to announce that MySQL Cluster 7.3 has gone GA; for a full run-down of the new features and enhancements, take a look at the “MySQL Cluster 7.3 New Features for Internet-Scale Performance with Carrier-Grade Availability” white paper but this post will focus on just

(Keith Murphy) More than once I have wished that mysqldump was never created. In many backup scenarios it is better to use other tools such as xtrabackup. However, there is still times when I end up using mysqldump.

(Luís Soares) The goal of this post is twofold: (i) to show the power of GTIDs and MySQL 5.6 replication infrastructure in general; and (ii) show MySQL users a way to hack multi-source replication rather painlessly and rather quickly on top of MySQL 5.6 when using the new MySQL 5.6 replication featu

(Rob Gravelle) A loop is a programming construct that executes a block of code repeatedly based on a condition. Cursors, on the other hand, are utilized to process each row returned by a SELECT statement. In today’s article, we’ll be learning about various loop types supported by MySQL as well as g

(Sean Hull) There are two ways to speedup UNIONs in a MySQL database. First use UNION ALL if at all possible, and second try to push down your conditions.

(Ramesh Sivaraman) Normally in mysql replication Data Control Language (DCL) statements won’t replicate into slave if we are configuring replication with replicate-ignore-db=mysql.

(Josh Berkus) You already know that I’m a big fan of custom aggregates. What’s even more fun is when you combine them with the ordered aggregate feature from PostgreSQL 9.0. For example, let’s take a fairly common task: selecting the item with the maximum importance.

(Keith Murphy) Upgrading from MySQL 5.5 to MySQL 5.6 is a fairly straightforward process. However, the move to version 5.6 does bring with it some new varaibles with which to work.

(Ulf Wendel) PECL/mysqlnd_ms is client-side load balancing driver plugin for PHP MySQL that aims to increase distribution transparency when using any MySQL based cluster: failover, read-write splitting, abstraction on consistency (e.g. read-your-writes), partitioning/sharding support, … it’s all the

(Linas Virbalas) Schema definitions on replication slaves sometimes differ. Ability to rename schemas, tables and columns and still setup replication with comfort is useful for MySQL to MySQL replication, while for heterogeneous topologies like these, it’s a must.