… on the database nodes. # yum -y install Percona-XtraDB-Cluster-server Percona-XtraDB-Cluster-client percona-xtrabackup Install haproxy and sysbench on… (0.00 sec) Populate the table with data for the benchmark. # sysbench –test=oltp –db-driver=mysql –mysql-engine-trx=yes…, c2 and c3 has 3. If we run the same benchmark, but against the 3306 backend, haproxy stats will show us…
Post: XtraDB storage engine release 1.0.2-3 (Spring edition) codename Sapporo
March 2, 2009 By 10 Comments
…-intentional workloads. See benchmark results. Scalability fix — replaced page_hash mutex to page_hash read-write lock. See benchmark results. Fix… builds for Ubuntu Percona XtraDB 1.0.2-3 (Sapporo) available in source and several binary packages. XtraDB is compatible with existing… Percona’s current tasks and further plans on the Percona XtraDB Launchpad project. You can also request features and report bugs…
Post: Percona testing: Quick test clusters with kewpie!
January 13, 2012 By Leave a Comment
… INFO basedir: /percona-xtradb-cluster 20120113-125552 INFO clientbindir: /percona-xtradb-cluster/client 20120113-125552 INFO testdir: /percona-xtradb-cluster/kewpie 20120113-125552… INFO basedir: /percona-xtradb-cluster 20120113-132229 INFO clientbindir: /percona-xtradb-cluster/client 20120113-132229 INFO testdir: /percona-xtradb-cluster/kewpie 20120113-132229…
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 11 Comments
… required to start work with Percona XtraDB Cluster Percona XtraDB Cluster is based on Percona Server with XtraDB and includes Write Set REPlication… XtraDB Cluster Feature 1: High Availability Percona XtraDB Cluster Feature 2: Multi-Master replication Create 3 nodes XtraDB Cluster in 3 minutes Benchmarking Galera…
Post: XtraDB: The Top 10 enhancements
August 13, 2009 By 5 Comments
… 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… application (this can be seen in any benchmark – such as this one). Â In XtraDB, adaptive checkpointing can smooth out the load…
Post: Announcement of Percona XtraDB Cluster (alpha release)
January 9, 2012 By 30 Comments
… required to start work with Percona XtraDB Cluster Percona XtraDB Cluster is based on Percona Server with XtraDB and includes Write Set REPlication…/downloads/Percona-XtraDB-Cluster/ Documentation Codership Wiki General Discussion group Launchpad project Bug reports Previous posts on this topic: Benchmarking Galera replication…
Post: Moving from MyISAM to Innodb or XtraDB. Basics
November 22, 2010 By 2 Comments
… topic. So what are the basics ? Regression Benchmarks – Make sure to run regression benchmarks in particular in terms of concurrent behavior. You… hard to guaranty you will never run into them. Performance Benchmarks – Innodb and MyISAM have different performance properties and you can…, you do not want to try to run Innodb or XtraDB with them. Second Innodb is tuned to be ACID by…
Post: Maximal write througput in MySQL
February 28, 2010 By 10 Comments
… amount transactions per second we can get using MySQL and XtraDB / InnoDB storage engine if we have high-end server. Good… would not take these as variable parameters and run simple benchmark. I took sysbench update_key scenario ( update indexed field on… and binary logs. And I used Percon-XtraDB-5.1.43-9.1 for benchmarks. All used partitions are formatted in XFS…
Post: 5.4 in-memory tpcc-like load
May 1, 2009 By 11 Comments
As continue to my benchmarks http://www.mysqlperformanceblog.com/2009/04/30/looking-on-54-io-bound-benchmarks/ on 5.4 I… stage. The graph is In default mode I would say XtraDB performs almost the same as 5.4, but dips are… for some period of time in all user processes. In XtraDB we have special mode adaptive_checkpoint, you see result in…
Post: Looking for InnoDB/XtraDB hacker
October 25, 2011 By 3 Comments
We are happy to see that Percona Server/XtraDB and XtraBackup are raising popularity and to keep excitement we … experienced software engineer and feel strong enough to hack InnoDB/XtraDB code we invite you to join our development team to… recent benchmarks Add more features for Percona XtraBackup And work on our new area of interest: clustering solution based on XtraDB + Galera…
