by Jay Janssen | May 14, 2013 | MySQL, Percona Software
I talk with lot of people who are really interested in Percona XtraDB Cluster (PXC) and mostly they are interested in PXC as a high-availability solution. But, what they tend not to think too much about is if moving from async to synchronous replication is right for...
by Tim.Callaghan | May 13, 2013 | MySQL
At tomorrow’s Effective MySQL Meetup, I’ll be presenting “Fractal Tree Indexes : Theory and Practice (MySQL and MongoDB).” The meetup is at 6:30pm Tuesday, May 14, 2013, and will be held at Alley NYC in New York City. I’ll give an overview on how Fractal...
by Peter Zaitsev | May 13, 2013 | MySQL, Webinars
This Wednesday, May 15 at 10 a.m. Pacific, I’ll be leading a Webinar titled, “Using MySQL 5.6 Performance Schema to Troubleshoot Typical Workload Bottlenecks.” In this Webinar I will offer an overview of Performance Schema, focusing on new features...
by Vadim Tkachenko | May 10, 2013 | MySQL
I was reviewing the Percona Live sponsors list the other day and pondering the potential success stories associated with this product or that one…. and as I was preparing to put more thought on the topic, a PlanetMySQL post caught my eye. It was penned by Mike...
by Miguel Angel Nieto | May 9, 2013 | Insight for DBAs, MySQL, Percona Software
Percona XtraBackup 2.0.7 has been published with support for GTID based replication. As promised, here is the step-by-step guide on how to create a new GTID based slave (or repair a broken one) using XtraBackup. The process is pretty straightforward. 1- Take a backup...
by Alexey Stroganov | May 8, 2013 | Benchmarks, MySQL
Around month ago Facebook has announced the Linkbench benchmark that models the social graph OLTP workload. Sources, along with a very nice description of how to setup and run this benchmark, can be found here. We decided to run this benchmark for MySQL Server 5.5.30,...
by Hrvoje Matijakovic | May 7, 2013 | MySQL, Percona Software
Percona is glad to announce the release of Percona XtraBackup 2.1.0-rc1 on May 7, 2013. Downloads are available from our download site here. For this RC release, we will not be making APT and YUM repositories available, just base deb and RPM packages This is an...
by Vadim Tkachenko | May 7, 2013 | Benchmarks, MySQL
After compiling Percona Server with TokuDB, of course I wanted to compare InnoDB performance vs TokuDB. I have a particular workload I’m interested in testing – it is an insert-intensive workload (which is TokuDB’s strong suit) with some roll-up...
by Hrvoje Matijakovic | May 6, 2013 | MySQL
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...
by Daniel Nichter | May 6, 2013 | Percona Software
During the Percona Live MySQL Conference & Expo 2013 the week before last, we quietly released Percona Toolkit 2.2.2 with a few bug fixes: pt-archiver –bulk-insert may corrupt data pt-heartbeat –utc –check always returns 0 pt-query-digest 2.2...
by Jay Janssen | May 3, 2013 | Percona Software
Few people realize that Galera/Percona XtraDB (PXC) replication can be encrypted via SSL for secure transfer of your replicated data. Setting this up is actually quite easy to do and probably will look familiar to a lot of people. Setting up SSL and Galera Create and...
by Tokutek | May 2, 2013 | MySQL
Last week I had to present a tutorial at Percona Live 2013, a presentation at SkySQL’s MySQL & Cloud Database Solution Day and last but not least, a presentation on a Saturday morning at Linuxfest Northwest. It wasn’t easy, but giving the presentations after...
by Jay Janssen | May 2, 2013 | Insight for DBAs, Percona Live, Percona Software
Last week at Percona Live, I delivered a six-hour tutorial about Percona XtraDB Cluster (PXC) for MySQL. I actually had more material than I covered (by design), but one thing I regret we didn’t cover was Flow control. So, I thought I’d write a post...
by Jervin Real | May 1, 2013 | Insight for DBAs, MySQL, Percona Software
Galera/Percona XtraDB Cluster (PXC) for MySQL is a hot thing right now and some users jump right in without enough testing. Consequently, they’re more likely to either suffer failure or issues that prevent them from moving forward. If you are thinking of...
by Peter Zaitsev | Apr 30, 2013 | MySQL, Percona Events, Webinars
If you have not already done so, I encourage you to register for my “Best Practices for MySQL Scalability” Webinar which will take place on May 1st at 10 a.m. PST. This will be an overview presentation, led by me and providing a high-level look at the...
by Tokutek | Apr 29, 2013 | MySQL
With this version, the source code is now freely available under the GPL License v2. For more details, see our blog here. Open source pioneer Mozilla has been using TokuDB to manage its MySQL-driven Datazilla Data cluster, an open-source system for managing and...
by Terry Erisman | Apr 29, 2013 | MySQL, Percona Events, Percona Live
The Percona Live MySQL Conference & Expo 2013 was April 22-25 in Santa Clara, California. This was Percona’s second year organizing the conference and we were very pleased with the event and the feedback (check the #perconalive hashtag for a sampling of the...
by Leif.Walsh | Apr 26, 2013 | MySQL
Since we had the pleasure to announce that TokuDB is open source on Monday, it’s been a thrilling ride. With several members of the team out west all week, back on the east coast we’ve been seeing quite a lot of questions, suggestions, and exciting results. Here are...
by Alexey Kopytov | Apr 26, 2013 | Benchmarks, MySQL
Since my first post on MySQL transaction descriptors optimization introduced in Percona Server 5.5.30-30.2 and a followup by Dimitri Kravchuk, we have received a large number of questions on why the benchmark results in both posts look rather different. We were...
by Tokutek | Apr 25, 2013 | MySQL
Yesterday we posted the photos and lyrics. Now we’ve got the YouTube video (click here)! And for those who want some behind the scenes photos, see here and here. (courtesy of @seattlegaucho).
