Monthly Archives - October 2010

Percona Server 5.1.51-rel11.5

Percona Community,
Percona Server version 5.1.51-rel11.5 is now available for download.
The main purpose of this release is to update the current Percona stable release to the latest version of MySQL 5.1.
Functionality Added or Changed

 Percona Server 5.1.51-rel11.5 is now based on MySQL 5.1.51.
 New Features Added: None
 Other Changes: None

Bugs Fixed

 Bug #661354 – Fixed a problem compiling query_cache_with […]

Read more

Sharing an auto_increment value across multiple MySQL tables (revisited)

A couple of weeks ago I blogged about Sharing an auto_increment value across multiple MySQL tables. In the comments, a few people wrote in to suggest alternative ways of implementing this.  I just got around to benchmarking those alternatives today across two large EC2 machines: (more…)

Read more

MySQL Limitations Part 2: The Binary Log

This is the second in a series on what’s seriously limiting MySQL in certain circumstances (links: part 1). In the first part, I wrote about single-threaded replication. Upstream from the replicas is the primary, which enables replication by writing a so-called “binary log” of events that modify data in the server. […]

Read more

High availability for MySQL on Amazon EC2 – Part 5 – The instance monitoring script

This post is the fifth of a series that started here.
From the previous posts of this series, we now have an instance restart script that can restart the database node in case of failure and automatically reconfigure Pacemaker and the other servers that needs to access the MySQL server. What we will […]

Read more

Percona Server with XtraDB Case Study, Behind the Scenes

We’ve published our first case study. The customer, ideeli, had a database that was struggling on standard MySQL and InnoDB. The big win was the upgrade to XtraDB. The business continued to grow quickly, and months later under much more traffic, the database is still outperforming their previous version.
I thought I’d write […]

Read more

MySQL Limitations Part 1: Single-Threaded Replication

I recently mentioned a few of the big “non-starter” limitations Postgres has overcome for specific use cases. I decided to write a series of blog posts on MySQL’s unsolved severe limitations. I mean limitations that really hobble it for major, important needs — not in areas where it isn’t used, but in […]

Read more