by Jay Janssen | Dec 5, 2014 | Benchmarks, MySQL, Percona Software
Introducing Consul I’m always interested in what Mitchell Hashimoto and Hashicorp are up to, I typically find their projects valuable. If you’ve heard of Vagrant, you know their work. I recently became interested in a newer project they have called...
by Peter Boros | Dec 4, 2014 | Insight for DBAs, MySQL, Webinars
Fact: MySQL is the most commonly used database in OpenStack deployments. Of course that includes a number of MySQL variants – standard MySQL by Oracle, MariaDB, Percona Server, MySQL Galera, Percona XtraDB Cluster, etc. However, there are many misconceptions and...
by Tom Diederich | Dec 4, 2014 | MySQL, Percona Events, Percona Live
You know you’ll be there so why not save some $$ by registering now for the Percona Live MySQL Conference & Expo 2015 (April 13-16 in Santa Clara, Calif.). Super Saver registration discounts are available through Dec. 14 at 11:30 p.m. PST. (That’s just 10...
by Jay Janssen | Dec 3, 2014 | MySQL, Percona Software
One new feature in Percona XtraDB Cluster (PXC) in recent releases was the inclusion of the ability for an existing cluster to auto-bootstrap after an all-node-down event. Suppose you lose power on all nodes simultaneously or something else similar happens to your...
by Andrew Moore | Dec 2, 2014 | Insight for DBAs, MySQL, Percona Services
This post is a follow-up to my November 19 webinar, “Tips from the Trenches: A Guide to Preventing Downtime for the Over-Extended DBA,” during which I described some of the most common reasons DBAs experience avoidable downtime. The session was aimed at...
by Stephane Combaudon | Dec 1, 2014 | Insight for DBAs, MySQL, Percona Software
By default in MySQL 5.6, each time MySQL is started (regular start or crash recovery), it iterates through all the binlog files when GTIDs are not enabled. This can take a very long time if you have a large number of binary log files. MySQL and Percona Server 5.6.21+...
by Stephane Combaudon | Nov 24, 2014 | Insight for DBAs, MySQL
People using OpenStack Trove instances can hit a common issue in the MySQL world: how to perform schema change operations while minimizing the impact on the database server? Let’s explore the options that can allow online schema changes. Summary With MySQL 5.5,...
by Jay Janssen | Nov 21, 2014 | Cloud, MySQL, Percona Software
I’m happy to announce that Google has added Click-to-deploy functionality for Percona XtraDB Cluster (PXC) on Google Cloud Compute nodes. This gives you the ability to rapidly spin up a cluster for experimentation, performance testing, or even production use on...
by Arunjith Aravindan | Nov 19, 2014 | Insight for DBAs, MySQL, Percona Software
You might have encountered situations where you had to kill some specific select queries that were running for long periods and choking the database. This post will go into more detail with an example of report query offloading. Report query (select) offloading to a...
by Stephane Combaudon | Nov 17, 2014 | Insight for DBAs, MySQL
Even if a Galera node looks like a regular MySQL server, the underlying replication mechanism is very different. This implies some changes in the way you have to configure the Galera nodes. Here are some of the most common misconceptions about Galera when using this...
by Matt Griffin | Nov 14, 2014 | Benchmarks, Insight for DBAs, Insight for Developers, MySQL, Percona Software
One of the big announcements at the Amazon Web Services re:Invent 2014 conference this week was the unveiling of Aurora. The result of years of internal work, Aurora, currently in preview, is a MySQL 5.6-compatible option that “combines the speed and availability of...
by Jay Janssen | Nov 14, 2014 | Insight for DBAs, MySQL, Percona Software
Thanks to all who attended my Nov. 12 webinar titled, “Percona XtraDB Cluster as a MySQL HA Solution for OpenStack.” I had several questions which I covered at the end and a few that I didn’t. You can view the entire webinar and download the slides...
by Aurimas Mikalauskas | Nov 14, 2014 | Insight for DBAs, MySQL
This blog post was inspired by my visit at the annual Zabbix Conference in Riga, Latvia this year, where I gave a couple of talks on MySQL and beyond. It was a two-day single-track event with some 200 participants, a number of interesting talks on Zabbix (and related...
by Terry Erisman | Nov 13, 2014 | Insight for DBAs, MySQL, Percona Events, Percona Live
The 2014 edition of Percona Live London brought together attendees from 30 countries to hear insightful talks from leaders in the MySQL community. The conference kicked off on Monday with a full day of tutorials followed by the very popular Community Dinner featuring...
by Terry Erisman | Nov 11, 2014 | Insight for DBAs, MySQL, Percona Events, Percona Live
The OpenStack Live conference in Silicon Valley (April 13-14, 2015) will emphasize the essential elements of making OpenStack perform better with emphasis on the critical role of MySQL and Trove. If you use OpenStack and have a story to share or a skill to teach, we...
by Matt Griffin | Nov 10, 2014 | Insight for DBAs, MySQL, Percona Events, Percona Live
November is a busy month of events for Percona. Conferences in Moscow, London, Paris, Las Vegas, Buenos Aires, and Montevideo mean our experts are racking up the frequent flyer miles meeting users of Percona software from around the world, sharing our insights on...
by Bill Karwin | Oct 23, 2014 | Insight for Developers, MySQL, Webinars
Yesterday (Oct. 22) I gave a presentation titled “MySQL 5.6 Full Text Search Throwdown.” If you missed it, you can still register to view the recording and my slides. Thanks to everyone who attended, and especially to folks who asked the great questions. I...
by Fernando Laudares Camargos | Oct 21, 2014 | MySQL, Percona Software
I reckon there’s little sense in running 2 or more Percona XtraDB Cluster (PXC) nodes in a single physical server other than for educational and testing purposes – but doing so is still useful in those cases. The most popular way of achieving this seems to...
by Tim.Callaghan | Oct 16, 2014 | MySQL
In a few weeks I’m presenting “Performance Benchmarking: Tips, Tricks, and Lessons Learned” at Percona Live London 2014 (November 3-4). I continue to learn lessons and improve my benchmarking capabilities, so the content is a full upgrade from my...
by David Busby | Oct 15, 2014 | MySQL, Security
Padding Oracle On Downgraded Legacy Encryption First off, the naming “convention” as of late for security issues has been terrible. The newest vulnerability (CVE-2014-3566) is nicknamed POODLE, which at least is an acronym and as per the header above has...
