September 17, 2014

MySQL and Hadoop integration

Dolphin and Elephant: an Introduction This post is intended for MySQL DBAs or Sysadmins who need to start using Apache Hadoop and want to integrate those 2 solutions. In this post I will cover some basic information about the Hadoop, focusing on Hive as well as MySQL and Hadoop/Hive integration. First of all, if you […]

Percona XtraBackup 2.0.7 for MySQL available for download

Percona is glad to announce the release of Percona XtraBackup 2.0.7 for MySQL on May 6, 2013. Downloads are available from our download site here and Percona Software Repositories. Percona XtraBackup is the world’s only open-source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. This release is the current GA (Generally Available) […]

Percona Live MySQL Conference and Expo 2013: It feels like 2007 again

I actually don’t remember exactly whether it was in 2006, 2007 or 2008 — but around that time the MySQL community had one of the greatest MySQL conferences put on by O’Reilly and MySQL. It was a good, stable, predictable time. Shortly thereafter, the MySQL world saw acquisitions, forks, times of uncertainly, more acquisitions, more forks, […]

MySQL Workshops: Chicago & London this April

Percona will be in Chicago and London the week of April 8th delivering two 2-day MySQL workshops. For our MPB readers, we are offering a 15% discount. Just use MPB15A when purchasing your tickets to one or both MySQL workshops. Scaling and Optimization for MySQL on Monday & Tuesday, April 8 & 9 This MySQL workshop […]

MySQL 5.6.10 Optimizer Limitations: Index Condition Pushdown

While preparing the webinar I will deliver this Friday, I ran into a quite interesting (although not very impacting) optimizer issue: a “SELECT *” taking half the time to execute than the same “SELECT one_indexed_column” query in MySQL 5.6.10. This turned into a really nice exercise for checking the performance and inner workings of one […]

Why do we care about MySQL Performance at High Concurrency?

In many MySQL Benchmarks we can see performance compared with rather high level of concurrency. In some cases reaching 4,000 or more concurrent threads which hammer databases as quickly as possible resulting in hundreds or even thousands concurrently active queries. The question is how common is it in production ? The typical metrics to use […]

New Keynote Speakers and Sponsors and Applications Open for DotOrg Pavilion for Percona Live MySQL Conference and Expo

I’m pleased to announce the first of the Percona Live MySQL Conference and Expo 2013 keynote speakers and new sponsors including Amazon Web Services, Google, Clustrix, Scalebase, PalominoDB, Database Trends & Applications, and Linux Journal. We are also now accepting applications for the DotOrg Pavilion. Also, nominations are now being accepted for the 2013 MySQL […]

DotOrg Pavilion and MySQL Community Awards at Percona Live MySQL Conference and Expo 2013

Percona Live MySQL Conference and Expo 2013 – the largest MySQL Conference event of the year is getting close and we’re now announcing two community activities which are going to happen at this event. Call of DotOrg Pavilion exhibitors is open – DotOrg pavilion is a free expo hall space for non commercial projects relevant […]

CVE-2012-4414 strikes back in MySQL 5.5.29 (and what we’re doing in Percona Server 5.5.29)

In preparing Percona Server 5.5.29 (not yet released, but soon), I filed MySQL bug 68045 (is marked private as it’s a security bug). This bug is in relation to the Oracle fix for CVE-2012-4414 and a problem I found with it. The MariaDB fix (which we incorporated into Percona Server 5.5.28-29.3) is not affected. When the […]

Thank You Percona Live London 2012 Attendees!

Percona Live London wrapped up last week to very positive reviews from attendees and sponsors like those from Johan De Meersman. Percona was pleased to provide an engaging event for MySQL community members that featured engaging tutorials, highly rated breakout sessions, a very well-attended Tuesday community networking reception sponsored by Clustrix, and keynotes from a […]