by Peter Boros | Dec 4, 2013 | Insight for DBAs, MySQL, Webinars
I’m looking forward to next week’s MySQL webinar with Robert Hodges, CEO of Continuent. We’ll be speaking on the topic “Multi-Data Center MySQL with Continuent Tungsten.” You’re not alone if you’ve been vexed when trying to...
by Hrvoje Matijakovic | Dec 3, 2013 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona XtraDB Cluster 5.5.34-25.9 on December 4, 2013. Binaries are available from the downloads area or from our software repositories. Based on Percona Server 5.5.34-32.0 including all the bug fixes in it, Galera...
by Stephane Combaudon | Dec 3, 2013 | Insight for DBAs, MySQL
INFORMATION_SCHEMA is usually the place to go when you want to get facts about a system (how many tables do we have? what are the 10 largest tables? What is data size and index size for table t?, etc). However it is also quite common that such queries are very slow...
by Tom Diederich | Dec 2, 2013 | MySQL, Percona Live
The MySQL community came together last month for two days of outstanding technical tutorials and sessions at Percona Live London. And now many of those MySQL presentations are available for free download. This year’s London conference saw a 20 percent spike in...
by Jay Janssen | Dec 2, 2013 | MySQL, Percona Software
I get a lot of questions about Percona XtraDB Cluster 5.6 (PXC 5.6), specifically about whether such and such MySQL 5.6 Community Edition feature is in PXC 5.6. The short answer is: yes, all features in community MySQL 5.6 are in Percona Server 5.6 and, in turn, are...
by Muhammad Irfan | Nov 28, 2013 | Insight for DBAs, MySQL, Percona Services
Editor’s Note: Follow up to this post here MySQL 5.7 Performance Tuning After Installation. We have always received quite a few questions here at Percona Support on how to avoid the dreaded “Too many connections” error, as well as what is the...
by Zardosht.Kasheff | Nov 27, 2013 | MySQL
This past Wednesday, I attended a talk at the Washington DC MongoDB User Group given by John Schulz, a chief architect at AOL. In the talk, TokuMX VS MongoDB Bake Off Based on a Primary AOL Use case, he describes his experiments comparing TokuMX with MongoDB for his...
by Paul Namuag | Nov 27, 2013 | MySQL, Percona Services, Percona Software
I recently conducted a test backup of my “master-slave” setup in my VirtualBox as I was migrating from Percona XtraBackup v2.2.0 rev. 4885. However, doing the backup on my slave, I encountered this problem: Shell [04] Compressing and streaming ./test/checksum.ibd [01]...
by Yves Trudeau | Nov 26, 2013 | Insight for DBAs, Webinars
Downtime caused by a disaster is probable in your application’s lifetime. While caused by a large-scale geographical disaster, cyber attack, spiked consumer demand, or a relatively less catastrophic event, downtime equates to lost business. Setting up...
by Hrvoje Matijakovic | Nov 25, 2013 | Percona Software
Percona is glad to announce the release of Percona XtraBackup 2.1.6 on November 25th, 2013. Downloads are available from our download site here and Percona Software Repositories. This release is the current GA (Generally Available) stable release in the 2.1 series....
by Jay Janssen | Nov 22, 2013 | MySQL
Now that Percona XtraDB Cluster 5.6 is out in beta, I wanted to start a series talking about new features in Galera 3 and PXC 5.6. On the surface, Galera 3 doesn’t reveal a lot of new features yet, but there has been a lot of refactoring of the system in...
by Mike Benshoof | Nov 21, 2013 | Insight for DBAs, MySQL, Percona Software
Recently, I helped a client that was having issues with deployments causing locking in their production databases. At a high level, the two key components used in the environment were: Capistrano (scripted deployments) [website] Liquibase (database version control)...
by Hrvoje Matijakovic | Nov 21, 2013 | MySQL, Percona Events
Percona is glad to announce the first Beta release of Percona XtraDB Cluster 5.6 on November 21st, 2013. Binaries are available from downloads area or from our software repositories. Based on Percona Server 5.6.14-62.0 including all the bug fixes in it, Galera...
by Yves Trudeau | Nov 20, 2013 | Insight for DBAs, MySQL
It is a rather frequent problem to have to manage Virtual IP addresses (VIPs) with a Percona XtraDB Cluster (PXC) or with MySQL master HA (MHA). In order to help solving these problems, I wrote a Pacemaker agent, mysql_monitor that is a simplified version of the...
by Dave Rosenlund | Nov 19, 2013 | MySQL
You love MongoDB for its ease of deployment – but are you worried about how your application will perform when it starts to scale? SPEAKER: Tim Callaghan, VP of Engineering at Tokutek DATE: Wednesday, November 20th TIME: 1pm ET Register Now! Join this...
by Rich.Prohaska | Nov 19, 2013 | MySQL
What does it mean if MySQL returns the ‘Incorrect key file for table’ error for one of my queries? The answer is complicated and depends on which storage engine is returning the error. We have debugged two cases which we describe here. File system out of...
by Ernie Souhrada | Nov 18, 2013 | Benchmarks, Insight for DBAs, MySQL, Security
This is part two on a two-part series on the performance implications of in-flight data encryption with MySQL. In the first part, I focused specifically on the impact of using MySQL’s built-in SSL support with some rather surprising results. Certainly it was...
by Terry Erisman | Nov 15, 2013 | MySQL, Percona Events, Percona Live
Thanks to everyone who participated in Percona Live London 2013. We had a great event with nearly 20% higher attendance versus 2012. This year’s conference featured participation by representatives from Oracle including a compelling keynote by Tomas Ulin. The...
by Ryan Lowe | Nov 13, 2013 | Insight for DBAs, MySQL, Webinars
Sphinx is a free, open-source search server that integrates nicely with MySQL. It provides a fast, scalable, and pluggable search framework. The Sphinx engine possesses a variety of tools enabling you to customize how searching/indexing interacts with or becomes a...
by Mike Benshoof | Nov 12, 2013 | MySQL, Webinars
Drupal is one of the most popular open source CMS applications available – and it runs primarily on a MySQL backend. Out of the box, the schema is well tuned and indexed. However, there are some ways to tweak the default installation to get more out of the...
