We just shipped and installed the Kickfire appliance in the data center of our first web 2.0 customer this week. We’re very excited about this new customer. With already over a million active members, this company continues to grow in spite of a challenging economic environment because it has a clearly defined audience and a business model which adds value to its members while adding money to its coffers. Part of the value add to their member base comes from well-targeted discount and coupon offers. In order to achieve this, the company runs complex analytics to understand members’ behaviors and responses and uses this data to help its advertising customers better target their offers.

As with many web 2.0 companies, this customer has built its application on MySQL. MySQL has helped them scale their web application well but was presenting performance and scalability challenges for their analytics. With their fact table in the …

Laurel Ruma (@laurelatoreilly) just did a quick census of the number of O'Reilly employees on twitter. She came up with 74 twitter accounts out of about 300 employees worldwide, plus five people who were controlling departmental or project-based O'Reilly twitter accounts like the following:

Official O'Reilly account:
@oreillymedia: The top level O'Reilly Media site.


@oreilly_verlag: O'Reilly Germany

Number of O'Reilly products or divisions on Twitter: 8


@make: Make: Magazine and makezine blog

@craft: Craft: Magazine and craftzine blog
…

So it’s that time of year again when everyone puts out their predictions for the year ahead.  I think predictions are a bit of a waste of time because to be interesting predictions have to be big, but a year really isn’t all that long so actual changes over the course of 2009 are likely to be just small progressions.  So instead I have been thinking about the top issues that we face heading into 2009 and here is my Top 10 list for issues in Data Management.  In this post I avoid offering solutions to these issues, while I have several ideas on solutions these can be the subject of subsequent posts.

10 - Limits on Scalability

While scalability is on my list it is at number 10 because against popular belief, scalability is only an issue for a very small number of data based applications.  Almost all data based applications in use today can be scaled without major issue by increasing the underlying …

SmugMug wins Best Design at The Crunchies 2007 by Luca Filigheddu Photography

I loved the idea behind The Crunchies even before we won for Best Design last year so I’m glad to see their triumphant return. And I see that nominations are open for 2008!

It looks like we’re probably eligible for a number of categories, but even if you don’t think we’re worthy, please go nominate your favorite startups. It really means a lot to the teams that work on these companies. Nothing like a little validation for all of our hard work…

…

Three weeks ago, I started my sporadic series of blog posts where I share my experiences improving my online manners through social networking websites, many of which are powered by MySQL. My first target was the traveller site Dopplr, and the second one was Google’s picture sharing site Picasa Web.

This time, I’m taking a look at Facebook. As I said in the first (Dopplr related) blog post, I feel like a slow follower in the discipline of social networking on the web. And Facebook was a true case in point, where “everybody else” was there before me (my team, my boss, my aunt, my nephew, my goddaughter, countless colleagues; you get the picture).

Actually, …

MySQL powers many of the social networks of Web 2.0. While it’s great that we constitute one of the tools of Web 2.0, we should also ourselves utilise the tools Web 2.0 provides for social networking. Comparing myself to colleagues, I feel like a slow follower in this discipline. “Everybody else” is already on Twitter, has hundreds and hundreds of contacts on LinkedIn, Xing and Facebook, puts their pics on Picasa and Flickr, bookmarks their pages on del.icio.us, and has fancy blogs that are registered everywhere. Myself, I have been half-heartedly entering contacts into LinkedIn, I have mismanaged my …

The current US financial situation has claimed a victim in the Web 2.0 world — Uber. I’m not sure if this is the first significant name, but it will not be the last site running MySQL where investors will be quick to cut losses and move on.

Hello all -- I am giving a webinar tomorrow, hosted by Jimmy Guerrero titled "Grazr: Lessons Learned using MySQL and Memcached in Web 2.0 Applications", 10:00 AM PDT, 13:00 EDT

I'll be discussing the use of Memcached, MySQL, Replication, Sphinx, etc, all the fun lessons we've learned at Grazr over the past year and a half or so.

The link for the event can be found here:

http://www.mysql.com/news-and-events/web-seminars/

The dry run went great today! Hopefully the cat won't mess with my tongue and I'll be just as talkative tomorrow as I was today. Just have to sip up extra Yerba Mate beforehand!

I am a conference junkie. I love attending them, organizing them, speaking at them, planning to attend them, seeing my friends at conferences, making friends with the nice (but often stressed) people who run conferences and so on. I even like eating the (often bad) food - kvetching about it builds a sense of camaraderie with the other participants.

Given how much time and money I spend on conferences already, it might be hard for you to be able to get more money directly out of me. However, here is one small tip on a way that you might be able to do this.

When you send me email about upcoming events, send me links to useful feed as well. Many of you are technologists who run technology conferences for other technologists. For Zarquon’s sake, use the common pieces of technology that many of us use.

What would such feeds look like? Well, to answer my own rhetorical question …
…

Alex forwarded me a link to an awesome scaling presentation by Cuong Do from YouTube about their architecture for scaling. He describes problems with massive scale-out, moving static content serving from Apache to lighttpd, how they use Python (including ways they speed it up) for the main application, certain custom C extensions for encryption, and their long road to MySQL partitioning.

A very interesting part of the presentation is Cuong's discussion of their difficulties dealing with thumbnail images for the videos. Each video has 4 thumbnails attached to it. The went through a whole series of issues in trying to scale the thumbnail serving, including hitting the ext3 files per directory limit one fateful day...

The section on scaling MySQL is a must see for anyone working on a Web 2.0 platform that can possibly see an enormous increase …