Monthly Archives - October 2010

Percona Server 5.1.50-rel12.1

Dear Community,
Percona Server version 5.1.50-rel12.1 RC is now available for download.
Functionality Added or Changed

Percona Server 5.1.50-rel12.1 is now based on MySQL 5.1.50.
New Features Added:

innodb_lru_dump_restore – Implemented automatic dumping of the buffer pool at specified intervals.
innodb_buffer_pool_shm – Implemented option ”innodb_buffer_pool_shm_checksum”; when enabled, shared memory buffer pool is checksum validated. This change also fixed these bugs: […]

Read more

Percona White Paper: Architecting SaaS Applications with XtraDB

Vadim and I have just published a new technical white paper. It shows how Percona Server with XtraDB can make large-scale multi-tenant databases easier to build with MySQL. Our experiences working with SaaS and shared-hosting companies influenced the features we included in Percona Server and XtraDB, and I think this is the […]

Read more

Percona at WebConf Riga 2010

My colleague Aleksandr Kuzminsky will be speaking at WebConf Riga 2010 next month on XtraBackup: Hot Backups and More and Recovery of Lost or Corrupted InnoDB Tables.
WebConf is the first big conference of its kind in the Baltic states (Estonia, Latvia, Lithuania) and we are very happy to be participating.
In addition to Aleksandr’s talks, […]

Read more

Sharing an auto_increment value across multiple MySQL tables

The title is SEO bait – you can’t do it. We’ve seen a few recurring patterns trying to achieve similar – and I thought I would share with you my favorite two:
Option #1: Use a table to insert into, and grab the insert_id:

Shell

CREATE TABLE option1 (id int not null primary key auto_increment) engine=innodb;

# […]

Read more