Buy Percona ServicesBuy Now!

xtrabackup-0.5, bugfixes, incremental backup introduction

 | April 7, 2009 |  Posted In: Percona Software

I am happy to announce next build of our backup tool. This version contains several bugfixes and introduces initial implementation of incremental backup. Incremental backup works in next way. When you do regular backup, at the end of procedure you can see output:

which gives start point 1319:813219999 for further incremental backup. This point […]

Read More

xtrabackup-0.4, going beta, progress meter

 | March 30, 2009 |  Posted In: Percona Software

We added some new features to our backup tool, namely: Now we can handle log file taken during backup with size exceeding 4GB, it may happen if backup takes too long and you have a lot of updates on InnoDB tables Progress meter during recovery step, now you can see what percentage of log file […]

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

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

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

 | March 2, 2009 |  Posted In: Percona Software

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

Read More

Percona XtraBackup: Open Source Alternative for InnoDB Hot Backup call for ideas

 | February 24, 2009 |  Posted In: Percona Software

For long time as main backup solution for MySQL on Linux we have been using LVM snapshots. Performance concerns from performance critical envinronment caused us to do LVM performance research which showed horrible results forcing us to look at more performing alternatives. Innodb Hot Backup is a good working solution but it is not Open […]

Read More

Limiting InnoDB Data Dictionary

 | February 11, 2009 |  Posted In: Percona Software

One of InnoDB’s features is that memory allocated for internal tables definitions is not limited and may grow indefinitely. You may not notice it if you have an usual application with say 100-1000 tables. But for hosting providers and for user oriented applications ( each user has dedicated database / table) it is disaster. For […]

Read More

Pretending to fix broken group commit

 | February 2, 2009 |  Posted In: Percona Software

The problem with broken group commit was discusses many times, bug report was reported 3.5 years ago and still not fixed in MySQL 5.0/5.1 (and most likely will not be in MySQL 5.1). Although the rough truth is this bug is very hard (if possible) to fix properly. In short words if you enable replication (log-bin) on server […]

Read More