Amazon Machine Image (AMI) with Linux, MySQL and ClouSE
As a convenient starting point OblakSoft provides an EBS-backed AMI with Amazon Linux, MySQL server community edition and ClouSE preinstalled. For more information about OblakSoft AMI please go to http://www.oblaksoft.com/downloads/.
Binary distribution
ClouSE can be downloaded from http://www.oblaksoft.com/downloads/.
To install ClouSE copy the clouse.so and ha_clouse-*.so files to the MySQL plugin directory. To get the location of the MySQL plugin directory the following statement can be used:
mysql> SHOW VARIABLES LIKE 'plugin_dir';+---------------+-----------------------------+| Variable_name | Value |+---------------+-----------------------------+| plugin_dir | /usr/local/mysql/lib/plugin |+---------------+-----------------------------+
To configure ClouSE incorporate the content of my-clouse.cnf into the my.cnf file for the MySQL server and set the configuration options as appropriate for your S3 / Walrus configuration.
The clouse_cloud_data_url and clouse_cloud_auth_key configuration options are required, and the clouse_cloud_data_encrypt_key is recommended to set, other options are optional. See the comments in the my-clouse.cnf file for option descriptions and refer to the clouse.pdf for more detailed documentation and examples.
To install the ClouSE plugin into MySQL the following statement can be used:
mysql> INSTALL PLUGIN ClouSE SONAME 'ha_clouse-N.N.N.so';
where N.N.N should be substituted with the corresponding MySQL version. To get the MySQL version the following statement can be used:
mysql> SELECT version();
+-----------+
| version() |
+-----------+
| 5.5.18 |
+-----------+
To create a table in ClouSE the ENGINE=CLOUSE option can be used in the CREATE TABLE statement, for example:
mysql> CREATE TABLE t1 (id INT KEY, data VARCHAR(64)) ENGINE=CLOUSE;
Alternatively, the default-storage-engine configuration option can be set to ClouSE so that all new tables are created in ClouSE by default (the my-clouse.cnf file has this option set to ClouSE).
To move an existing table to ClouSE the ENGINE=CLOUSE option can be used in the ALTER TABLE statement, for example:
mysql> ALTER TABLE t2 ENGINE=CLOUSE;
For more information about ClouSE and MySQL please refer to http://www.oblaksoft.com/docs/clouse.pdf and the MySQL documentation correspondingly.