Business Intelligence Network business intelligence resources

Blog: Pete Loshin

Main

January 9, 2008

YouTube and MySQL

YouTube, it turns out, uses MySQL as its backend.

Paul Tuckfield, the YouTube DBA, speaks about using MySQL at YouTube.

Before I even finished listening to the whole presentation, I got several key points:

  • Paul Tuckfield started out at YouTube with a lot of database experience under his belt as an Oracle DBA--but no MySQL experience. Which tells me that switching from Oracle to MySQL, while retaining people, should not be an obstacle.
  • MySQL scales, nicely. YouTube has three DBAs. They served 100 million videos a day, back in mid-2006. Without DB2 or Oracle.
  • Scaling MySQL to YouTube-scale is non-trivial. Tuckfield talks about using master/slave architecture and doing clever things with replication, to make MySQL work for such a huge database. Which tells me that you're not going to scale anywhere unless you have people who are smart enough to make it work.

The talk, recorded last year at the 2007 MySQL Conference, is only about 40 minutes long, so it's the perfect length for listening during your commute--and Paul is an engaging and funny speaker!


November 13, 2007

Installing MySQL: A Tale of Two Platforms

Before I begin here, be warned: one of the links I'm pointing to here is NSFW. That means "NOT SAFE FOR WORK", and in this case it means that the page contains vulgar language and profantiy. If you're easily offended or are at work, you may want to go do something else now.

Here's the story:

On November 10, this article was posted: Installing MySQL on Mac OS X. A well-written, comprehensive, detailed and in-depth how-to article that anyone who wants to get MySQL going on OS X would be happy to stumble over.

The guy who wrote it, Dan Benjamin, seems a talented and very nice fellow, and he went to a great deal of trouble to put the article together.

I'm guessing that sometime shortly after that article got posted, Mark Pilgrim read it and decided that running MySQL on a Mac seemed like a lot work--much more than using it on Linux.

Then, Mark wrote his own "answer", contrasting, how-to Installing MySQL on Ubuntu (the NSFW way). This article is NSFW. But it's also hilarious as H-E-double-hockey-sticks, and it looks to be just as useful as the first article.

If you're worried about the foul language in the second article, I'll summarize: installing MySQL on OS X sounds like an incredibly complicated and scary adventure; installing it on an Ubuntu Linux box sounds like a walk in the park.

The funny thing is, we just got an iMac. And I just installed MySQL on an Ubuntu Linux system. I don't anticipate installing it on the iMac, so I'm enjoying this on multiple levels.

October 4, 2007

The Ultimate Guide to SQL Implementations

Ever wonder whether or not some feature you need/want in your chosen implementation of SQL can be ported to or implemented in some other vendor's SQL implementation?

Now, you can look it up here, at the Comparison of different SQL implementations page, the work of Troels Arvin, database administrator in the Danish National Board of Health.

Go check it out and you can figure out just how your SQL of choice stacks up against the SQL:2003 standard, Oracle, IBM DB2, Microsoft SQL Server, MySQL, and PostgreSQL.

January 31, 2007

MySQL AB to Go Public

Computer Business Review Online is reporting that open source vendor MySQL is getting ready to go public in MySQL prepares for IPO and reveals Oracle endorsement.

According to the article, MySQL CEO Marten Mickos told CBR Online that although MySQL still hasn't spent more than half of the VC money it's already raised, they may be ready to roll out an IPO by the end of this year.

Read the article, and, discuss.

November 10, 2005

Database Upgrade Time

All kinds of new database software is coming out lately. You've probably heard about the release (finally) of Microsoft's SQL 2005. From what I've read, it's only a couple of years late, and still missing some key features, such as the ability to do database mirroring for automatic backup, at least according to this Computerworld article. Even so, will MSSQL 2005 be eating Oracle's lunch by next year? There is plenty of competition, free and not free.

Continue reading "Database Upgrade Time" »