by Stephane Combaudon | Sep 29, 2014 | Insight for DBAs, MySQL
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...
by David Busby | Sep 26, 2014 | MySQL
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...
by Max Bubenick | Sep 26, 2014 | MySQL, Percona Software
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...
by Peter Zaitsev | Sep 25, 2014 | MySQL, Percona Events
I’m 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...
by Tim.Callaghan | Sep 25, 2014 | MySQL
The biggest innovation in TokuDB v7.5 is Read Free Replication (RFR). I blogged a few days ago posting a benchmark showing how much additional throughput can be achieved on a replication slave, while at the same time lowering the read IO operations to almost zero. The...
by Przemysław Malkowski | Sep 25, 2014 | Insight for DBAs, Insight for Developers, MySQL
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...
by Tushar Katarki | Sep 24, 2014 | Insight for DBAs, MySQL, Percona Software
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...
by Tim.Callaghan | Sep 23, 2014 | MySQL
New to TokuDB® v7.5 is a feature we’re calling “Read Free Replication” (RFR). RFR allows TokuDB replication slaves to process insert, update, and delete statements with almost no read IO. As a result, the slave can easily keep up with the master (no...
by Justin Swanhart | Sep 23, 2014 | MySQL, Webinars
This Wednesday I’ll 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. I’ll be...
by Tim.Callaghan | Sep 22, 2014 | MySQL
TokuMX 2.0 is coming at the end of this month, and it’s going to be the most innovative release of TokuMX since our first release last June. Version 2.0 represents the realization of many of our engineering aspirations from when we started the TokuMX project, and...
by Jay Janssen | Sep 22, 2014 | MySQL, Percona Services, Percona Software
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...
by Muhammad Irfan | Sep 19, 2014 | Insight for DBAs, MySQL
MySQL upgrades are necessary tasks and we field a variety of questions here at Percona Support regarding MySQL upgrade best practices. This post highlights the recommended ways to upgrade MySQL in different scenarios. Why are MySQL upgrades needed? The reasons are...
by Tim.Callaghan | Sep 18, 2014 | MySQL
Today we released TokuDB® v7.5, the latest version of Tokutek’s storage engine for MySQL and MariaDB. I’ll be publishing two blogs next week to go into more details about our new “Read Free Replication”, but here are high level descriptions of...
by Mike Benshoof | Sep 18, 2014 | Insight for DBAs, MySQL
Over the past few months, I’ve 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:...
by Jervin Real | Sep 17, 2014 | Insight for DBAs, MySQL, Percona Software
I recently encountered a situation in which after running Percona Toolkit’s 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...
by Peter Zaitsev | Sep 16, 2014 | MySQL, Percona Live
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...
by Terry Erisman | Sep 12, 2014 | Insight for DBAs, Insight for Developers, MySQL, Percona Events
I am proud to announce 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 tutorial and breakout session speaking proposals through...
by Hrvoje Matijakovic | Sep 12, 2014 | MySQL, Percona Events, Percona Software
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...
by Yves Trudeau | Sep 11, 2014 | Insight for DBAs, MySQL, Percona Software, Webinars
I’ll 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...
by Peter Boros | Sep 11, 2014 | Insight for DBAs, MySQL, Percona Services, Percona Software
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
