by Peter Zaitsev | Dec 31, 2012 | Insight for DBAs, Insight for Developers, MySQL
With Performance Schema improvements in MySQL 5.6 I think we’re in the good shape with insight on what is causing performance bottlenecks as well as where CPU resources are spent. (Performance Schema does not accounts CPU usage directly but it is something which...
by Miguel Angel Nieto | Dec 28, 2012 | MySQL
This is a recurrent question made by our MySQL Support customers: How can I best go about auditing login attempts in MySQL? Logging all the attempts or just the failed ones is a very important task on some scenarios. Unfortunately, there are not too many audit...
by Tokutek | Dec 27, 2012 | MySQL
Well, it’s that time of the year again for top ten lists. There have been many versions showing up on the web the last few days, including Time Magazine’s “Top 10 Everything of 2012” list, with 55 wide ranging lists! Last year we started using Google...
by Hrvoje Matijakovic | Dec 21, 2012 | Percona Software
Percona is glad to announce the latest stable release of Percona XtraBackup 1.6.7 on December 20th, 2012 (Downloads are available here). This release is purely composed of bug fixes to the previous stable release of Percona XtraBackup. New users should head for...
by Stephane Combaudon | Dec 21, 2012 | Insight for DBAs, MySQL
Even if you are using a GUI tool to connect to your MySQL servers, one day or another, you will have to deal with the command line. So it is nice to know a few tips that can really make your work easier. Note: The commands below are only available for Unix/Linux....
by Tokutek | Dec 20, 2012 | MySQL
Finally @marketyou_com has automatic master failover and slave promotion! We also run on SSD and we use MariaDB+TokuDB.
by Tokutek | Dec 20, 2012 | MySQL
So glad of adopting @tokutek for @marketyou_com. Reduced lag to 0 secs with it and SSD.
by Frederic Descamps | Dec 20, 2012 | MySQL, Percona Software
If you are using SElinux, you should know that it’s advised to disable it to avoid issue with PXC. Generally the communication between your nodes doesn’t work properly and a node having SElinux enabled won’t be able to join the cluster. So when a...
by Aurimas Mikalauskas | Dec 20, 2012 | Cloud, Insight for DBAs, MySQL
We are doing a migration from Amazon RDS to EC2 with a customer. This, unfortunately, involves some downtime – if you are an RDS user, you probably know you can’t replicate an RDS instance to an external server (or even EC2). While it is annoying, this...
by Fernando Ipar | Dec 19, 2012 | Insight for DBAs, MySQL
First, a thank you to everyone who attended the webinar Today, I appreciate your time and nice comments. As promised, here are answers to questions that couldn’t be answered during the talk: Q: How do you install the tools? The manual has full details,...
by Leif.Walsh | Dec 19, 2012 | MySQL
Every time I visit my family for the holidays, as the date approaches, I find myself filled with dread. It’s nothing sinister, my family’s great, and the season is nice. The reason is simple: I hate packing. In fact, I hate both kinds of packing: trip packing, and bit...
by Frederic Descamps | Dec 19, 2012 | MySQL, Percona Software
How easy is it to identify and debug Percona XtraDB Cluster replication problem ? If you are using PXC, you may have already seen in your datadirectory several log files starting with GRA_ Those files correspond to a replication failure. That means the slave thread...
by Peter Zaitsev | Dec 19, 2012 | MySQL
There have been several reports (1,2,3) describing Percona’s stance regarding the MariaDB Foundation that are not totally accurate so I though it would be worth it to describe where we stand on this and related matters. First, let me say the creation of...
by Frederic Descamps | Dec 18, 2012 | MySQL
Some weeks ago I had to migrate some independent MySQL servers (some standard MySQL masters, and some just standalone) to a Percona XtraDB Cluster of 3 nodes. So the easiest way would be to configure each node to become also an asynchronous slave of one of the...
by Peter Zaitsev | Dec 14, 2012 | MySQL
In the last poll we discovered some 90% of responders run MySQL on Linux which is not totally a surprise. Number of people asked me to do the followup pool to see what specific Linux distributions are most popular in MySQL space hence this is the poll for today....
by Ernie Souhrada | Dec 14, 2012 | Insight for DBAs, Insight for Developers, MySQL
Prior to version 5.0, MySQL could only use one index per table in a given query without any exceptions; folks that didn’t understand this limitation would often have tables with lots of single-column indexes on columns which commonly appeared in their WHERE...
by Terry Erisman | Dec 14, 2012 | MySQL, Percona Events
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...
by Tokutek | Dec 13, 2012 | MySQL
Tired of the same old holiday tunes year after year? Join us as we Rock around the Fractal Tree here at Tokutek. We’ve fiddled with the chorus; won’t you join us? Rockin’ around the Fractal Tree (sung to the tune of Rockin’ around the Christmas Tree)...
by Fernando Ipar | Dec 12, 2012 | MySQL, Percona Events
On December 19th at 1 PM Eastern / 10 AM Pacific, I will be giving a webinar entitled “10 Percona Toolkit Tools Every MySQL DBA Should Know About”. As a Consultant, I make heavy use of Percona Toolkit tools while solving customers’ problems, and I...
by Hrvoje Matijakovic | Dec 7, 2012 | MySQL
Percona is glad to announce the release of Percona Server 5.5.28-29.2 on December 7th, 2012 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.28, including all the bug fixes in it, Percona Server 5.5.28-29.2 is now the...
