An idea for Amazon AWS S3 and MySQL cluster replication distribution

[fallenpegasus]

I've described this idea to a few people, but I figured I would post it here.

I've had an idea for using Amazon AWS S3 to distribute MySQL cluster replication data.

The existing architecture for MySQL clustering is as follows:

1. The master has N slaves
2. The master copies each binlog replication to each slave. If there are 7 slaves, then the master

Comments

[rberger]

Why not just use Amazon SQS instead? I believe it does all the things you suggest to use S3 for, but does it automatically

[fallenpegasus]

Because SQS does not absolutely guarantee ordering. SQS items must be idempotent. If a MySQL binlog chuck gets randomly reordered, you've just hosed your database.

[mauser]

Where can I get N slaves? Or X slaves, preferably... :-)