Im happy to announce that Google has added Click-to-deploy functionality for Percona XtraDB Cluster (PXC) on Google Cloud Compute nodes. This gives you the ability to rapidly spin up a cluster for experimentation, performance testing, or even production use on Google Compute Engine virtual machines. What is Percona XtraDB Cluster? Percona XtraDB Cluster is a [&]

The post Google Compute Engine adds Percona XtraDB Cluster to click-to-deploy process appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/11/21/google-compute-engine-adds-percona-xtradb-cluster-to-click-to-deploy-process/

Performance Schema (P_S) has been available since MySQL 5.5, more than 4 years ago. It is still difficult to see production servers with P_S enabled, even with MySQL 5.6 where the feature is enabled by default. There have been several complaints like the overhead, that the fix is a work in progress, and the ease [&]

The post Sys Schema for MySQL 5.6 and MySQL 5.7 appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/11/20/sys-schema-mysql-5-6-5-7/

You might have encountered situations where you had to kill some specific select queries that were running for long periods and choking the database. This post will go into more detail with an example of report query offloading. Report query (select) offloading to a slave server is a common practice to reduce the workload of the [&]

The post How a set of queries can be killed in MySQL using Percona Toolkits pt-kill appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/11/19/how-a-set-of-queries-can-be-killed-in-mysql-using-pt-kill/

MySQL table alterations can interrupt production traffic causing bad customer experience or in worst cases, loss of revenue. Not all DBAs, developers, syadmins know MySQL well enough to avoid this pitfall. DBAs usually encounter these kinds of production interruptions when working with upgrade scripts that touch both application and database or if an inexperienced admin/dev [&]

The post Avoiding MySQL ALTER table downtime appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/11/18/avoiding-mysql-alter-table-downtime/

Starting with MySQL 5.6 there is an INNODB_METRICS table available in INFORMATION_SCHEMA which contains some additional information than provided in the SHOW GLOBAL STATUS output  yet might be more lightweight than PERFORMANCE_SCHEMA. Too bad INNODB_METRICS was designed during the Oracle-Sun split under MySQL leadership and so it covers only InnoDB counters. I think this [&]

The post MySQLs INNODB_METRICS table: How much is the overhead? appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/11/18/mysqls-innodb_metrics-table-how-much-is-the-overhead/

Percona is pleased to announce the availability of Percona Toolkit 2.2.12.  Released on November 14, 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.12 is now available appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/11/17/percona-toolkit-2-2-12-now-available/

Even if a Galera node looks like a regular MySQL server, the underlying replication mechanism is very different. This implies some changes in the way you have to configure the Galera nodes. Here are some of the most common misconceptions about Galera when using Percona XtraDB Cluster. Q: Why should I enable binary logging as [&]

The post Typical misconceptions on Galera Replication for MySQL appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/11/17/typical-misconceptions-on-galera-for-mysql/

One of the big announcements at the Amazon Web Services re:Invent 2014 conference this week was the unveiling of Aurora. The result of years of internal work, Aurora, currently in preview, is a MySQL 5.6-compatible option that “combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases” on [&]

The post RDS for Aurora unveiled at AWS re:Invent appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/11/14/rds-for-aurora-unveiled-aws-reinvent/

Thanks to all who attended my Nov. 12 webinar titled, Percona XtraDB Cluster as a MySQL HA Solution for OpenStack. I had several questions which I covered at the end and a few that I didnt. You can view the entire webinar and download the slides here. Q: Is the read,write speed reduced in Galera [&]

The post Q&A: Percona XtraDB Cluster as a MySQL HA solution for OpenStack appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/11/14/qa-percona-xtradb-cluster-as-a-mysql-ha-solution-for-openstack/

This blog post was inspired by my visit at the annual Zabbix Conference in Riga, Latvia this year, where I gave a couple of talks on MySQL and beyond. It was a two day single-track event with some 200 participants, a number of interesting talks on Zabbix (and related technologies) and really well-organized evening activities. [&]

The post Optimizing MySQL for Zabbix appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/11/14/optimizing-mysql-zabbix/

The 2014 edition of Percona Live London brought together attendees from 30 countries to hear insightful talks from leaders in the MySQL community. The conference kicked off on Monday with a full day of tutorials followed by the very popular Community Dinner featuring a double decker bus shuttle from the conference to the event. Tuesday [&]

The post Percona Live London 2014 Wrap Up appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/11/13/percona-live-london-2014-wrap-up/

Did your logging stop working after you set up logrotate? Then this post might be for you. Some time ago, Peter Boros wrote about Rotating MySQL Slow Logs safely, explaining the steps of a best practice log rotate/archive. This post will add more info about the topic. When running logrotate for MySQL (after proper setting [&]

The post Log rotate and the (deleted) MySQL log file mystery appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/11/12/log-rotate-and-the-deleted-mysql-log-file-mystery/

The Percona Live MySQL Conference in Silicon Valley (April 13-16, 2015) features a full day of tutorial sessions and three full days with keynote talks and breakout sessions from leading MySQL experts from around the world. Birds of a Feather sessions, two networking receptions, and a community dinner all offer great opportunities to network with [&]

The post Percona Live MySQL Conference Call for Proposals closes Nov. 16 appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/11/11/percona-live-mysql-conference-call-for-proposals-closes-november-16/

The OpenStack Live conference in Silicon Valley (April 13-14, 2015) will emphasize the essential elements of making OpenStack perform better with emphasis on the critical role of MySQL and Trove. If you use OpenStack and have a story to share or a skill to teach, we encourage you to submit a speaking proposal for a [&]

The post OpenStack Live Call for Proposals closes November 16 appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/11/11/openstack-live-call-for-proposals-closes-november-16th/

I visited MongoDB Day in London on November 6. Here are a few observations: App-Developer Centric. It is interesting to see how much MongoDB is about developers; the ops side is something which is a necessary evil developers have to deal with. The ops topics covered in principle that there are no topics about choices [&]

The post Impressions from MongoDB Day London 2014 appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/11/10/impressions-from-mongodb-day-london-2014/

November is a busy month of events for Percona. Conferences in Moscow, London, Paris, Las Vegas, Buenos Aires, and Montevideo mean our experts are racking up the frequent flyer miles meeting users of Percona software from around the world, sharing our insights on MySQL performance and operations, and learning how others are growing and scaling [&]

The post Percona at AWS re:Invent and events around the world appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/11/10/percona-at-aws-reinvent-and-events-around-the-world/

MySQL is the most popular and widely used open source database on the planet. OpenStack is fast evolving as the defacto open source cloud platform. OpenStack services such as Nova (Compute), Cinder (Storage), Neutron (Networking), to name just a few, all use MySQL as default datastore. OpenStack is a cloud platform and therefore needs to [&]

The post OpenStack MySQL HA Solution = Percona XtraDB Cluster: Webinar appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/11/06/openstack-mysql-ha-solution-percona-xtradb-cluster/

Percona Toolkits pt-table-checksum is a great tool to find data inconsistencies between a MySQL master and its replicas. However it is sometimes not enough to know that there are inconsistencies and let pt-table-sync fix the issue: you may want to know which exact rows are different to identify the statements that created the inconsistency. This [&]

The post Data inconsistencies on MySQL replicas: Beyond pt-table-checksum appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/11/04/data-inconsistencies-on-mysql-replicas-beyond-pt-table-checksum/

Percona is glad to announce the release of Percona XtraBackup 2.2.6 on November 3, 2014. Downloads are available from our download site here and Percona Software Repositories. Were also happy to announce that Ubuntu 14.10 and CentOS 7 users can download, install, and upgrade Percona XtraBackup 2.2.6 from Perconas software repositories. Percona XtraBackup enables MySQL [&]

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

http://www.percona.com/blog/2014/11/03/percona-xtrabackup-2-2-6-is-now-available/

Percona is glad to announce the release of Percona Server 5.6.21-70.0 on October 30, 2014. Download the latest version from the Percona web site or from the Percona Software Repositories. We’re also happy to announce that Ubuntu 14.10 and CentOS 7 users can download, install, and upgrade Percona Server 5.6 from Percona’s software repositories. Based on MySQL 5.6.21, [&]

The post Percona Server 5.6.21-70.0 is now available appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/11/03/percona-server-5-6-21-70-0-now-available/