A MySQL Storage Engine for AWS Publisher's description
from Mark Atwood
A MySQL Storage Engine for AWS S3 is a plugin storage engine that allows MySQL to access Amazon Web Services.
A MySQL Storage Engine for AWS S3 project is a plugin storage engine that allows MySQL to access Amazon Web Services Simple Storage Service (AWS S3) buckets and items.
You need a MySQL source tree, and you need to have it built.
Figure out where the source tree is.
In my case it's /home/mark/mysql/mysql-5.1-arch
Figure out where the target install tree is.
In my case it's /home/mark/mysql/builds/example
Figure out where the MySQL build puts storage engine plugins.
It's probably in lib/mysql under the install tree
Or it's /usr/lib/mysql
Or it's /usr/local/lib/mysql
For me it's /home/mark/mysql/builds/example/lib/mysql
./configure --with-mysql=/path/to/mysql-source --libdir=/path/to/mysql-plugins
make && make install
You can optionally copy the "src" directory here into storage/ in the
MySQL server source, rebuild MySQL, and things should compile.
Next, you should probably install the S3 command line tools.
They depend on you having Python.
Get them at http://www.hanzoarchives.com/development-projects/s3-tools/
If you don't have one yet, you need an Amazon AWS account, and then
request that they enable S3. Go to http://amazonaws.com/ to do that.
You will need to get your "AWS Access Key Identifiers".
Assume they are
(I just made those up with a random number generator.)
Put this in your .bashrc file
export AWS_ACCESS_KEY_ID AWS_ACCESS_KEY_SECRET
This isnt used by the storage engine, but it makes using the s3 command
line tools easier.
Use s3mkbucket to create a bucket. Remember that buckets are in a
global namespace, and there are advantages to having them look lik a
domain name. I suggest you snap up "s3.example.com", where
"example.com" is your own domain name.
s3put -k solfege/Do -s "a deer, a female deer" s3.example.com
s3put -k solf
What's New in This Release:More flexible schema, CREATE SERVER, and SELECT without WHERE are supported.
System Requirements:No special requirements.
Program Release Status:
Program Install Support: Install and Uninstall