Percona is glad to announce the release of Percona Server 5.5.40-36.1 on October 7, 2014. Based on MySQL 5.5.40, including all the bug fixes in it, Percona Server 5.5.40-36.1 is now the current stable release in the 5.5 series. Percona Server is open-source and free. Details of the release can be found in the 5.5.34-36.1 [&]

The post Percona Server 5.5.40-36.1 is now available appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/10/07/percona-server-5-5-40-36-1-now-available/

Percona is glad to announce the release of Percona XtraBackup 2.2.5 on October 2, 2014. Downloads are available from our download site here and 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. [&]

The post Percona XtraBackup 2.2.5 now available (free MySQL hot backup software) appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/10/06/percona-xtrabackup-2-2-5-now-available/

HAProxy is frequently used as a load-balancer in front of a Galera cluster. While diagnosing an issue with HAProxy configuration, I realized that logging doesnt work out of the box on CentOS 6.5. Here is a simple recipe to fix the issue. If you look at the top of /etc/haproxy/haproxy.cfg, you will see something like: [&]

The post HAProxy: Give me some logs on CentOS 6.5! appeared first on Percona Performance Blog.

http://www.percona.com/blog/2014/10/03/haproxy-give-me-some-logs-on-centos-6-5/

Percona is pleased to announce the availability of Percona Toolkit 2.2.11.  Released on Sept. 25, 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 contains [&]

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

http://www.percona.com/blog/2014/09/30/percona-toolkit-2-2-11-for-mysql-is-now-available/

MySQL is the database of choice for most OpenStack components (Ceilometer is a notable exception). If you start with a small deployment, it will probably run like a charm. But as soon as the dataset grows, you will suddenly face several challenges. We will write a series of blog posts explaining the issues you may [&]

The post MySQL & OpenStack: How to overcome issues as your dataset grows appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/09/29/mysql-openstack-how-to-overcome-issues-as-your-dataset-grows/

The media train is in full steam today over the the CVE-2014-6271 programming flaw, better known as the Bash Bug or Shellshock  the original problem was disclosed on Wednesday via this post. Firstly this issue exploits bash environment variables in order to execute arbitrary commands; a simple check for this per the Red Hat [&]

The post Bash Bug giving you Shellshock? CVE-2014-6271 update appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/09/26/bash-bug-giving-you-shellshock-cve-2014-6271-update/

We are pleased to announce the third release in the 0.6 series of mydumper, a tool for performing logical MySQL backups. In this release, we focused on simplifying compiling the code and added new features for making logical backups. These new features include enhancements to AWS RDS support and extending TokuDB support. Due to recent changes (or [&]

The post Logical MySQL backup tool mydumper 0.6.2 now available appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/09/26/logical-mysql-backup-tool-mydumper-0-6-2-now-available/

Im excited to once again be heading to San Francisco next week for Oracle OpenWorld, and also very pleased to have a booth there this year along with some great speakers from Percona. The scope of Oracle OpenWorld 2014, which runs Sept. 28-Oct. 2, is enormous and there are several keynotes and sessions Im looking [&]

The post Looking forward to Oracle OpenWorld 2014; visit us at Booth 2413! appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/09/25/looking-forward-oracle-openworld-2014-visit-us-booth-2413/

Recently I encountered a specific situation in which a customer was forced to stay with the MyISAM engine due to a legacy application using tables with over 1000 columns. Unfortunately InnoDB has a limit at this point. I did not expect to hear this argument for MyISAM. It is usually about full text search or [&]

The post More then 1000 columns  get transactional with TokuDB appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/09/25/1000-columns-get-transactional-tokudb/

Percona Server and Percona XtraDB Cluster provide high-performance alternatives for MySQL users. We have also seen rapidly growing interest in these solutions in the OpenStack community where higher performance and high availability are crucial. Many OpenStack users are adopting these solutions but weve also seen demand from companies creating OpenStack distros. For example, Percona XtraDB [&]

The post Percona Server, OpenStack and the Tesora DBaaS Platform appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/09/24/percona-server-openstack-and-the-tesora-dbaas-platform/

This Wednesday Ill be discussing two common types of big data: machine-generated data and user-generated content. These types of big data are amenable to sharding, a commonly used technique for spreading data over more than one database server. Ill be discussing this in-depth during a live webinar at 10 a.m. Pacific time on Sept. 24. [&]

The post How to scale big data applications using MySQL sharding frameworks appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/09/23/please-join-upcoming-webinar-scale-big-data-applications-using-mysql-sharding-frameworks/

Interest in Percona XtraDB Cluster / Galera has been high ever since we introduced the product in 2012.  I typically have a conversation about Galera and Percona XtraDB Cluster (PXC) at least once a week with a consulting customer who wants to know if it will be a good fit for their application.  Last week [&]

The post Should you migrate to Percona XtraDB Cluster? appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/09/22/migrate-percona-xtradb-cluster-galera/

MySQL upgrades are necessary tasks and we field a variety of questions here at Percona Support regarding MySQL upgrade best practices. This post highlights recommended ways to upgrade MySQL in different scenarios. Why are MySQL upgrades needed? The reasons are many and include: Access to new features, performance benefits, bug fixes&. However, MySQL upgrades can [&]

The post MySQL upgrade best practices appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/09/19/mysql-upgrade-best-practices/

Over the past few months, Ive seen an increase in the following use case while working on performance and schema review engagements: I need to store exponentially increasing amounts of data and analyze all of it in real-time. This is also known simply as: We have big data. Typically, this data is used for user [&]

The post Managing big data? Say hello to HP Vertica appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/09/18/vertica-introduction/

I recently encountered a situation in which after running Percona Toolkits pt-table-checksum on a customer system, 95% of the table on the MySQL master was different on the MySQL slave. Although this table was not a critical part of the infrastructure, from time to time, writes to the table from the master would break replication. [&]

The post Syncing MySQL slave table with pt-online-schema-change appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/09/17/syncing-mysql-slave-table-with-pt-online-schema-change/

Percona Live London 2014 is fast approaching – November is just around the corner. This year’s conference, November 3-4, will be even bigger and better than last year thanks to the participation of leading MySQL experts the world over (including you!). The Percona Live London MySQL Conference is a great event for users of any [&]

The post Percona Live London: Top Ten reasons to attend Nov. 3-4 appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/09/16/percona-live-london-top-ten-reasons-attend-nov-3-4/

I am proud to announce OpenStack Live, a new annual conference that will run in parallel with the Percona Live MySQL Conference & Expo at the Santa Clara Convention Center in Silicon Valley. The inaugural event, OpenStack Live 2015, is April 13-14, 2015. We are lining up a strong Conference Committee and are now accepting [&]

The post OpenStack Live 2015: Call for speakers open through November 9 appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/09/12/openstack-live-2015-call-speakers-open-nov-9/

Percona is glad to announce the release of Percona XtraBackup 2.2.4 on September 12th 2014. Downloads are available from our download site here and Percona Software Repositories. Percona XtraBackup enables 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.4 is now available appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/09/12/percona-xtrabackup-2-2-4-now-available/

Ill have the pleasure to present, next Wednesday, September 17 at 10 a.m. PDT (1 p.m. EDT) a webinar titled OpenStack: A MySQL DBA Perspective. Everyone is invited. The webinar will be divided into two parts. The first part will cover how MySQL can be used by the OpenStack infrastructure including the expected load, high-availability [&]

The post OpenStack: A MySQL DBA Perspective  Sept. 17 webinar appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/09/11/openstack-a-mysql-dba-perspective-sept-17-webinar/

I was fortunate to attend an Ops discussion about databases at the OpenStack Summit Atlanta this past May as one of the panelists. The discussion was about deadlock issues OpenStack operators see with Percona XtraDB Cluster (of course this is applicable to any Galera-based solution). I asked to describe what they are seeing, and as [&]

The post OpenStack users shed light on Percona XtraDB Cluster deadlock issues appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/09/11/openstack-users-shed-light-on-percona-xtradb-cluster-deadlock-issues/