June 19, 2013

Post: 10 years of MySQL User Conferences

… Innodb version with more features. Gearman and MemcacheD storage engine plugins are available for MySQL. Facebook mentions they have over 1… going concurrently with the conference and announced Percona XtraDB as improved and extended Innodb Plugin version, MySQL 5.1 is FA with…. Percona XtraDB becomes Percona Server and is now a full-scale MySQL alternative and not just replacement for the Innodb Plugin. MySQL…

Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue

… RPM so our dpkg and binary packages remain unchanged. Percona XtraDB Cluster was also affected by this bug and will also… used by the PAM Authentication Plugin couldn’t be loaded with Perl and Python clients when plugin-dir option was set in…

Post: Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo

….6” Jay Janssen, Consulting Lead, Percona Topic: “Migrating to Percona XtraDB Cluster” Mark Atwood, Vipul Sabhaya, and Jim Cooley, HP Topic…, VP Architecture, Monty Program Ab Topic: “Storage Engines and Other Plugins: What’s New?” The Percona Live MySQL Conference includes a…

Post: InnoDB, InnoDB-plugin vs XtraDB on fast storage

….316 NOTPM InnoDB-plugin-1.0.6 15299.333 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 CPU…) To summarize MySQL InnoDB/InnoDB-plugin/XtraDB is not fully able to utilize throughput of FusionIO. XtraDB is doing better job with internal…

Post: Announcing Percona XtraDB Storage Engine: a Drop-in Replacement for Standard InnoDB

… from InnoDB-plugin-1.0.2. Percona XtraDB is released under GPL v2, as is InnoDB-plugin base source code. Percona XtraDB is released…, percona xtradb is compiled in into MySQL-5.1.30 RPMS * as separated shared library, to use as drop-in plugin for existing MySQL-5.1.30 installation http://www.percona.com/mysql/5.1.30/binary/percona-xtradb-1…

Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server

… tasks there. The goal of benchmarks was investigation of InnoDB-plugin and XtraDB scalability in CPU-bound load. CPU specification: processor : 23…-5.1.30 with InnoDB plugin, Xtradb-1.0.2-1, and XtraDB-1.0.2-2 (rel2). XtraDB-rel2 has not been released… up to 16 connections, but after that InnoDB-plugin is dropping down. XtraDB and XtraDB-rel2 seem quite better, I guess this is…

Post: XtraDB benchmarks - 1.5X gain in IO-bound load

… 5.1.30 with InnoDB-plugin-1.0.2 and MySQL 5.1.30 with XtraDB (all plugins statically compiled in MySQL) For… 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

… are most applicable to all workloads first: CPU scalability fixes – XtraDB improves performance on systems with multi-cpus (see docs 1… docs). Better Diagnostics – The SHOW ENGINE INNODB STATUS command in XtraDB shows a lot more information than the standard InnoDB status… In a simple test, XtraDB recovered ten times faster (see docs). InnoDB Plugin Features – XtraDB is derived from the InnoDB plugin, which has fast…

Comment: MySQL 5.5-m2 scalability

… same XtraDB plugin as and for 5.1. 5.5 is based on InnoDB-plugin, the same for XtraDB. If you have evidence that XtraDB is slower, please give me link. All results I saw where XtraDB is not performing the same or better than InnoDB-plugin just have incorrect tuning for XtraDB.

Post: Migrating to XtraDB Cluster Webinar follow up questions

…-change. Q: Does replication of MyISAM form any bottlenecks in XtraDB Cluster? If so, how bad? I have not experimented with… about availability of Nagios or other monitoring plugins, and I misspoke: The Percona Monitoring Plugins have a check that enables you to… does not, however, AFAIK, exist any dedicated checks specifically for XtraDB Cluster nodes, or a check that will check cluster consistency…