by Justin Swanhart | Sep 10, 2014 | Benchmarks, Insight for DBAs, MySQL
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...
by Ernie Souhrada | Sep 9, 2014 | Insight for DBAs, MySQL, Percona Software
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...
by Miguel Angel Nieto | Sep 8, 2014 | Insight for DBAs, MySQL, Percona Services, Percona Software
When a write query is sent to
by Hrvoje Matijakovic | Sep 5, 2014 | MySQL, Percona Events, Percona Software
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...
by Stephane Combaudon | Sep 5, 2014 | MySQL, Percona Services, Webinars
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...
by Muhammad Irfan | Sep 4, 2014 | Insight for DBAs, MySQL, Percona Services, Percona Software
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...
by Jay Janssen | Sep 3, 2014 | Insight for DBAs, MySQL, Percona Services, Percona Software, Webinars
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 I’m doing it again with updates for Register here!
by Roel Van de Paar | Sep 3, 2014 | Insight for DBAs, MySQL
Let me start by saying a big “thank you” to the staff at Oracle for deciding to open source reducer.sh. It’s 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...
by Michael Coburn | Sep 2, 2014 | Benchmarks, Insight for DBAs, MySQL, Percona Services
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...
by Hrvoje Matijakovic | Sep 1, 2014 | MySQL, Percona Events, Percona Software
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,...
by Przemysław Malkowski | Sep 1, 2014 | Insight for DBAs, MySQL, Percona Software
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...
by Fernando Laudares Camargos | Aug 29, 2014 | MySQL, Percona Services, Percona Software
I was talking with a Percona Support customer earlier this week who was looking for Galera data on Percona Cloud Tools. (Percona Cloud Tools is a hosted service providing access to query performance insights for all MySQL uses.) The customer mentioned they were...
by Hrvoje Matijakovic | Aug 29, 2014 | MySQL, Percona Software
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...
by Hrvoje Matijakovic | Aug 29, 2014 | MySQL, Percona Events, Percona Software
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...
by George O. Lorch III | Aug 28, 2014 | Insight for DBAs, MySQL, Percona Services, Percona Software
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...
by Justin Swanhart | Aug 27, 2014 | MySQL
by Fernando Laudares Camargos | Aug 26, 2014 | Insight for DBAs, MySQL, Percona Services, Percona Software
The need to have multiple instances of MySQL (the well-known mysqld process) running in the same server concurrently in a transparent way, instead of having them executed in separate containers/virtual machines, is not very common. Yet from time to time the Percona...
by Tim Sharp | Aug 25, 2014 | Insight for DBAs, MySQL, Percona Software
In a previous post, my colleague mission statement declares, the Trove project seeks to provide a scalable and reliable cloud database service providing functionality for both relational and non-relational database engines. With the current release of Icehouse, the...
by Fernando Laudares Camargos | Aug 22, 2014 | Insight for DBAs, MySQL, Percona Services, Percona Software
In my last post, “
by Fernando Laudares Camargos | Aug 21, 2014 | Benchmarks, Insight for DBAs, MySQL, Percona Services
A recurring and very common customer issue seen here at the Percona Support team involves how to make the ibdata1 file “shrink” within MySQL. I can only imagine there’s a degree of regret by some of the InnoDB architects on their design decisions...
