Colin Charles Agenda

At the MySQL Conference, I had the chance to interview Rohit Nadhani, founder of Webyog, the folk that make SQLyog and MONyog. Watch the video, for more.

Generally based out of Bangalore (I visited them when I was last there), Webyog just started an office in Santa Clara, and are expanding. They boast 15,000 paid customers so far, with some big name customers: Google, Yahoo!, executive office to the US president, and more.

SQLyog is termed as an upgrade from phpMyAdmin. There is a GPL community edition, with some “power tools” that is part of the Enterprise Edition. It is very Win32 based, but easy enough to run on other OSes via WINE or some sort of virtualisation tool.

MONyog is an agentless monitoring tool. It competes directly with Enterprise Monitor from MySQL, and there is no Community edition.

All Webyog licenses are perpetual (not subscription), with updates for a year. There are also unlimited licenses (server/user).

The motto: Low priced software, but sell thousands of copies.

The MySQL DevZone has an interview from 2006, that Jay conducted with Rohit. Go forth and read it.

While at the MySQL Conference, I caught up with Barry Abrahamson, the systems wrangler/de-facto DBA behind Wordpress.com (and all other Automattic properties). Watch the video.

You probably already know that Wordpress itself is built on top of MySQL. And despite everything you might have heard about our (MySQL/Sun’s) new founders, Wordpress is MySQL today, and for the foreseeable future. Anyway, I digress.

Wordpress.com has about 70 million tables, and tens of thousands of blogs. Large amount of tables, serve for easy sharding – after all, its based on Wordpress MU, which creates a table for each blog (read does it scale?).

Wordpress.com has a few terabytes of data in MySQL, with over 350 instances. They’re all powered by Debian servers, with MySQL.com binaries.

Of interest to lots of folk, is Wordpress stats (you get them with your own install, thanks to the Stats plugin). There is about 150GB of data for stats, that enter MySQL every month, and the data is queried multiple times a second. Wordpress stats currently are based on a per day basis, but real soon now, you’ll see hourly stats. So you can even switch when your day ends, because chances are, you’re not based in GMT.

Wordpress has about 90%+ reads, so the single master multiple slaves replication methodology works well for them. They’re moving to solid state drives, which is giving them more capacity to their current SAS solutions, since its all many tables, MyISAM, and it fits their workload model really well. Moving to SSDs is interesting – if you weren’t at the MySQL Conference, you should definitely catch the video from Andreas von Bechtolsheim, titled The Solid State Storage Revolution. Andy is a co-founder of Sun Microsystems.

Off camera, Barry also told me that they ran HP hardware, and he gave me the tale of how PollDaddy got a new heart – i.e. they moved from .NET/SQLServer to PHP/MySQL.

So, here, I can’t wait for hourly stats to come to Wordpress. And I’m most interested in seeing what comes out from this (via Matt Mullenweg’s blog post):

There are some new developments in the WordPress world, namely that I think it would be possible to add support for databases other than MySQL without changing every $wpdb call or breaking any plugins or themes. It won’t be easy, but the coolest stuff seldom is.

I caught up with Marc Delisle (we have a relatively old interview with him on the MySQL DevZone) recently, and got him to give us an introduction to phpMyAdmin, the several books he’s written, and how the project gets new features from the Google Summer of Code. What’s really impressive? They continue winning awards (Marc won one from MySQL in 2009 as well!), and have a user base of nearly 18.5 million (this is downloads — not just users, considering how common it is in shared hosting environments). Watch the video for more.

I caught up with Zach Skyles Owens, a PHP Evangelist at Microsoft. If you missed the embed, watch the video. I have some sparse notes below.

I learned some new things:

• Microsoft spends time working with the PHP community
• They are porting applications to work with an SQL Server backend
• They are ensuring that the language should “just work”, with the IIS and SQL Server stack. This is quite different from the usual AMP (Apache = server, MySQL = database, PHP = language) stack that we’re quite accustomed to.
• There is a Microsoft Web Platform, and there’s a Web Application Gallery, that brings in dependencies that you need, to use popular open source software packages.
• Drupal for example, is a featured application, for the PHP on IIS stack. If the software allows, it brings in SQL Server Express Edition; otherwise, it even brings in MySQL!

I had the pleasure of having a quick video interview with Chuck Hagenbuch and Leigh Heyman, both from Blue State Digital, and people that helped run the my.barackobama.com campaign. They’re giving the closing keynote at the MySQL Conference & Expo 2009 alongside three engineers from Google, and its going to be great.

If you missed the embed, here’s the video. Don’t forget to see them, at their closing keynote titled Database We Can Believe In: Stories from the Front Lines (and Server Rooms) of Barack Obama’s Online Presidential Campaign.

Today I spoke with Farhan “Frank” Mashraqi, former Fotolog DBA, now working at a startup, NetEdge, working on social analytics. He’s talking about the two sessions he’s giving next week at the MySQL Conference & Expo 2009, as well as the benefits of being at the MySQL Conference & Expo.

He’s giving two talks:

1. Hadoop and MySQL: Friends with Benefits in where he will tell you about how you can combine data sets and queries, some of which run on Hadoop, and others which run on MySQL, but eventually probably end up in MySQL (he works on this cool stuff at NetEdge, the startup he’s currently attached to).
2. Advanced memcached use cases in where you get best practice information on leveraging memcache, a software package that all the big boys use.

Frank also says, “If you’re not coming to the MySQL Conference, you’re losing out”. He’s right. You should be there. Look at all the amazing sessions, all the amazing networking opportunities, and more? He clearly specifies that the tutorial selection this year is pretty incredible, so make sure you’re signed up for Monday! Plan your sessions ahead, otherwise you might miss out some of the important things.

The MySQL Conference & Expo 2009 runs from April 20-23, 2009, at the Santa Clara Convention Centre. Don’t hesitate to register as there are plenty of interesting sessions there, next week.

This is one of the better three and a half minute videos out there (like a lightning talk), by Richard St. John, at TED, titled The Secrets of success in 8 words, 3 minutes. Watch it. Its summed up as:

1. passion: do it for love not for money
2. work: its all hard work. nothing comes easily, but you have fun nonetheless
3. good: practice, practice, practice, and be damn good at it
4. focus: focus yourself on one thing
5. push: push yourself. physically, mentally, just push through shyness and self-doubt
6. serve: serve others something of value
7. ideas: listen, observe, be curious, ask questions, problem solve, make connections
8. persist: persistence is the number one reason for success

Thanks to @blogjunkie for pointing this out.

At BarCampKL, I conducted a quick interview with Gen Kanai, the Director of Business Development, at Mozilla in Asia. He has vast experience, that ranges from starting the Japan office, to marketing, to helping open the Beijing office, and this year, its all about South East Asia.

Mozilla wants to know if there is a need for Firefox in Bahasa Malaysia? I asked Gen how hard it was to translate Firefox – there are over 60 localisations, and unofficially, there are over 100.

Bahasa Malaysia is about 40% complete, and the website needs localisation as well. While the system itself is not as simple as Ubuntu’s translation system, you don’t need to be a programmer, just know how to use source code management tools. You can use a simple text editor like Notepad, and move all the way to using Pootle.

Do you want Firefox and other Mozilla tools translated into Bahasa Malaysia? How will it help you (or someone else)?