?

Log in

No account? Create an account
entries friends calendar profile My Website Previous Previous Next Next
Mark Atwood
fallenpegasus
fallenpegasus
Mentioned on the AWS blog
I just got mentioned on the official AWS blog

Independent developer Mark Atwood has been working on a MySQL interface to Amazon S3. Released under the GNU Public License, the code is compatible with version 5.1 of MySQL. Once the interface has been installed and configured with your AWS developer credentials, you can now create tables using the AWSS3 storage engine like this:

CREATE TABLE atst (s3id VARCHAR(255) NOT NULL PRIMARY KEY, s3val BLOB)) ENGINE='AWSS3' connection='awss3 bucketname aws_id aws_secret'

This is a bleeding-edge, first-cut release and, as is the case with popular open source projects, will undoubtedly evolve and mature rapidly over the coming weeks and months.

Based on Mark's S3 journal entries, the basic functionality is now in place. Each database table row is stored in an S3 object. The object's S3 key corresponds to the table's primary key (which must be of type VARCHAR). Inserts, deletes, and selects are functional.

Tags: , , ,
Current Location: AlohaHaus, Capitol Hill, Seattle WA

5 comments or Leave a comment
Comments
docorion From: docorion Date: April 9th, 2007 05:22 pm (UTC) (Link)
Excellent!
mauser From: mauser Date: April 9th, 2007 07:55 pm (UTC) (Link)
Most of this is going right past me, Amazon in this case has nothing to do with the bookseller, I assume....

(My one Amazon.com thought was that it would be cool (from a marketing perspective anyway) to be able to upload the database from iTunes to your Amazon profile to fill out the albums you already own and thus get better results from their recommendation database).
fallenpegasus From: fallenpegasus Date: April 9th, 2007 11:27 pm (UTC) (Link)
It is, in fact, Amazon the bookseller.

Amazon, over the past ten years, has built a bunch of pretty cool tech that's useful for building big scalable growing websites, all for their own internal use. A while ago, they realized that they could take all this stuff, "turn it inside out" and lease access to it to other people who also want to build scalable growing websites.

One such is "S3", which stands for "Simple Storage Service". It provides an API that lets you write files into "buckets", and then read them back, or allow anyone with a web browser or http client library to read them back. It's got some basic search functions, and ways to make it convienient to "virtual host" the buckets, so the URLs look like they're from your own domain, but they are really coming from Amazon's datacenters.

There is no setup charge, the storage is rather cheap, 15c/month for storage and 20c/month for transfer, this is especially cheap compared to buying, setting up, and paying the colo rent on big RAID stacks. You can keep just a few dozen bytes in S3, or a thousand terabytes. No kidding, there are S3 customers reaching that size...
mauser From: mauser Date: April 10th, 2007 12:58 am (UTC) (Link)
Suddenly I'm imagining what 4-Chan could do with that.... :-)

I totally blew my one interview with Amazon because at the time, while I'd been DOING OOP, I wasn't familiar with the terminology related to C++. I'll never forget "Abstraction, Encapsulation, Inheritance and ...." Crap, I DID forget.
mauser From: mauser Date: April 10th, 2007 03:28 pm (UTC) (Link)
Oh yeah, Polymorphism.

(And it took me just about as long to remember last time....(
5 comments or Leave a comment