This plugin enables MySQL to connect with Amazon Web Services by utilizing a storage engine specifically designed for AWS S3.
The MySQL Storage Engine for AWS S3 is a plugin storage engine that enables MySQL to access Amazon Web Services Simple Storage Service (AWS S3) items and buckets. To instigate the plugin, you need to have a MySQL source tree and ensure that it's built. Once you have identified where the source tree and the target install tree are located, configure the storage engine plugins. This can be found in lib/mysql under the install tree or it could be /usr/lib/mysql or /usr/local/lib/mysql. Afterward, run "./config/bootstrap" "./configure --with-mysql=/path/to/mysql-source --libdir=/path/to/mysql-plugins" "make && make install."
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.
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.
What's New
Version 0.06: N/A