There are a lot of tools that generate test data.  Many of them have complex XML scripts or GUI interfaces that let you identify characteristics about the data. For testing query performance and many other applications, however, a simple quick and dirty data generator which can be constructed at the MySQL command line is useful. [&]

The post Generating test data from the mysql> prompt appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/09/10/generating-test-data-from-the-mysql-prompt/

A common migration path from standalone MySQL/Percona Server to a Percona XtraDB Cluster (PXC) environment involves some measure of time where one node in the new cluster has been configured as a slave of the production master that the cluster is slated to replace. In this way, the new cluster acts as a slave of [&]

The post Multi-Valued INSERTs, AUTO_INCREMENT & Percona XtraDB Cluster appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/09/09/multi-valued-inserts-auto_increment-and-percona-xtradb-cluster/

When a write query is sent to Percona XtraDB Cluster all the nodes store the writeset on a file called gcache. By default the name of that file is galera.cache and it is stored in the MySQL datadir. This is a very important file, and as usual with the most important variables in MySQL, the [&]

The post How to calculate the correct size of Percona XtraDB Clusters gcache appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/09/08/calculate-correct-size-percona-xtradb-clusters-gcache/

Percona is glad to announce the new release of Percona XtraDB Cluster 5.5 on September 5th 2014. Binaries are available from downloads area or from our software repositories. Based on Percona Server 5.5.39-36.0 including all the bug fixes in it, Galera Replicator 2.11, and on Codership wsrep API 25.11, Percona XtraDB Cluster 5.5.39-25.11 is now [&]

The post Percona XtraDB Cluster 5.5.39-25.11 is now available appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/09/05/percona-xtradb-cluster-5-5-39-25-11-now-available/

Thank you to all of you who attended my webinar last week about Global Transaction IDs (GTIDs), which were introduced in MySQL 5.6 to make the reconfiguration of replication straightforward. If you missed my webinar, you can still listen to the recording and download the sides (free). We had a lot of questions during the [&]

The post Using MySQL 5.6 Global Transaction IDs (GTIDs) in production: Q&A appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/09/05/using-mysql-5-6-global-transaction-ids-gtids-in-production-qa/

Here on the Percona Support team we often ask customers to retrieve disk stats to monitor disk IO and to measure block devices iops and latency. There are a number of tools available to monitor IO on Linux. iostat is one of the popular tools and Percona Toolkit, which is free, contains the pt-diskstats tool [&]

The post MySQL 101: Monitor Disk I/O with pt-diskstats appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/09/04/mysql-101-monitor-disk-io-with-pt-diskstats/

Join me online next week (September 10 at 10 a.m. PDT) for my live webinar on Migrating to Percona XtraDB Cluster.  This was a popular webinar that I gave a few years ago, so Im doing it again with updates for Percona XtraDB Cluster 5.6 (PXC) and all the latest in the Galera world. This webinar [&]

The post Migrating to Percona XtraDB Cluster 2014 edition: Sept. 10 MySQL webinar appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/09/03/migrating-to-percona-xtradb-cluster-2014-edition-sept-10-mysql-webinar/

Let me start by saying a big thank you to the staff at Oracle for deciding to open source reducer.sh. Its a tool I developed whilst I was working for them several years ago. Its sole purpose is to do one thing  but do it good: test-case simplification. So, lets say some customer just [&]

The post Reducer.sh  A powerful MySQL test-case simplification/reducer tool appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/09/03/reducer-sh-a-powerful-mysql-test-case-simplificationreducer-tool/

Given the recent excitement & interest around OpenStack I wanted to make sure I was ready to conduct appropriate evaluations of system performance.  I generally turn to sysbench since it comes with a variety of different tests (accessed via test= option interface), including: fileio  File I/O test cpu  CPU performance test memory  [&]

The post Using sysbench 0.5 for performing MySQL benchmarks appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/09/02/using-sysbench-0-5-benchmark-mysql-whats-changed-latest-release/

Percona is glad to announce the new release of Percona XtraDB Cluster 5.6 on September 1st 2014. Binaries are available from downloads area or from our software repositories. Based on Percona Server 5.6.20-68.0 including all the bug fixes in it, Galera Replicator 3.7, and on Codership wsrep API 25.7, Percona XtraDB Cluster 5.6.20-25.7 is now [&]

The post Percona XtraDB Cluster 5.6.20-25.7 is now available appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/09/01/percona-xtradb-cluster-5-6-20-25-7-now-available/

Galera replication for MySQL brings not only the new, great features to our ecosystem, but also introduces completely new maintenance techniques. Are you concerned about adding such new complexity to your MySQL environment? Perhaps that concern is unnecessarily. I am going to present here some simple tips that hopefully will let fresh Galera users prevent [&]

The post Galera replication – how to recover a PXC cluster appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/09/01/galera-replication-how-to-recover-a-pxc-cluster/

I was talking with a Percona Support customer earlier this week who was looking for Galera data on Percona Cloud Tools. (Percona Cloud Tools, now in free beta, is a hosted service providing access to query performance insights for all MySQL uses.) The customer mentioned they were already keeping track of some Galera stats on Cacti, and [&]

The post Galera data on Percona Cloud Tools (and other MySQL monitoring tools) appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/08/29/galera-data-on-percona-cloud-tools-and-other-mysql-monitoring-tools/

I was talking with a Percona Support customer earlier this week who was looking for Galera data on Percona Cloud Tools. (Percona Cloud Tools, now in free beta, is a hosted service providing access to query performance insights for all MySQL uses.) The customer mentioned they were already keeping track of some Galera stats on Cacti, and [&]

The post Galera data on Percona Cloud Tools (and other MySQL monitoring tools) appeared first on MySQL Performance Blog.

http://www.mysqlperformanceblog.com/2014/08/29/galera-data-on-percona-cloud-tools-and-other-mysql-monitoring-tools/

Percona is glad to announce the release of Percona Server 5.6.20-68.0 on August 29, 2014. Download the latest version from the Percona web site or from the Percona Software Repositories. Based on MySQL 5.6.20, including all the bug fixes in it, Percona Server 5.6.20-68.0 is the current GA release in the Percona Server 5.6 series. All of Perconas [&]

The post Percona Server 5.6.20-68.0 is now available appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/08/29/percona-server-5-6-20-68-0-now-available/

Percona is glad to announce the release of Percona Server 5.6.20-68.0 on August 29, 2014. Download the latest version from the Percona web site or from the Percona Software Repositories. Based on MySQL 5.6.20, including all the bug fixes in it, Percona Server 5.6.20-68.0 is the current GA release in the Percona Server 5.6 series. All of Perconas [&]

The post Percona Server 5.6.20-68.0 is now available appeared first on MySQL Performance Blog.

http://www.mysqlperformanceblog.com/2014/08/29/percona-server-5-6-20-68-0-now-available/

Percona is glad to announce the release of Percona Server 5.5.39-36.0 on August 29, 2014 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.39, including all the bug fixes in it, Percona Server 5.5.39-36.0 is now the current stable release in the 5.5 series. All of Perconas software is open-source and free, all the details of the release [&]

The post Percona Server 5.5.39-36.0 is now available appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/08/29/percona-server-5-5-39-36-0-now-available/

Percona is glad to announce the release of Percona Server 5.5.39-36.0 on August 29, 2014 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.39, including all the bug fixes in it, Percona Server 5.5.39-36.0 is now the current stable release in the 5.5 series. All of Perconas software is open-source and free, all the details of the release [&]

The post Percona Server 5.5.39-36.0 is now available appeared first on MySQL Performance Blog.

http://www.mysqlperformanceblog.com/2014/08/29/percona-server-5-5-39-36-0-now-available/

I just returned from a week in Cambridge, Massachusetts where I was attending the OpenStack Trove Day and the Trove mid-cycle meetup, both sponsored by the great folks at Tesora. I am relatively new to the OpenStack and Trove arenas so this was a fantastic opportunity for me to learn more about the communities, the [&]

The post OpenStack Trove Day 2014 Recap: MySQL and DBaaS appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/08/28/openstack-trove-day-2014-recap-mysql-and-dbaas/

Swanhart-Tools includes FlexCDC, a change data capture tool for MySQL. FlexCDC follows a servers binary log and usually writes changelogs that track the changes to tables in the database. I say usually because the latest version of Swanhart-Tools (only in github for now) supports FlexCDC plugins, which allow you to send the updates to a remote [&]

The post Trawling the binlog with FlexCDC and new FlexCDC plugins for MySQL appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/08/27/trawling-the-binlog-with-flexcdc-and-new-flexcdc-plugins-for-mysql/