- XA/2-Phase Commit support
- Native online backup Driver
Online backup is really cool! I have heard that it may soon be released in a coming version of 5.4, so lets hope that this is true.
In a little test, I did a backup of a 10GB database in 49.26 seconds! Admitedly this was on a system with 4 15K drives in a RAID 0 configuration. But that is still a fantastic, considering the tables are not even locked during this time!
The database itself took 19 min. 56 sec. to generate. A complete restore took only 14 min. 29 sec.
But, it gets even better....
I have been working on PBXT 1.1, where I have done a number of things to improve the I/O performance of the engine.
In the same test as above, run with PBXT 1.1, the time to generate the database was 9 min. 35 sec., and the time to restore was 6 min 18 sec! (Time to generate the backup was identical.)
PBXT 1.1 is available directly from Launchpad here: lp:~pbxt-core/pbxt/staging, if you are interested in trying it out. 1.1 also has full support for memory based tables.
The new release candidate (PBXT 1.0.09) can be downloaded from primebase.org/download. It is also available from Lauchpad as the rc3 series: lp:pbxt/rc3.
Please report bugs here.
Any feedback is welcome! You can use Launchpad questions or the PBXT mailing list for this purpose.