EC2 is nifty, but it doesn’t appear suitable for all needs, and that’s what this post is about.

For instance, a machine can just “disappear”. You can set things up to automatically start a new instance to replace it, but if you just committed a transaction it’s likely to be lost: MySQL replication is asynchronous, EBS which is slower if you commit your transactions on it, or EBS snapshots which are only periodic (you’d have to add foo on the application end). This adds complexity, and thus the question arises whether EC2 is the best solution for systems where this is a concern.

When pondering this, there are two important factors to consider: a database server needs cores, RAM and reasonably low-latency disk access, and application servers should be near their database server. This means you shouldn’t split app and db servers to different hosting/cloud providers.

We’d like to hear your thoughts on EC2 …

Mosso the Rackspace Cloud now has a Drizzle developer image much like the first Drizzle AMI on EC2.

The Mosso interface is definitely different, it’s a GUI, and I definitely prefer CLI, but it’s a simpler navigation for a new user. I suspect an API may be available.

I had an issue with the backup process, more the lack of feedback. The Knowledge Base didn’t help, so both calling and Live Chat directed me ultimately to the same person. I also found a bug in the backup process, that is being able to select an incomplete backup to try and launch a new server. I talked to Support about and apparently already known.

And in true open source form, the Drizzle version is actually one point higher then yesterday’s AWS image.

This is really cool. Rackspace is hiring people to work on Drizzle full-time for their cloud product, Mosso. Adrian Otto writes the Drizzle mailing list:

I was speaking with Eric Day at the developer conference, and I mentioned that Rackspace is wiling to employ full time developers for the specific purpose of furthering the Drizzle project’s mission. He suggested that I email you on this list becuase he expected there would be interest in this offer. If you work on the project now part time, and want to make it a full time job working exclusively on the Drizzle project, let me know. The Rackspcae Cloud believes …

Marco Tabini has a great post discussing the cost of the cloud, and the current state of affairs. He calls for a simpler cloud platform, not just in terms of cost, but ease of use and products and services that adapt to changes in the market. Though the $100/month Mosso offering is mentioned (this site is hosted on Mosso), I would like to point out the recent acquisitions by Rackspace/Mosso that make their cloud offerings even more compelling than AWS for me.

• Slicehost : Rackspace announced the acquisition in late 2008. This allows me to spin up virtual instances or Slicehost’s version of AMI’s called Slices (this was updated due to Ian’s comment below. You cannot migrate an AMI from EC2 to …

Thanks to Expandrive . You can now use Subversion (SVN) on websites hosted at Mosso . The idea of mounting a directory you’d normally ftp/sftp to, and then using SVN on it, at first seemed oddly implausible to me. But, I tried it recently, and got exactly the results I wanted. I even had the repository hosted at Unfuddle . I think this post is fairly obvious, but if you have any questions feel free to ask in the comments.

The team just finished our second successful MySQL Con. Many thanks to Marten & Zack and all the folks at O’Reilly that put on such a great conference.

This year definitely had a different feel, and of course that had a lot to do with Sun’s influence. It felt like it was almost a new event, a chapter 2 for MySQL, and its ecosystem of vendors and customers. There were more people - I don’t know exact numbers, but it felt appeared to be twice as packed. The exhibit hall was the same, but we took up a bit more space than last year and certainly there were much fancier booths - ours included! We even gave away multiple prizes this year - our fun 8-ball tshirts, and a couple remote control helicopters. Scott Baird and Mike Hogan were the lucky winners this year.

The one thing that hasn’t changed is our fit with the MySQL customers. This year we met several of our own customers and users face-to-face - including an …