This plugin enables MySQL to connect with Amazon Web Services by utilizing a storage engine specifically designed for AWS S3.
Alternatively, you can copy the "src" directory to storage/ in the MySQL server source, rebuild MySQL, and things should compile. It's advisable to install the S3 command line tools to make things easier while using the storage engine. To access these tools, you must have Python installed. You'll also need an Amazon AWS account, and you must request that S3 be enabled for you. Once that's done, you must get your "AWS Access Key Identifiers," which will be used to create a bucket.
Assuming you have your AWS Access Key Identifiers, put them in your .bashrc file and run "s3mkbucket" to create a bucket. The name of the newly created bucket should look like a domain name since buckets are in a global namespace. If you own "example.com," you can choose to have your bucket named "s3.example.com."
At the mysql> prompt, you can create a table and name it anything you'd like. However, note that the fields must be named "s3id" and "s3val", and s3id must be your primary key. To make this work, run "engine='AWSS3'" and "connection='awss3 s3.example.com FV8CY5793BC7CY32YOSN W9oQxQNJizGgjxNc82giE9/ipefQW19tuO2xpC9G'". Afterward, you can run different operations to test it out such as "select" or "insert."
This update supports more flexible schema, CREATE SERVER, and SELECT without WHERE. Overall, the MySQL Storage Engine for AWS S3 project is a reliable plugin storage engine that is easy to install and use.
Version 0.06: N/A