Monthly Archives - January 2011

Conflict Avoidance with auto_increment_increment and auto_increment_offset

A lot of people are running MySQL Master-Master replication pairs in Active-Passive mode for purpose of high availabilities using MMM or other solutions. Such solutions generally have one major problem – you have to be very carefully switching writes as if you do not do it atomically (such as some scripts […]

Read more

Percona Live Keynote Speaker: Mark Callaghan

Mark Callaghan has graciously accepted to be the closing keynote speaker for Percona Live: San Francisco!
Mark is best known for his work behind MySQL @ Facebook, where he and his team maintain one of the largest MySQL installations around.  They also contribute back to the community with a publicly available branch of enhancements, improved […]

Read more

Percona Server 5.1.54-12.5

Percona Server version 5.1.54-12.5 is now available for download. It is now the current stable release version.
Functionality Added or Changed

Percona Server 5.1.54-12.5 is based on MySQL 5.1.54.
New Features Added: None
Other Changes:

Added system variable innodb_log_block_size and new value “keep_average” to system variable adaptive_checkpoint in Improved InnoDB I/O Scalability. (Yasufumi Kinoshita)
Added new value “ALL_O_DIRECT” to […]

Read more

Percona Server Fast-Restart White Paper Posted

I’ve posted a new white paper about the implementation and benefits of Percona Server’s fast-restart capabilities. Briefly, after shutting down and restarting or rebooting the server, it can be back to full performance in a couple of minutes. That’s minutes, not hours or days. This matters a lot for keeping uptime […]

Read more