Last Thursday (September 17, 13:00 UTC), Lars Thalmann explained the Architecture of MySQL Backup. Lars is leading the MySQL Replication & Backup teams, and has given several MySQL University sessions before.

I was on sick leave last week and forgot to announce this session - sorry!  However, since the session was recorded (video & audio), you can listen to it anytime. Please find the recording and the presentation slides on this page.

MySQL University is a free educational online program for engineers/developers. MySQL University sessions are open to anyone, not just Sun employees. Sessions are recorded (slides and audio), so if you can't attend the live session you can look at the recording anytime after the session.

Here's the …

Last Thursday (September 17, 13:00 UTC), Lars Thalmann explained the Architecture of MySQL Backup. Lars is leading the MySQL Replication & Backup teams, and has given several MySQL University sessions before.

I was on sick leave last week and forgot to announce this session - sorry!  However, since the session was recorded (video & audio), you can listen to it anytime. Please find the recording and the presentation slides on this page.

MySQL University is a free educational online program for engineers/developers. MySQL University sessions are open to anyone, not just Sun employees. Sessions are recorded (slides and audio), so if you can't attend the live session you can look at the recording anytime after the session.

Here's the …

The query cache has had an interesting history with MySQL. I don't have much experience with it. I might want to use it in the future so I enabled it during a run of sysbench readonly on an 8-core server. The results are fascinating. Performance with the query cache enabled is bad for MySQL 5.0.44, good for MySQL 5.0.84 and then bad again for MySQL 5.1.38. By bad I mean that throughput does not increase with concurrency as it does when the query cache is disabled.

This lists the throughput in the number of transactions per second reported by sysbench readonly using an 8-core server. It was run for 1, 2, 4, 8, 16 and 32 concurrent sessions.

Throughput with query cache enabled:
            1     2     4     8    16    32
5.0.44    663   746   872   834   730   694
5.0.84    639  1033  1819  3216  2636  2466
5.1.38    662   725   818   782   731   699

Throughput with query cache disabled:
            1     2     4     8    16    32 …

Mike Hogan, CEO of ScaleDB spoke at the Boston MySQL User Group in September 2009:

ScaleDB is a storage engine for MySQL that delivers shared-disk clustering. It has been described as the Oracle RAC of MySQL. Using ScaleDB, you can scale your cluster by simply adding nodes, without partitioning your data. Each node has full read/write capability, eliminating the need for slaves, while delivering cluster-level load balancing. ScaleDB is looking for additional beta testers, there is a sign up at http://www.scaledb.com.

Slides are online (and downloadable) at http://www.slideshare.net/Sheeri/scale-db-preso-for-boston-my-sql-meetup-92009

Watch the video online at …

Interviewed at an industry gathering in Silicon Valley, Oracle CEO maintains that despite EU concerns, Oracle's database does not compete with MySQL.

The InnoDB plugin keeps on looking better.

Paul and I spent a few weeks working on bug 46459. After fixing it I found out that this was already fixed in the InnoDB plugin as part of the change to enable group commit and fix bug 13669. This change can make InnoDB much faster for workloads that do a lot of inserts into tables with an auto increment column when autocommit statements are used.

…

Oracle is keeping MySQL. Yahoo is selling Zimbra. Linus is feeling bloated. And more.

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
“Tracking the open source news wires, so you don’t have to.”

# Larry Ellison reportedly said Oracle has no intention of spinning off MySQL.

# Yahoo is trying to sell Zimbra, according to All Things D.

# Linus Torvalds said Linux is “bloated and huge”.

# GroundWork Open Source released GroundWork Monitor 6.0.

# Zend launched Simple API for Cloud Application …

I have somehow managed to weasel been selected to speak at a few of the upcoming conferences this October.  I will be presenting at the various conferences either on Performance tuning the MySQL server or on using EXPLAIN.  I know... I know - they must be crazy to have picked me, but I am not crazy enough to turn down the opportunity.

 I will be speaking at Codeworks -Miami (Sept 30 - Oct 1), the Zend PHP Conference (Oct 19 - 22) and the Florida Linux Show (Oct 24) so if you are attending or just in the area - be sure to find me for a chat.  If you are at the Florida Linux Show I will be in the MySQL booth and should also have some goodies to hand out as well - thanks to …

I've managed to find a way to connect MySQL directly to Google Spreadsheets and although that its not yet perfect, it does show a lot of potential.
You will have a MySQL table directly fed into Google Spreadsheets. From there, you could do some charts, highlights some trends or simply share the data as is with our people in our out of your organization is a secure way.
The end result should look something like this:

What you will need:A Linux Server with Apache and MySQLA Google Apps Premier accountGoogle Secure Data Connector installed on your Linux server

SDCInstalling the SDC is a bit tricky but not too difficult and there is a lot of documentation as to how to do it. A lot of it is giving things the right permissions and configuring 2-3 XML files.
You can read more about how SDC works, but …

Image by Snooch2TheNooch via Flickr

I was speaking with Michael Stonebraker this morning.  I mentioned that lately many have been referencing comments he has made over the last couple of years.  And I also mentioned that many had interpreted them as he was implying the RDBMS is “doomed”.  Mike has been saying the same thing for years, but the current NoSQL movement seems to have picked up on this and highlighting one of the RDBMS's own pioneers is predicting its …