Category Archives: MySQL

Series: CRM on S3 & EC2, Part2

So we’ve touched a bit on what to look for in your database. The comments made were by no means specific, and the requirements will vary from place to place. But the underlying principals are what are really important there. Now lets move on to something a bit more specific. Backup. There is an important [...]

Series: CRM on S3 & EC2, Part1

Danny de Wit wrote in with a request for collaboration on how to best use EC2 and S3 for his new Ruby On Rails CRM application. And I’m happy to oblige. At this point I dont know much about what he’s doing, so I hope to start rough and open a dialogue with him and [...]

Random Musing: Bluring the Line Between Storage and Database?

As food for thought… If you had a table `items` itemId char(40), itemName varchar(128), Another table `tags` tagId char(40), tagName char(40), And a third table `owners` ownerId char(40), ownerUsername char(40), ownerPassword varchar(128), It would theoretically be possible to have an S3 bucket ItemsToTags inside which you put empty objects named (ownerId)-(itemId)-(tagId). And a TagsToItems S3 [...]

Where should AmazonAWS go next?

We have SQS, we have S3, and we have EC2, so what next from the Amazon AWS team?. There is really only one piece of the puzzle missing… And its a piece that has a lot of people griping. I have a strong hunch that Amazon is working on the problem, because I have a [...]

Is compute as a service for me?

Note to Nick: I havent forgotten your request and I’ll have something on that soon, but when I started in I found that I had something else to say about compute-on-demand (or compute-as-a-service – terms which i use somewhat interchangably) So here it is. For all those people just jumping into a project or considering [...]

I’ve become a MySQL snob…

I find that, after keeping alive a database whose size I cant comment on specifically, on a budget that I cant comment on specifically (which would shock you if only you knew), I’ve become aloof to a great many people and their MySQL war stories… 300Mb, 1Gb, 100Gb, 1Tb, HAH! HAH I SAY! Here’s a [...]