MySQL database usage is popular in OpenStack. Core OpenStack services for Compute (Nova), Storage (Cinder), Neutron (Networking), Image (Glance) and Identity (Keystone) all use MySQL database. MySQL  as the world’s most popular database, runs inside OpenStack Virtual Machines and serves as database backend to OpenStack cloud based applications. The MySQL instances can be configured [&]

The post Backup and restore of MySQL to OpenStack Swift appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/11/01/backup-and-restore-of-mysql-to-openstack-swift/

If youre following this blog, its quite likely youre already aware of the Percona Live London 2014 conference coming up in just a few days. Just in case, though (you know, if youre still looking for an excuse to sign up), I wanted to put a spotlight on the tutorial to be delivered by my esteemed colleagues Fr'ed'eric [&]

The post Get a handle on your HA at Percona Live London 2014 appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/10/31/get-a-handle-on-your-ha-at-percona-live-london-2014/

With 1.28 billion active users, Facebook MySQL database engineers are active and extremely valuable contributors to the global MySQL community. So naturally they are also active participants of Percona Live MySQL conferences! And next week’s Percona Live London 2014 (Nov. 3-4) is no exception. (Register now and use the promotional code Facebook to save lb30!) [&]

The post Facebook MySQL database engineers ready for Percona Live London 2014 appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/10/30/facebook-mysql-database-engineers-ready-for-percona-live-london-2014/

I will present a benchmarking talk next week (Nov. 4) at the OpenStack Paris Summit with Jay Pipes from Mirantis. In order to be able to talk about benchmarking, we had to be able to set up and tear down OpenStack environments really quickly. For the benchmarks, we are using a deployment on AWS (ironically) [&]

The post MySQL and Openstack deep dive talk at OpenStack Paris Summit (and more!) appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/10/29/mysql-openstack-deep-dive-talk-openstack-paris-summit/

A deadlock in MySQL happens when two or more transactions mutually hold and request for locks, creating a cycle of dependencies. In a transaction system, deadlocks are a fact of life and not completely avoidable. InnoDB automatically detects transaction deadlocks, rollbacks a transaction immediately and returns an error. It uses a metric to pick the [&]

The post How to deal with MySQL deadlocks appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/10/28/how-to-deal-with-mysql-deadlocks/

You can already feel the cold of February coming slowly& you can also smell waffles, fries and see a large amount of beards walking around with laptops& you are right, FOSDEM is coming! And as every year, the MySQL Community will also be present! For the 4th year in a row, Ill perpetuate the organization [&]

The post MySQL & Friends Devroom FOSDEM 2015 appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/10/27/mysql-friends-devroom-fosdem-2015/

Yesterday (Oct. 22) I gave a presentation titled MySQL 5.6 Full Text Search Throwdown. If you missed it, you can still register to view the recording and my slides. Thanks to everyone who attended, and especially to folks who asked the great questions. I answered as many as we had time for during the session, [&]

The post MySQL 5.6 Full Text Search Throwdown: Webinar Q&A appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/10/23/mysql-5-6-full-text-search/

The countdown is on for Europes largest annual MySQL event, Percona Live London 2014. The two days of technical tutorials and sessions, November 3-4, will focus on the latest MySQL industry trends, news, best practices  and a look at whats on the near- and long-term horizon within the global MySQL ecosystem. Percona Live London [&]

The post MySQL community set to meet at Percona Live London 2014 appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/10/22/mysql-community-set-to-meet-at-percona-live-london-2014/

I reckon theres little sense in running 2 or more Percona XtraDB Cluster (PXC) nodes in a single physical server other than for educational and testing purposes  but doing so is still useful in those cases. The most popular way of achieving this seems to be with server virtualization, such as making use of Vagrant boxes. [&]

The post Percona XtraDB Cluster: How to run a 2-node cluster on a single server appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/10/21/percona-xtradb-cluster-how-to-run-a-2-node-cluster-on-a-single-server/

Autumn is a season of MySQL-related conferences and Im about to hit the road to speak and attend quite a  few of them. This week Ill participate in All Things Open, a local conference for me here in Raleigh, N.C. and therefore one I do not have to travel for. All Things Open explores open source, [&]

The post Autumn: A season of MySQL-related conferences. Heres my list appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/10/20/autumn-a-season-of-mysql-related-conferences-heres-my-list/

In many write-intensive workloads Innodb/XtraDB storage engines you may see hidden and dangerous debt being accumulated  unpurged transaction history which if not kept in check over time will cause serve performance regression or will take all free space and cause an outage. Lets talk about where it comes from and what can you do [&]

The post Innodb transaction history often hides dangerous debt appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/10/17/innodb-transaction-history-often-hides-dangerous-debt/

I recently had a client ask me how to use Percona Toolkit tools with an SSL connection to MySQL (MySQL-SSL). SSL connections arent widely used in MySQL due to most installations being within an internal network. Still, there are cases where you could be accessing MySQL over public internet or even over a public private [&]

The post Percona Toolkit for MySQL with MySQL-SSL Connections appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/10/16/percona-toolkit-for-mysql-with-mysql-ssl-connections/

Padding Oracle On Downgraded Legacy Encryption First off, the naming convention as of late for security issues has been terrible. The newest vulnerability (CVE­-2014-3566) is nicknamed POODLE, which at least is an acronym and as per the header above has some meaning. The summary of this issue is that it is much the same as the [&]

The post How to close POODLE SSLv3 security flaw (CVE-2014-3566) appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/10/15/how-to-close-poodle-sslv3-security-flaw-cve-2014-3566/

Founded in 1998, Rackspace has evolved over the years to address the way customers are using data – and more specifically, databases. The San Antonio-based company is fueling the adoption of cloud computing among organizations large and small. Today Rackspace is doubling down on open source database technologies. Why? Because thats where the industry is [&]

The post Rackspace doubling-down on OpenStack Trove and Percona Server appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/10/15/rackspace-doubling-down-on-openstack-trove-and-percona-server/

A few months back, Michael wrote about reconnecting orphaned *.ibd files using MySQL 5.6. I will show you the same procedure, this time for partitioned tables. An InnoDB partition is also a self-contained tablespace in itself so you can use the same method described in the previous post. To begin with, I have an example [&]

The post Recover orphaned InnoDB partition tablespaces in MySQL appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/10/14/recover-orphaned-innodb-partition-tablespaces-in-mysql/

Percona Toolkits  pt-table-checksum performs an online replication consistency check by executing checksum queries on the master, which produces different results on replicas that are inconsistent with the master  and the tool pt-table-sync synchronizes data efficiently between MySQL tables. The tools by default use the CRC32. Other good choices include MD5 and SHA1. If you have installed the FNV_64 user-defined function, pt-table-sync will [&]

The post How to avoid hash collisions when using MySQLs CRC32 function appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/10/13/how-to-avoid-hash-collisions-when-using-mysqls-crc32-function/

MySQL has information_schema.tables that contain information such as data_length or avg_row_length. Documentation on this table however is quite poor, making an assumption that those fields are self explanatory  they are not when it comes to tables that employ compression. And this is where inconsistency is born. Lets take a look at the same table [&]

The post MySQL compression: Compressed and Uncompressed data size appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/10/10/mysql-compression-compressed-and-uncompressed-data-size/

MySQL replication is a core process for maintaining multiple copies of data  and replication is a very important aspect in database administration. In order to synchronize data between master and slaves you need to make sure that data transfers smoothly, and to do so you need to act promptly regarding replication errors to continue [&]

The post MySQL Replication: Got fatal error 12362 causes and cures appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/10/08/mysql-replication-got-fatal-error-1236-causes-and-cures/

Ive recently worked with customers using replication rings with 4+ servers; several servers accepting writes. The idea behind this design is always the same: by having multiple servers, you get high availability and by having multiple writer nodes, you get write scalability. Alas, this is simply not true. Here is why. High Availability Having several [&]

The post MySQL ring replication: Why it is a bad option appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/10/07/mysql-ring-replication-why-it-is-a-bad-option/

Percona is glad to announce the release of Percona Server 5.6.21-69.0 on October 7, 2014. Download the latest version from the Percona web site or from the Percona Software Repositories. Based on MySQL 5.6.21, including all the bug fixes in it, Percona Server 5.6.21-69.0 is the current GA release in the Percona Server 5.6 series. Percona Server is [&]

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

http://www.percona.com/blog/2014/10/07/percona-server-5-6-21-69-0-now-available/