In my previous post I showed you how to setup Percona XtraDB Cluster 5.6 on Docker. This time I will show you how to setup Percona ClusterControl and add the existing Percona XtraDB Cluster 5.6 that we’ve managed to setup from the previous post.

Let us note the following details about our existing containers:

• 172.17.0.2 dockerpxc1
• 172.17.0.3 dockerpxc2
• 172.17.0.4 dockerpxc3
• 172.17.0.5 dockerccui-test

A quick tip for everyone who has followed my previous blog on setting up Percona XtraDB Cluster 5.6 on Docker: I did not …

As promised, here is the belated post covering the MySQL 5.7.2 Milestone Release, released on September 21, 2013. You can find the full list of changes and bug fixes in the 5.7.2 Release Notes. Enjoy!

InnoDB Read-Only Scalability

One of the goals of 5.7 is to improve performance for Read-Only (RO) and Read-Mostly workloads. In 5.7.2 Sunny Bains made several improvements (see below) and we reached 500K QPS performance levels in the OLTP_RO Point-Selects 8-tables benchmark.  See also Dimitri Kravtchuk’s blog post.

Do Not Allocate trx id for Read-Only Transactions ( …

DELIMITER $$                    -- Change the delimiter

DROP PROCEDURE IF EXISTS demo$$ -- Remove if previously exists
CREATE PROCEDURE demo()         -- Create Stored Procedure
BEGIN                           -- Start of definition
    DECLARE my_int INT;         -- Declare variables
    DECLARE my_big_int BIGINT;
    DECLARE my_text TEXT;

    DECLARE my_name VARCHAR(30) -- Declare variables with 
        DEFAULT 'Rookie Dev';   -- default value set

    SET my_int = 20;            -- Set variables to values …

In my previous post about geo-spatial search in MySQL I described (along with other things) how to use geo-distance functions. In this post I will describe the geo-spatial distance functions in more details.

If you need to calculate an exact distance between 2 points on Earth in MySQL (very common for geo-enabled applications) you have at least 3 choices.

• Use stored function and implement haversine formula
• Use UDF (user defined function) for haversine (see below)
• In MySQL 5.6 you can use st_distance …

Amidst various blog postings on Docker, a security issue announced yesterday that detailed an exploit of Docker that makes it possible to do container breakout. This exploit would allow the ability to any data, including sensitive data, on the host system.

How does it work? Essentially, the file system struct of the container is shared with the host which allows a program on the container to run that can open file handles-- which consist of a 64-bit string and a 32-bit inode number. Starting at an inode value of 2, which is / (root filesystem), the file system path is then walked and the use of brute force the 32-bit inode number to find the desired file.

The code to test this, shocker.c, which was developed by Sebastian Krahmer …

MySQL Central @ OpenWorld, taking place in San Francisco September 28 - October 2, will feature keynotes, conference sessions, tutorials, hands-on labs, as well as birds-of-a-feather sessions.

The Content catalog listing the MySQL Central @ OpenWorld sessions is available here.

Some of the sessions you will be able to attend include:

Keynotes:

The State of the Dolphin
Join Edward Screven, Oracle’s Chief Corporate Architect, and Tomas Ulin, vice president of MySQL Engineering, for the “State of the Dolphin” keynote address. You’ll learn about Oracle’s MySQL strategy as well as the latest MySQL …

Taxonomy upgrade extras: channelgaleraclusterfail-overreplicationmasterslave

Sometimes it could be desirable to replicate from a Galera Cluster to a single MySQL slave or to an other Galera Cluster. Reasons for this measure could be:

• An unstable network between two Galera Cluster locations.
• A separation of a reporting slave and the Galera Cluster so that heavy reports on the slave do not affect the Galera Cluster performance. …

ibdconnect is a tool to connect an ibd file to a foreign ibdata file. it’s important to understand how it works as secondary keys may cause interesting behavior.

Here is a table with a unique secondary key:

CREATE TABLE `t1` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`value` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `uni_value` (`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

When I update InnoDB dictionary with ibdconnect it all goes well:

# ./ibdconnect -f  t1.idb -o  /var/lib/mysql/ibdata1 -d test -t t1

…

Updating test/t1 (table_id 13) with id 0xA3060000
SYS_TABLES is updated successfully
…

SYS_INDEXES is updated successfully
ibdconnect modifies content of ibdata1, so checksums are wrong now. innochecksum_changer from …

In this webinar, our co-founder Baron Schwartz provides an overview of statistical anomaly detection, a monitoring method gaining traction in database administration.

If you did not have a chance to join the webinar, the slide deck is embedded. You can also register for a recording here.

Fifty eight sessions, tutorials, and birds-of-a-feather gatherings at MySQL Central at Oracle Open World! Be sure to check out the following sessions (my favorites) and register ASAP as tickets will go quickly.

• MySQL and Tech Women (or Where Are All the Tech Women?) Erin O’Neill San Francisco MySQL meetup
• MySQL & GIS Alexander Rubin Percona
• The MySQL SYS Schema Mark Leith Oracle
• MySQL 5.6 at Twitter Calvin Sun Twitter & Inaam Rana Twitter