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 Stephane Combaudon | Apr 1, 2015 | MySQL
Recently Todd Farmer shared an interesting story about the mysql command line prompt in MySQL 5.7: how it was changed to provide more context and why the change was finally reverted. This made me think that after using the command line client for MongoDB for awhile, I...
by Tom Diederich | Mar 27, 2015 | MySQL, Percona Live
Here’s your chance to get on stage with Woz! Sort of. 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 the Percona Live MySQL Conference and Expo in...
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 Tom Diederich | Mar 25, 2015 | MySQL, Percona Live
Founded in 2004 to help people find great local businesses, Yelp has some 135 million monthly unique visitors. With those traffic volumes Yelp’s 300+ engineers are constantly working to keep things moving smoothly – and when you move that fast you learn many...
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 Roel Van de Paar | Mar 17, 2015 | Insight for DBAs, Insight for Developers, MySQL, Percona Services
MySQL QA Episode #1: Bash/GNU Tools & Linux Upskill & Scripting Fun This episode consists of 13 parts, and an introduction. See videos below In HD quality (set your player to 720p!) Introduction Part 1: echo, ls, cp, rm, vi, cat, df, du, tee, cd, clear, uname,...
by Roel Van de Paar | Mar 17, 2015 | Insight for DBAs, Insight for Developers, MySQL, Percona Services
Welcome to the MySQL QA Training Series! If you have not read our introductory blog post on pquery yet, I’d recommend reading that one first to get a bit of background. The community is enthuastic about pquery, and today I am happy to announce a full training...
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 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 Arunjith Aravindan | Mar 9, 2015 | MySQL, Percona Software
MySQL Replication is very simple to set up. In this post I’ll discuss its importance and five handy tools for monitoring and managing MySQL replication. What is MySQL Replication? It’s the process of copying the (real-time events) data from one master...
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 Stephane Combaudon | Mar 2, 2015 | Insight for DBAs, MySQL, Percona Software
From time to time people wonder how to implement roles in MySQL. This can be useful for companies having to deal with many user accounts or for companies with tight security requirements (PCI or HIPAA for instance). Roles do not exist in regular MySQL but here is an...
