Testing the Connections to S3
If you can't get the S3 storage engine to work, here are some steps to help verify where the problem could be.
S3 Connection Variables
In most cases the problem is to correctly set the S3 connection variables.
The variables are:
- s3_access_key: The AWS access key to access your data
- s3_secret_key: The AWS secret key to access your data
- s3_bucket: The AWS bucket where your data should be stored. All MariaDB table data is stored in this bucket.
- s3_region: The AWS region where your data should be stored.
- s3_host_name: Hostname for the S3 service.
- s3_protocol_version: Protocol used to communicate with S3. One of "Amazon" or "Original"
There are several ways to ensure you get them right:
Using aria_s3_copy to Test the Connection
Execute the following sql commands to create a trivial sql table:
use test; create table s3_test (a int) engine=aria row_format=page transactional=0; insert into s3_test values (1),(2); flush tables s3_test;
Now you can use the aria_s3_copy tool to copy this to S3 from your shell/the command line:
shell> cd mariadb-data-directory/test shell> aria_s3_copy --op=to --verbose --force --**other*options* s3_test.frm Copying frm file s3_test.frm Copying aria table: test.s3_test to s3 Creating aria table information test/s3_test/aria Copying index information test/s3_test/index Copying data information test/s3_test/data
As you can see from the above, aria_s3_copy is using the current directory as the database name.
You can also set the aria_s3_copy options in your my.cnf file to avoid some typing.
Using mysql-test-run to Test the Connection and the S3 Storage Engine
One can use the MariaDB test system to run all default S3 test against your S3 storage.
To do that you have to locate the
mysql-test directory in your system and
cd to it.
The config file for the S3 test system can be found at
To enable testing you have to edit this file and add the s3 connection options
to the end of the file. It should look something like this after editing:
!include include/default_mysqld.cnf !include include/default_client.cnf [mysqld.1] s3=ON #s3-host-name=s3.amazonaws.com #s3-protocol-version=Amazon s3-bucket=MariaDB s3-access-key= s3-secret-key= s3-region=
You must give values for
s3-region that reflects your S3 provider. The
s3-bucket name is defined by your administrator.
If you are not using Amazon Web Services as your S3 provider you must
s3-hostname and possibly change
s3-protocol-version to "Original".
Now you can test the configuration:
shell> cd **mysql-test** directory shell> ./mysql-test-run --suite=s3 ... s3.no_s3 [ pass ] 5 s3.alter [ pass ] 11073 s3.arguments [ pass ] 2667 s3.basic [ pass ] 2757 s3.discovery [ pass ] 7851 s3.select [ pass ] 1325 s3.unsupported [ pass ] 363
Note that there may be more tests in your output as we are constantly adding more tests to S3 when needed.
What to Do Next
When you got the connection to work, you should add the options to your global my.cnf file. Now you can start testing S3 from your mysql command client by converting some existing table to S3 with ALTER TABLE ... ENGINE=S3.