AUTHOR: http://aws.typepad.com/aws/2007/04/mysql_interface.html LINK!

Recent AWS Customer Success Stories & Videos

More AWS Customer Success Stories...

« Links for Thursday, April 5, 2007 | Main | Fastest way to Get Started with EC2 - EC2UI »

TrackBack

TrackBack URL for this entry:
http://www.typepad.com/services/trackback/6a00d8341c534853ef00d83434620c53ef

Listed below are links to weblogs that reference MySQL Interface to Amazon S3:

» amazon web service s3 - now with mysql! from ecommerce-well.com
Amazons s3 web service may have a mysql interface! ... [Read More]

» MySQL Interface to Amazon S3 from Joseph Scott's Blog
Mark Atwood wrote a MySQL Interface to Amazon S3. Some basic functionality is there, but this is bleeding edge stuff. This is a really neat idea, abstract the S3 storage and provide methods that people already use to store their data. Someone needs t... [Read More]

» MySQL Interface to Amazon S3 from A Mountain Top
When you think about disruptive technologies, keep this one on your list to watch. [Read More]

Comments

Feed You can follow this conversation by subscribing to the comment feed for this post.

Doug Kaye

This is sick and twisted. I love it.

Michele

This looks like what everyone has been looking for! Got to give it a try...

patent

veryy veryy nice informations...thank you veryy much. mr suma

Alex Iskold

This is interesting! Does this include joins? Does a single table get scattered around or is there a way to cluster it on machines?

Alex

Jon

Question -

There has been alot of talk about how to solve the "persistant data" problem around an EC2 instance and MySQL data, this seems like it would be a good solution no? I think supporting this project and offering an EC2 image w/ this storage engine built in would be a great idea.

(Sorry, was going to post @ the Dev forums but was not sure where it would go)

GP

Thanks to Mark for doing this work. Is there any benchmark data available? Is there any indication that this storage engine will support basic RDBMS features like indexes, foreign key constraints, etc.? It seems like the latency you are introducing by storing all the data elsewhere would make this difficult to use for any real production application. A partial SQL interface to S3 buckets is certainly novel, but this doesn't seem to solve any of the problems people have voiced about a fast, persistent database available from EC2.

Jeffrey

Any chance that this will be backported to MySQL 5.0?

Computer Guru

It doesn't sound like a good idea.
Well it sounds like a good idea, but it'll never work. Latency (even with caching) will be the death of it.

Anyway, there's an easier method - just store an SQLite db on the remote server via a mounted SSH or WebDAV tunnel and connect to it normally via a symlink.

Jinesh

hi computer guru,

Very interesting. Somebody from the developer community is also experimenting with SQLLite DB:

http://blog.nanobeepers.com/2007/04/07/infinitely-scalable-framework-with-aws/

I am waiting for his first release too. Its getting more exciting now.

Jinesh

Mark Atwood

I'm the developer of this project.

It will be presented at the MySQL Expo in Santa Clara on April 25th. I'm also available at the monthly Seattle MySQL meetups to answer questions. I also welcome constructive questions and suggestions via email and on my LJ blog.

julio

I'm not sure there's a reason to go to S3 for the actual database. Where you need scalability is with the storage of stuff that you wouldn't put in the database anyway, just pointers to them. Does anybody actually store photos and stuff in the database? No, they store it in the file system. The database just points to it.

Dubai Web Design, Development

Excellent Interface. This is something new for a developer like me and especially for bingers.

The comments to this entry are closed.

Featured Events

The AWS Report


Brought to You By

Jeff Barr (@jeffbarr):



Jinesh Varia (@jinman):


Email Subscription

Enter your email address:

Delivered by FeedBurner

April 2014

Sun Mon Tue Wed Thu Fri Sat
    1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30