June 20, 2013

Post: Announcing Percona XtraDB Cluster 5.5.27-23.6

… from downloads area or from our software repositories. Features: Percona XtraDB Cluster supports tunable buffer size for fast index creation in… in the merge sort can now be adjusted for better performance. Percona XtraDB Cluster has implemented ability to have a MySQL Utility… which makes a proxy (ie HAProxy) capable of monitoring Percona XtraDB Cluster nodes properly. Bugs fixed: Increasing the number of slave…

Post: XtraDB storage engine release 1.0.2-2 (New Year edition)

… is no enough free buffers. It helps if you have performance drops when data does not fit in memory. innodb_extra… other mysqld or innodb hotbackup). See documentation for details. Percona XtraDB 1.0.2-2 available : in source code from Launchpad… get as bzr branch lp:percona-xtradb -r tag:release-1.0.2-2 percona-xtradb-1.0.2-2 as source…

Post: Quality Assurance: Percona Server Development Now Monitored by Automated Sysbench Performance Regression Checks!

… complex Optimizer or XtraDB code) may lead to interesting performance gains. Analysis of the same may lead to further performance gain opportunities. Further… another option. We are also planning to check Percona XtraDB Cluster in a 3 VM node setup for performance regressions. Stay Tuned!

Post: Comparing Percona XtraDB Cluster with Semi-Sync replication Cross-WAN

… right around 100ms. All environments used Percona Server or Percona XtraDB Cluster server 5.5.24.  Innodb durability was disabled for… enabled on the slave (slave was in the other colo). XtraDB Cluster 1-colo 3  nodes in one datacenter.  Writes were…_support_xa being disabled in the PXC environments Semi-sync performs dismally under concurrency.  Think about it, our single inserts took…

Post: XtraDB storage engine release 1.0.6-9

…_creation Added extended statistics to slow log Adjust defaults with performance intention Added parameter to control checkpoint age Added recovery statisticsÂ…-server-percona MySQL-client-percona The latest source code of XtraDB, including development branch you can find on LaunchPAD. Please report…

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

….g. SSD or enough Write-Buffered), 0 may show better performance. Changed parameter for control read ahead activity. Now it accepts… 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 Server with XtraDB Case Study, Behind the Scenes

… MySQL and InnoDB. The big win was the upgrade to XtraDB. The business continued to grow quickly, and months later under… you could far exceed that performance on a “real” server. This case illustrates why average-case performance isn’t a good metric… in the hospital isn’t important.” Good performance means avoiding outliers and variations. The query performance needs to be a) fast, and…

Post: Percona-XtraDB-9.1: released and new coming features

Recently Alexandr announced new Percona-XtraDB-9.1 release, and now it is good time to … shows, you may need 4GB+ log files to get more performance on fast storage systems SHOW TEMPORARY TABLES, patch from Venu… list of XtraDB engine features (what makes it different from InnoDB-plugin) on the state as it is right now: Performance improvements…

Post: Feature in details: Incremental state transfer after a node crash in Percona XtraDB Cluster

With our newest release of Percona XtraDB Cluster, I would like to highlight a very nice ability … additional fsync call for each transaction, and it is know performance killer. Instead, we store GTID in InnoDB system area, which…, we can access information about the last commited transaction. In XtraDB Cluster you can access this information by calling mysqld with…

Post: Migrating several single standalone MySQL server to one Percona XtraDB Cluster... MariaDB to the rescue !

… standard MySQL masters, and some just standalone) to a Percona XtraDB Cluster of 3 nodes. So the easiest way would be… the table in InnoDB configure and start the replication finally perform SST on the other nodes…. So in this case that…. When a sever (a node) is member of a Percona XtraDB Cluster is also standard slave (standard asynchronous replication of MySQL…