Monthly Archives - October 2013

Percona Server 5.6.14-62.0 is now available

Percona Server version 5.6.14-62.0
Percona is glad to announce the release of Percona Server 5.6.14-62.0 on October 24th, 2013 (Downloads are available here and from the Percona Software Repositories.
Based on MySQL 5.6.14, including all the bug fixes in it, Percona Server 5.6.14-62.0 is the current GA release in the Percona Server 5.6 series. All of […]

Read more

Problems with Multiple XA Storage Engines in MySQL 5.6

While integrating TokuDB into MySQL 5.6, we found that MySQL 5.6 does not support more than one XA storage engine. For example, there is an assert in the ha_recover function that fires when the total number of XA storage engines is greater than one. After disabling this assert, we found lots of bugs in […]

Read more

High-availability options for MySQL, October 2013 update

The technologies allowing to build highly-available (HA) MySQL solutions are in constant evolution and they cover very different needs and use cases. In order to help people choose the best HA solution for their needs, we decided, Jay Janssen and I, to publish, on a regular basis (hopefully, this is the first), an update […]

Read more

New MySQL features, related technologies at Percona Live London

The upcoming Percona Live London conference, November 11-12, features quite a number of talks about the latest MySQL features and related technologies. There will be a lots of talks about the new MySQL 5.6 features:

Opening keynote highlights MySQL 5.6 new features.
New InnoDB Compression talk will cover the new compression algorithm, implemented by Facebook and included […]

Read more

The power of MySQL GROUP_CONCAT

MySQL GROUP_CONCAT

In the very early days of Percona, Vadim wrote very nice post about MySQL GROUP_CONCAT (GROUP_CONCAT).
But I want to show you a bit more about it.
When is MySQL GROUP_CONCAT useful? Usually while working with Support customers I recommend it when you have aggregation of many-to-many info. It makes the view simpler and more beautiful and it […]

Read more

MySQL 5.6’s new replication features: Benefits, Limitations and Challenges

On Wednesday I’ll be leading a webinar exploring MySQL 5.6’s new replication features. And yes, as usual I’ll deliver news on the good, the bad and the ugly (that is to say the benefits, limitations and challenges).
The webinar, appropriately titled, “New Replication Features in MySQL 5.6: Benefits, Limitations, and Challenges“, is scheduled for Oct. […]

Read more

MySQL Spatial Functions for Geo-Enabled Applications

Geo-enabled (or location enabled) applications are very common nowadays and many of them use MySQL spatial functions. The common tasks for such applications are:

Find all points of interests (i.e. coffee shops) around (i.e. a 10 mile radius) the given location (latitude and longitude). For example we want to show this to a user of […]

Read more

Announcing TokuMX v1.3

Tokutek is pleased to announce today’s release of TokuMX v1.3.
The goal of this release was to bring full MongoDB v2.4 compatibility (with the noted exception of Text Search and Geospatial Indexes). The initial release of TokuMX was based on MongoDB v2.2, but we’ve been busy back-porting interesting MongoDB v2.4 features along the way. After […]

Read more