Memcached is a very popular open source object caching server. It was developed to speed up livejournal.com by Danga Interactive.  We use memcached for a lot of our sites.  We use it for different purposes but one main purpose is to cache query results so we don’t have to keep hitting database.  As most [...] …

Computer certification tests are often dreaded by those of us who have to take them. After many years of taking certification tests on everything from TCP/IP networks, Redhat Linux, network switches to Paypal programming, I am now on the other side of the coin as the MySQL Certification Team.

Recently I spoke with someone who did not enjoy taking certification tests. He found the cost of exams, finding a test center, studying for the exams, creating time in a an already busy schedule for the test date, and traveling to the test center a challenge but not the big issue. What really bothered him was the clock, omnipresent on the screen, quickly subtracting time until he had to finish.

He said his eyes were always drawn to the counter despite his best efforts. Like the raven in the famous Poe poem, the clock seemed to both mock and infuriate him. And he asked me what I did about the clock when I was testing.

…

What a week!
It started with a gift for all employees. A book that Lenz Grimmer has produced with great professionalism.

It is not for the general public. I am showing it here to give would-be employees one more reason to join the company. (Yes. It's business as usual. We are still hiring!)
Then the unexpected but very exciting news arrived, and perhaps a part 2 of this book won't be necessary.
(Update. Marten pointed out that this is not necessarily true, and the second part of the book will only be more exciting. Maybe so. The second part may just need a different sub-title.)
As part of the interesting changes in MySQL, there has been some side effects …

I was surprised that Sun could go from idea to acquisition on MySQL in just five weeks. What turns out to be more surprising, however, is that Jonathan Schwartz, Sun's CEO, had been talking with Marten Mickos of MySQL for over five years on precisely that topic, as Jonathan reveals on his blog. The real question, then, is why did it take so long?

Jonathan doesn't say, but the answer is clear: Marten wanted to build an IPO-able, independent MySQL. He eventually sold because it made sense (and, I suspect, because the prospect of living in the glare of Wall Street's impatient eye was not looking as appealing as it once had, but that's just Matt Asay personal conjecture).

Jonathan's post is a fascinating read. Here's just one of the sections I found revealing, coming on the …

mysqlreport v3.4 is ready which primarily fixes a bug in v3.3 concerning infiles for relative reports.

Changes in v3.4 are:

• Fixed bug: –relative infiles wouldn’t work unless the SHOW STATUS values were prefixed with a line matching: /Variable_name[\s|]+Value/. Now mysqlreport looks for Aborted_clients which should always be present. (thanks Debbie)
• Fixed formatting problem: Created Temp Table Size was too small for >99M
• Removed redundant %Total: column label from Slow line
• Added more debug info

Giuseppe Maxia (stress on the “i”, MaxIa, not MAxia) is now the new Community Team Leader. On Friday, our Data Charmer from Sardinia in Italy agreed to assume the responsibility of leading our Community Team, as I’m busy with my new appointment to Ambassador to Sun.

This means that Giuseppe now has a team of three Community Managers for each time zone, Jay Pipes in North America (NAM), Lenz Grimmer in Europe (EMEA), and Colin Charles in Asia Pacific (APAC). For the time being, Giuseppe reports to me.

Jay Pipes is the Program Chair for the upcoming MySQL Conference & Expo in Santa Clara, the main MySQL community event of the year.

One issue remains. “Community Team Leader” seems like a boring title. What title should we pick for Giuseppe? Given Giuseppe’s character and name of his blog ( …

I’m excited and a little bit worried about the aquisition of MySQL AB.

Sun has lots of billions, has lots of big customers and a great interest in competing with Oracle. These issues could be the ones to think about a more brilliant future for mysql.

I see in future a new SAMP paradigm (Solaris-Apache-MySQL-PHP/Perl/Python).

But I’m also a little bit worried.

I was trying to explore alternatives for slave/master architectures and gave a try to federated tables. No this post is not about Sun buying mySql.

So I compiled a fresh 5.0.51 on two boxes. It’s quite easy to setup, all it takes is the main server and the sub servers to support federated engine.Only trick is to [...]

While browsing the many blog entries on blogs.sun.com about the MySQL Acquisition (thanks a lot for the very warm welcome!), I stumbled over this (Python-based) utility: SnapBack, a tool that uses ZFS snapshots to perform physical backups of MySQL databases on Solaris. Very cool! This is actually something I was wanting to add to the mylvmbackup script, too - I have to take a closer look at how this is done (I tried to install OpenSolaris on a VirtualBox instance, but it caused it to crash the emulator).