So we tested the 5.6.7-RC. And ran into a strange problem:

Because of a test, a preexisting configuration with GTID enabled existed, and suddenly we did not have properly initialized grants in mysql.* created for a new installation. Turns out: GTID and non-transactional tables are no friends, and that is even documented.

When using GTIDs, updates to tables using nontransactional storage engines such as MyISAM are not supported. This is because updates to such tables mixed with updates to tables that use a transactional storage engine such as InnoDB can result in multiple GTIDs being assigned to the same transaction.

Also, this is supposed to work with GRANT and REVOKE, but not with INSERT and DELETE. Now guess what mysql-install-db and friends are using?

server:~ # less …

Global Transaction Identifiers – why, what, and how Next post: Advanced use of Global Transaction Identifiers
This post was kindly translated to Japanese by Ryusuke Kajiyama.

In MySQL 5.6 we introduced a new replication feature called Global Transaction Identifiers, or GTIDs. While there are many use cases, our primary motivation for introducing GTIDs is that it allows for seamless failover. By this, we mean promoting one of the slaves to be come a master, if the master crashes, with minimal manual intervention and service disruption.

This is the first in a series of several blog posts. We will go through several use cases and show how easy it is to do a failover. We explain …

I’ve just finished presenting my work on adaptive fault detection at Surge and Percona Live NYC. My slides are available on Slideshare, and embedded below.

Adaptive Fault Detection from xaprb

Further Reading:

• Products that scale linearly to hundreds of servers
• …

Every so often you hear an idea that makes you wonder why it had not been thought of it before. At the recent Northeast PHP Conference, Sheeri Cabral and I were at the speakers dinner when we heard how the Boston PHP group was training novices. Many folks were joining the Boston PHP book but were just starting out and needed some formalized training. So the brilliant Gene Babon came up with the idea of PHP Peculate. The idea is simple: Everyone buys the same book, reads one chapter a week, and posts answers to exercises online. They had great success with PHP and some other subjects. Sheeri has adapted the idea to MySQL and has just announced MySQL Marinate.

Membership in the …

Welcome to GreenSQLOpenSource Database Firewall download page.
Upgrading your firewall should be considered mandatory from any previous version.

The latest FREE GreenSQL version is called GreenSQL Express.
It supports MySQL / PostgreSQL / Microsoft SQL.
It is available for Linux (Ubuntu and CentOS) and Windows Server.
Both 32 bit and 64 bit versions exist.

Download GreenSQL Express (registration required)

Download GreenSQLOpenSorce Versions (outdated)
GreenSQLOpenSource Version 1.3.0
GreenSQLOpenSource Version 1.2.2

While the index merge access types certainly are useful for a number of queries, there has been some frustration expressed both from customers and the community about how it...

1. is not used when it should have been
2. is used when ref access is obviously better
3. merges suboptimal indexes
4. is too restricted in which conditions can be used

I could come up with numerous examples of related bugs and feature requests dating back more than six years. To list a few: 17673, 30151, 23322, 65274, …

Hi!

Thanks everyone who attended my hands-on lab on MySQL Cluster at MySQL Connect last Saturday.

The following are the links for the slides, the HOL instructions, and the code examples.

I'll try to summarize my HOL below.


Aim of the HOL was to help attendees to familiarize with MySQL Cluster. In particular, by learning:

1. the basics of MySQL Cluster Architecture
2. the basics of MySQL Cluster Configuration and Administration
3. how to start a new Cluster for evaluation purposes and how to connect to it

We started by …

Percona is glad to announce the release of Percona XtraBackup 2.0.3 on October 1st, 2012. Downloads are available from our download site here and Percona Software Repositories.

This release is the current GA (Generally Available) stable release in the 2.0 series.

New Features:

• innobackupex now supports new –move-back option that can be used instead of –copy-back in case there isn’t enough free disk space on the server to copy files. As this option removes backup files, it must be used with caution.

Bugs Fixed:

• Symlink for innobackupex-1.5.1 binary has been broken in the previous version of XtraBackup. Bug …

I’ve just finished presenting my work on adaptive fault detection at Surge and Percona Live NYC. My slides are embedded below.

Executive Summary of Parallel Universe in Powerpoint Presentation is now available at www.paralleluniverse-inc.com/technology.shtml .