by Matt Yonkovit | Apr 6, 2015 | MySQL, Percona Services
Every day hundreds of millions of dollars are wasted by allowing improperly tuned or misconfigured systems, misunderstood infrastructure, and inefficient IT operations to live and thrive in data centers around the globe. There are both direct and indirect costs...
by Michael Coburn | Apr 3, 2015 | MySQL
On a recent engagement I worked with a customer who makes extensive use of UUID() values for their Primary Key and stores it as char(36), and their row count on this example table has grown to over 1 billion rows. The table is INSERT-only (no UPDATEs or DELETEs), and...
by Hrvoje Matijakovic | Mar 31, 2015 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona XtraBackup 2.2.10 on March 31, 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...
by Peter Zaitsev | Mar 27, 2015 | MySQL
TechCrunch reported yesterday that Apple has acquired FoundationDB. And while I didn’t see any mention if this news on the FoundationDB website, they do have an announcement saying: “We have made the decision to evolve our company mission and, as of today,...
by Matt Griffin | Mar 24, 2015 | MySQL, Percona Live, Percona Services, Percona Software
Percona Toolkit is one of our most mature open source applications. Derived from Maatkit and Aspersa, Percona Toolkit has evolved significantly over the years. The software now contains 32 tools, over 4,000 tests, and has been downloaded over 250,000 times. Anyone who...
by Stephane Combaudon | Mar 19, 2015 | MongoDB, MySQL, Webinars
MongoDB 3.0 was recently released. Instead of focusing on what’s new – that is so easy to find, let’s rather talk about something that has not changed a lot since the early MongoDB days. This topic is sharding and most specifically: how to choose a...
by George O. Lorch III | Mar 18, 2015 | Insight for DBAs, MySQL, Percona Live
So you want to contribute to OpenStack? I can help! For the last year or so I have been involved with OpenStack and more specifically the Trove (DBaaS) project as sort of an ambassador for Percona, contributing bits of knowledge, help and debugging wherever I could...
by Muhammad Irfan | Mar 16, 2015 | MySQL, Percona Services
One of our Percona Support customers recently reported that Percona XtraBackup failed with a page corruption error on an InnoDB table. The customer thought it was a problem or bug in the Percona XtraBackup tool. After investigation we found that an InnoDB page was...
by Stephane Combaudon | Mar 13, 2015 | Insight for DBAs, MySQL, Percona Software, Webinars
My webinar “Multi-threaded Replication in MySQL 5.6 and 5.7” on February 25 generated several excellent questions following the presentation (available an online migration to GTIDs and that’s why here.
by Mike Benshoof | Mar 13, 2015 | Insight for Developers, MySQL
Geographic information systems (GIS) are used by application developers to incorporate geographic information into their datasets to create apps with cool features such finding the address to the best steakhouse in town or the locations of local points of historical...
by Daniel Nichter | Mar 12, 2015 | MySQL, Percona Software
The MySQL Performance Schema exposes so much data that it’s not trivial to learn, configure, and use. With recently released Percona Agent 1.0.11 you can get query metrics – like min, max, and average query execution time – with a few clicks: Click...
by Justin Swanhart | Mar 10, 2015 | MySQL
by Robert Barabas | Mar 6, 2015 | MySQL
Have you ever had a case where you needed to find a process which sent a HUP/KILL/TERM or other signal to your database? Let me rephrase. Did you ever have to find which process messed up your night? 😉 If so, you might want to read on. I’m going to tell you how...
by David Busby | Mar 5, 2015 | MySQL, Security
The CVE-2015-0204 FREAK SSL vulnerability abuses intentionally weak “EXPORT” ciphers which could be used to perform a transparent Man In The Middle attack. (We seem to be continually bombarded with not only SSL vulnerabilities but the need to name...
by Peter Zaitsev | Mar 5, 2015 | MySQL, Percona Events, Percona Live
I am thrilled to announce that Apple co-founder and Silicon Valley icon and philanthropist Steve Wozniak will participate in a moderated Q&A on creativity and innovation April 14 during this year’s Percona Live MySQL Conference and Expo in Santa Clara, California....
by Nik Vyzas | Mar 3, 2015 | Cloud, MySQL, Percona Software
As the need for information grows so does the size of data we need to keep in our databases. SST is unavoidable for spinning up new nodes in a PXC cluster and when datasets reach the “terra-byte” range this becomes ever more cumbersome requiring many hours...
by Muhammad Irfan | Feb 27, 2015 | Insight for DBAs, MySQL, Percona Software
DBAs often encounter situations where they need to kill queries to ensure there are no long-running queries on a MySQL server that would impact performance. Long-running queries can be the result of many factors. Fortunately, Percona Server contains some handy tools...
by Fernando Laudares Camargos | Feb 26, 2015 | Insight for DBAs, MySQL
If you use Percona Server 5.5 and you have configured it to use multiple buffer pool instances than sooner or later you’ll see the following lines on the server’s error log and chances are you’ll be worried about them: Shell InnoDB: detected cycle in...
by Jon Tobin | Feb 25, 2015 | MySQL
In Mo’ Data, Mo’ Problems, we explored the paradox that “Big Data” projects pose to organizations and how Tokutek is taking an innovative approach to solving those problems. In this post, we’re going to talk about another hot topic in IT, “The Cloud,” and how...
by Alexander Rubin | Feb 25, 2015 | Insight for DBAs, MySQL
MySQL introduced the Event Scheduler in version 5.1.6. The Event Scheduler is a MySQL-level “cron job”, which will run events inside MySQL. Up until now, this was not a very popular feature, however, it has gotten more popular since the adoption of Amazon...
