Percona Performance Conference CFP deadline extended

Even though we haven’t yet gotten a schedule online, we’re still accepting proposals for the Percona Performance Conference.
As a teaser, let me just share one accepted proposal with you: Cary Millsap. If you are even vaguely involved with Oracle, you should know who he is. He is one of the world’s foremost […]

Read more

Making replication a bit more reliable

Running MySQL slave is quite common and regular task which we do every day, taking backups from slave is often recommended solution. However the current state of MySQL replication makes restoring slave a bit tricky (if possible at all). The main problem is that InnoDB transaction state and replication state are not synchronized. […]

Read more

10 things you need to know about backup solutions for MySQL

Are you using someone else’s backup solution for your MySQL data? Do you care a lot about your data? Are you sure you’re getting a reliable, recoverable backup that’ll work for your business and your application, and won’t impact your critical processes while it runs? Here are ten questions you need to be able […]

Read more

SSD, XFS, LVM, fsync, write cache, barrier and lost transactions

We finally managed to get Intel X25-E SSD drive into our lab. I attached it to our Dell PowerEdge R900. The story making it running is worth separate mentioning – along with Intel X25-E I got HighPoint 2300 controller and CentOS 5.2 just could not start with two RAID controllers (Perc/6i and HighPoint 2300). […]

Read more

XtraDB storage engine release 1.0.2-3 (Spring edition) codename Sapporo

Today we announce release 1.0.2-3 of our XtraDB storage engine.
Here is a list of enhancements:

Move to MySQL 5.1.31
Scalability fix — ability to use several rollback segments
Increasing the number of rseg may be helpful for CPU scale of write-intentional workloads. See benchmark results.
Scalability fix — replaced page_hash mutex to page_hash read-write lock. […]

Read more