I was very pleased to see that the SSL-related MySQL Bug #62743 was just fixed.

Here is the bug for reference:

http://bugs.mysql.com/bug.php?id=62743

In essence, the –ssl-key value was not validated, thus anything could have been specified there.

Your connection would have still been SSL encrypted, which was good at least, but your SSL Key would not have made any difference.

This fix will be included in versions 5.1.66, 5.5.28, 5.6.7, 5.7.0.

For reference, here is the entry that will go into the changelogs:

“The argument to the –ssl-key option was not verified to exist and be
a valid key. The resulting connection used SSL, but the key was not
used.”

Percona XtraDB Cluster (PXC) and the technology it uses (Galera) is an exciting alternative to traditional MySQL replication.  For those who don’t know, it gives you:

• Fully Synchronous replication with a write latency increase equivalent to a ping RTT to the furthest node
• Automatic cluster synchronization, both incremental and full restores
• The ability to read and write on every node without needing to worry about replication delay

However, good engineers know there is always a trade-off.  If someone tries to sell you on a technology that sounds amazing without telling you the tradeoffs, be careful.

One of the tradeoffs in Galera is how multi-node writing is implemented.  This is highly …

About a week ago I was looking at MySQL 5.5.27, and noticed a curious thing. Despite the fact that the new MySQL release contained its usual share of bug fixes, not a single one of them was accompanied with a test case.

Now, let me tell you something about tests. For many years MySQL was using its own testing framework, called mysql-test. The first version was written as early as 1999. Over the years it has accumulated a lot of tests. Tests for new features and regression tests — those that guarantee that a bug, once fixed, will never ever show up again. We had pretty strict policies about it in MySQL AB (and, later, Sun Microsystems) — every new bug fix always had to come with a test case for the bug. And because these tests were always run on many platforms for every push (by the continuous integration tool called Pushbuild — developed in-house by …

This week we talk about sessions at MySQL Connect we think will be interesting to DBAs. Ear Candy is Python's Fabric library and command-line tool and At the Movies is Johan Andersson of Severalnines presenting Using MySQL as a NoSQL datastore - new featuers in MysQL Cluster 7.2 GA from the SkySQL solutions day back in April.

Events
FrOSCon will be held Saturday and Sunday, August 25th - 26th at the University of Applied Sciences Bonn-Rhein-Sieg in Germany. Registration is a small fee for personal attendees, only 5 euros. It is more for corporate attendees. There will be a MySQL and friends room this year, as in years past.

…

Based on my last post MySQL LDAP Authentication Plugin, I received feedback from MySql Joro Blog by Oracle.

They told me:

Insted of writing (and having to deply) your own client plugin you probably can reuse the cleartext client side plugin, specially because it’s available in a number of mysql clients already. Check sql-common/client.c on MySQL 5.5+ for details.

This is very useful because you only need to put the plugin in server side, and in the client side you only need to check if the clear password plugin is enabled.

Now, I present the updated code with the only server side plugin, and I reused the cleartext client side plugin from MySql, it’s more short and very focused in LDAP authentication:

/*
Author: Ignacio Ocampo …

I just posted this to the MySQL Internals mailing list:

Hi all,

Like many of you, I’m disappointed that the bzr trees for MySQL are out
of sync with the tarball source and binary releases from Oracle.

Since Oracle has been silent on this, and this is a recurring problem,
I’ve decided to attempt to help the situation.

I’ve created the following bzr trees:
lp:percona-server/upstream-5.0
lp:percona-server/upstream-5.1
lp:percona-server/upstream-5.5
…

I had a lot of questions on my MySQL Indexing: Best Practices Webinar (both recording and slides are available now) We had lots of questions. I did not have time to answer some and others are better answered in writing anyway.

Q: One developer on our team wants to replace longish (25-30) indexed varchars with an additional bigint column containing the crc64, and change the indexing to be on that column. That would clearly save indexing space. Is this a reasonable performance optimization. (Keep in mind that the prefix adaptive hashing would fail here, because the first 10 or so …

Installing Lighttpd With PHP5 (PHP-FPM) And MySQL Support On CentOS 6.3

Lighttpd is a secure, fast, standards-compliant web server designed for speed-critical environments. This tutorial shows how you can install Lighttpd on a Centos 6.3 server with PHP5 support (through PHP-FPM) and MySQL support. PHP-FPM (FastCGI Process Manager) is an alternative PHP FastCGI implementation with some additional features useful for sites of any size, especially busier sites. I use PHP-FPM in this tutorial instead of Lighttpd's spawn-fcgi.

I short while ago one of our customers (through SkySQL) notified us of an unexpected problem in MySQL 5.5.25 regarding Query cache on partitioned tables.

Looking at the bug report (opened in 2010) one can see that the bug was marked in March 2012 as 'solved'. What was not made clear was that the solution was to disable the query cache for all partitioned tables.

Reading the bug report comments, I get the impression that the main reason for removing the feature was that the developers looking at the issue didn't really understand how the query cache works in detail and it was just easier to remove the feature than fixing it. (The problem was well understood but not how to fix it).

I talked this over with Sanja Byelkin, …

Read the original article at 31 Essential Blogs for Startups & Scalability

So many blogs, so little time! Here’s our list of the best we’ve found. Currently our favorite reader is Pulse pictured left. Starting to play around with flipboard too.

Nuts & Bolts Technical

Slashdot
One of the original tech blogs, that still covers lots of breaking news, and difficult topics. Very technical, with probing commentary. Beware the actual comments though, as they’re often full of immature and childish rants.

Planet …