EmergencyEMERGENCY? Get 24/7 Help Now!

Replication of MEMORY (HEAP) Tables

 | October 15, 2010 |  Posted In: Insight for DBAs, MySQL

Some Applications need to store some transient data which is frequently regenerated and MEMORY table look like a very good match for this sort of tasks. Unfortunately this will bite when you will be looking to add Replication to your environment as MEMORY tables do not play well with replication.

Read More

Percona Server 5.1.50-rel12.1

 | October 14, 2010 |  Posted In: MySQL, Percona Software

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 […]

Read More

Percona White Paper: Architecting SaaS Applications with XtraDB

 | October 11, 2010 |  Posted In: Events and Announcements, MySQL

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 best explanation of […]

Read More

The story of one MySQL Upgrade

 | October 8, 2010 |  Posted In: Insight for DBAs, MySQL

I recently worked on upgrading MySQL from one of very early MySQL 5.0 versions to Percona Server 5.1. This was a classical upgrade scenario which can cause surprises. Master and few slaves need to be upgraded. It is a shared database used by tons of applications written by many people over more than 5 years […]

Read More

Percona at WebConf Riga 2010

 | October 6, 2010 |  Posted In: Events and Announcements, MySQL

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 […]

Read More

Talks in Moscow, Minsk, Samara

 | October 5, 2010 |  Posted In: Events and Announcements, MySQL

I have my schedule pretty busy during a trip to Russia this year. In addition to giving a master class and Sphinx Conference I’m going to speak at HighLoad++. I’ll also have a user meeting presentations in Samara on October 17 and Minsk on October 22 This looks like it is going to be a […]

Read More

Sharing an auto_increment value across multiple MySQL tables

 | October 4, 2010 |  Posted In: Benchmarks, Insight for Developers, MySQL

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:

Option #2: Use a table with one just row:

Read More

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.