… required to start work with Percona XtraDB Cluster Percona XtraDB Cluster is based on Percona Server with XtraDB and includes Write Set REPlication patches. It uses the Galera library, version 2.x, a generic Synchronous Multi-Master replication plugin….1-beta2 State of the art: Galera – synchronous replication for InnoDB Happy clustering! mbgc=’f5f5f5′;ww=’320′;mbc=’cecece’;bbc=’3F79D5…
Post: InnoDB, InnoDB-plugin vs XtraDB on fast storage
… NOTPM XtraDB-1.0.6-9 26160.551 NOTPM InnoDB-plugin is 1.6x times better InnoDB, and XtraDB is 1.7x times better InnoDB-plugin. Now… on FusionIO) To summarize MySQL InnoDB/InnoDB-plugin/XtraDB is not fully able to utilize throughput of FusionIO. XtraDB is doing better job with internal…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
…-bound tasks there. The goal of benchmarks was investigation of InnoDB-plugin and XtraDB scalability in CPU-bound load. CPU specification: processor : 23… MySQL-5.1.30 with InnoDB plugin, Xtradb-1.0.2-1, and XtraDB-1.0.2-2 (rel2). XtraDB-rel2 has not been released… grows up to 16 connections, but after that InnoDB-plugin is dropping down. XtraDB and XtraDB-rel2 seem quite better, I guess this is…
Post: Innodb plugin 1.0.4 released - great job Innobase
… exactly 5 months after release of Innodb Plugin 1.0.3 (I honestly expected to see Innodb Plugin 1.0.4 to be released… adopter” version of a plugin which is a bit of disappointment as we can’t wait for Innodb plugin to become stable/GA… fun part starts – we need to evaluate/benchmark/stress test Innodb Plugin 1.0.4 to integrate it with next XtraDB release.
Post: Statistics of InnoDB tables and indexes available in xtrabackup
… new feature to address this is in XtraDB/InnoDB plugin – fast index creation. With this feature, InnoDB creates indexes by sort, so page fill… post – if you are badly missing some features in MySQL, InnoDB, InnoDB-plugin, XtraDB, XtraBackup – you know whom ask for!
Post: Announcing Percona XtraDB Storage Engine: a Drop-in Replacement for Standard InnoDB
… storage engine, “Percona XtraDB“, which is based on the InnoDB storage engine. It’s 100% backwards-compatible with standard InnoDB, so you can… is forked from InnoDB-plugin-1.0.2. Percona XtraDB is released under GPL v2, as is InnoDB-plugin base source code. Percona XtraDB is released… will also be using Percona XtraDB for its upcoming 5.1 builds. XtraDB is fully compatible with existing InnoDB tables and we are…
Post: XtraDB benchmarks - 1.5X gain in IO-bound load
….30 with standard InnoDB, MySQL 5.1.30 with InnoDB-plugin-1.0.2 and MySQL 5.1.30 with XtraDB (all plugins statically compiled… you see XtraDB is somewhat 1.5x better than InnoDB in standard 5.1.30 and even more than InnoDB-plugin-1.0.2 And there is CPU utilization for all tested engines: As you see XtraDB also utilizes…
Post: XtraDB: The Top 10 enhancements
… (innodb_log_file_size), which is worse for performance. Â In a simple test, XtraDB recovered ten times faster (see docs). InnoDB Plugin Features – XtraDB is derived from the InnoDB plugin, which has fast index creation…
Post: My "hot" list for next InnoDB features
Many InnoDB scalability problems seem fixed in InnoDB-plugin-1.0.3 and I expect InnoDB-plugin will run fine on 16-24 cores boxes… are our current plans about XtraDB with recent InnoDB-pluging release, as performance improvements in plugin may make XtraDB out of game – so I consider list above as roadmap for XtraDB…
Post: Blob Storage in Innodb
… formats (used in before Innodb plugin and named “Antelope” in Innodb Plugin and XtraDB) Innodb would try to fit the whole row onto Innodb page. At least… and the fix comes with Innodb Plugin in “Barracuda” format and ROW_FORMAT=DYNAMIC. In this format Innodb stores either whole blob on…

