EmergencyEMERGENCY? Get 24/7 Help Now!

Compression for InnoDB backup

 | March 16, 2009 |  Posted In: Benchmarks, Insight for DBAs

Playing with last version of xtrabackup and compress it I noticed that gzip is unacceptable slow for both compression and decompression operations. Actually Peter wrote about it some time ago, but I wanted to review that data having some new information. In current multi-core word the compression utility should utilize several CPU to speedup operation, […]

Read More

xtrabackup-0.3, binaries and stream backup

 | March 13, 2009 |  Posted In: Percona Software

We are coming with next version of xtrabackup – online backup solution for MySQL 5.0 / 5.1 and InnoDB standard version, plugin modification and XtraDB. We still consider it as alpha version, though it shows perfect stable results in our tests. Let me address two often asked question about xtrabackup: 1) Does it work only […]

Read More

Percona at PHP Quebec 09

 | March 10, 2009 |  Posted In: Events and Announcements

Percona presented two talks at PHP Quebec last week – one on A Tour of MySQL High Availability, and another on Performance Tuning MySQL. There was a great reaction to showcasing some of the quick-wins that can be found by using the Percona patches. Unfortunately, the one thing that I forgot to mention in the […]

Read More

When would you use SAN with MySQL ?

 | March 9, 2009 |  Posted In: Hardware and Storage

One question which comes up very often is when one should use SAN with MySQL, which is especially popular among people got used to Oracle or other Enterprise database systems which are quite commonly deployed on SAN. My question in such case is always what exactly are you trying to get by using SAN ?

Read More

Debian / Ubuntu Percona builds

 | March 9, 2009 |  Posted In: Percona Software

We had too many requests for deb builds of Percona releases so I could not ignore that and added scripts to build binaries on our Ubuntu 8.10 box. It’s going to be only 64bit releases (32bit is dead, isn’t it?), and I tested binaries on Debian Lenny system and it seems working fine. So I […]

Read More

Xtrabackup, doing once…

 | March 5, 2009 |  Posted In: Percona Software

After some sprint coding and testing I am more than happy to declare Xtrabackup getting into alpha stage. And alpha means more that we have some dirty hacks in code / not fully scripted builds / not fully tested all MySQL versions, but backups work just fine! I am able to backup our production box […]

Read More

Making replication a bit more reliable

 | March 4, 2009 |  Posted In: Percona Software

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. If we […]

Read More