This past week was marked by a series of personal findings related to the use of Global Transaction IDs (GTIDs) on Galera-based clusters such as Percona XtraDB Cluster (PXC). The main one being the fact that transactions touching MyISAM tables (and FLUSH PRIVILEGES!) issued on a giving node of the cluster are recorded on a GTID set [&]

The post How to setup a PXC cluster with GTIDs (and have async slaves replicating from it!) appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/02/20/how-to-setup-a-pxc-cluster-with-gtids-and-have-async-slaves-replicating-from-it/

In a previous post, titled Multi-threaded replication with MySQL 5.6: Use GTIDs, I explained that using GTID replication is almost a requirement when using MySQL 5.6 MTS. Lets see now how to perform the day-to-day operations when MTS and GTIDs are both enabled. (Ill also be presenting a related webinar next week titled Multi-threaded Replication [&]

The post More on MySQL 5.6 multi-threaded replication and GTIDs (and Feb. 25 webinar) appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/02/19/more-on-mysql-5-6-multi-threaded-replication-and-gtids-and-feb-25-webinar/

Percona has submitted seven talks for the next OpenStack Summit in Vancouver this May. And as with all OpenStack Summit events, the community decides the content. Voting ends February 23, and if you arent already an OpenStack Foundation member (required to vote), you can join now for free here. Perconas Vancouver OpenStack Summit proposals Perconas [&]

The post Percona submits 7 talks for Vancouver OpenStack Summit (voting ends Feb. 23) appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/02/18/percona-submits-7-talks-for-vancouver-openstack-summit-voting-ends-feb-23/

Percona is glad to announce the release of Percona XtraBackup 2.2.9 on February 17, 2015. Downloads are available from our download site or Percona Software Repositories. Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. Offered [&]

The post Percona XtraBackup 2.2.9 is now available appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/02/17/percona-xtrabackup-2-2-9-now-available/

MySQL meets NoSQL with JSON UDF I recently got back from FOSDEM, in Brussels, Belgium. While I was there I got to see a great talk by Sveta Smirnova, about her MySQL 5.7 Labs release JSON UDF functions. It is important to note that while the UDF come in a 5.7 release it is absolutely [&]

The post Indexing JSON documents for efficient MySQL queries over JSON data appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/02/17/indexing-json-documents-for-efficient-mysql-queries-over-json-data/

Say you have a cluster with 3 nodes using Percona XtraDB Cluster (PXC) 5.6 and one asynchronous replica connected to node1. If asynchronous replication is using GTIDs, moving the replica so that it is connected to node2 is trivial, right? Actually replication can easily break for reasons that may not be obvious at first sight. [&]

The post Percona XtraDB Cluster 5.6: a tale of 2 GTIDs appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/02/13/percona-xtradb-cluster-5-6-a-tale-of-2-mysql-gtids/

Global Transaction IDs (GTIDs) are one of my favorite features of MySQL 5.6. The main limitation is that you must stop all the servers at the same time to allow GTID-replication. Not everyone can afford to take a downtime so this requirement has been a showstopper for many people. Starting with Percona Server 5.6.22-72.0 enabling [&]

The post Online GTID rollout now available in Percona Server 5.6 appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/02/10/online-gtid-rollout-now-available-percona-server-5-6/

Percona is glad to announce the release of Percona Server 5.6.22-72.0 on February 6, 2015. Download the latest version from the Percona web site or from the Percona Software Repositories. Based on MySQL 5.6.22, including all the bug fixes in it, Percona Server 5.6.22-72.0 is the current GA release in the Percona Server 5.6 series. Percona Server is open-source [&]

The post Percona Server 5.6.22-72.0 is now available appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/02/06/percona-server-5-6-22-72-0-now-available/

Being a QA Engineer, how would you feel if you had access to a framework which can generate 80+ crashes  a mix of hitting developer introduced assertions (situations that should not happen), and serious unforeseen binary crashes  for the worlds most popular open source database software  each and ever hour? What if you could [&]

The post The future of MySQL quality assurance: Introducing pquery appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/02/04/future-mysql-quality-assurance-introducing-pquery/

Its hard to believe that the Percona Live MySQL Conference and Expo is just over two months away (April 13-16 in Santa Clara, California). So if youve been thinking about submitting a proposal for the popular Lightning Talks and/or Birds of a Feather sessions, its time to get moving because the deadline to do so [&]

The post Percona Live 2015 Lightning Talks, BoF submission deadline Feb. 13! And introducing MySQL 1013 program appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/02/03/percona-live-2015-lightning-talks-bof-submission-deadline-feb-13-introducing-mysql-101-program/

Im happy to announce Go packages for MySQL. Particularly exciting is a new query fingerprint function which is very fast and efficient, but Ill talk about that later. First, go-mysql is currently three simple Go packages for parsing and aggregating MySQL slow logs. If youve been following Percona development, youve no doubt heard of Percona Cloud Tools (PCT), a [&]

The post Faster fingerprints and Go packages for MySQL appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/02/02/faster-fingerprints-and-go-packages-for-mysql/

This April 13-14 Percona is introducing an annual conference called OpenStack Live. I’ve seen a few questions about the new event so decided to help clarify what this show is about and who should attend. Unlike OpenStack Summits, held twice a year and dedicated to primarily to developers, OpenStack Live is an opportunity for OpenStack [&]

The post OpenStack Live 2015: FAQs on the who, what, where, when, why & how appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/01/30/openstack-live-2015-faqs-on-the-who-what-where-when-why-how/

Cloud security company Qualys announced Tuesday the issues prevalent in glibc since version 2.2 introduced in 2000-11-10 (the complete Qualys announcement may be viewed here). The vulnerability, CVE-2015-0235, has been dubbed GHOST. As the announcement from Qualys indicates, it is believed that MySQL and by extension Percona Server are not affected by this issue. Percona [&]

The post GHOST vulnerability (CVE-2015-0235) Percona response appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/01/29/ghost-vulnerability-cve-2015-0235-percona-response/

MySQL 5.6 allows you to execute replicated events in parallel as long as data is split across several databases. This feature is named Multi-Threaded Slave (MTS) and it is easy to enable by setting slave_parallel_workers to a > 1 value. However if you decide to use MTS without GTIDs, you may run into annoying issues. [&]

The post Multi-threaded replication with MySQL 5.6: Use GTIDs! appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/01/29/multi-threaded-replication-with-mysql-5-6-use-gtids/

About two years ago we held our first-ever Percona University event in Raleigh, N.C. It was a great success with high attendance and very positive feedback which led us to organize a number of similar educational events in different locations around the world. And next month well be back where it all started. On February [&]

The post Percona University: Back to school Feb. 12 in Raleigh, N.C. appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/01/27/percona-university-back-to-school-feb-12-in-raleigh-n-c/

Percona is pleased to announce the availability of Percona Toolkit 2.2.13.  Released January 26, 2015. Percona Toolkit is a collection of advanced command-line tools to perform a variety of MySQL server and system tasks that are too difficult or complex for DBAs to perform manually. Percona Toolkit, like all Percona software, is free and open source. This release is [&]

The post Percona Toolkit 2.2.13 is now available appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/01/26/percona-toolkit-2-2-13-now-available/

In this blog post, we will discuss MySQL performance on eXFlash DIMMs. Earlier we measured the IO performance of these storage devices with sysbench fileio. Environment The benchmarking environment was the same as the one we did sysbench fileio in. CPU: 2x Intel Xeon E5-2690 (hyper threading enabled) FusionIO driver version: 3.2.6 build 1212 Operating [&]

The post MySQL benchmarks on eXFlash DIMMs appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/01/26/mysql-benchmarks-exflash-dimms/

For months when speaking with customers I have been positioning Percona Cloud Tools (PCT) as a valuable tool for the DBA/Developer/SysAdmin but only recently have I truly been able to harness the data and make a technical recommendation to a customer that I feel would have been very difficult to accomplish otherwise. Let me provide [&]

The post Using Percona Cloud Tools to solve real-world MySQL problems appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/01/23/using-percona-cloud-tools-to-solve-real-world-mysql-problems/

Mydumper is known as the faster (much faster) mysqldump alternative. So, if you take a logical backup you will choose Mydumper instead of mysqldump. But what about the restore? Well, who needs to restore a logical backup? It takes ages! Even with Myloader. But this could change just a bit if we are able to take [&]

The post Importing big tables with large indexes with Myloader MySQL tool appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/01/21/importing-big-tables-large-indexes-myloader/

As a MySQL DBA/consultant, it is part of my job to decode the MySQL binary logs  and there are a number of reasons for doing that. In this post, Ill explain how you can get the important information about your write workload using MySQL row-based binary logs and a simple awk script. First, it [&]

The post Identifying useful info from MySQL row-based binary logs appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2015/01/20/identifying-useful-information-mysql-row-based-binary-logs/