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/.
To install ClouSE from binary distribution you need to have root access to the server machine and root access to the MySQL server. If you are not sure how to get the necessary access, please ask your hoster and they will help you with that.
Download ClouSE binaries in the archive file from http://www.oblaksoft.com/downloads/ and upload it to the server. Then log into the server. If you are not sure how to log into the server, please ask your hoster and they will help you with that.
Once you logged into the server, go to the directory that has the archive file and extract ClouSE binaries using the following command:
tar xzf clouse-1.0*.tar.gz
The command will create a directory like
clouse-1.0... that contains ClouSE binaries, documentation and installation script. Go to that directory and run the install-clouse script, like this:
The script is going to prompt for MySQL’s root password as well as collect information for Cloud Storage Connection configuration, such as Access Key, Secret Key and Bucket URL.
The Access Key and Secret Key can be retrieved here:
The Bucket URL has the following format:
The <bucket> is the name of the bucket that is going to store the database data. A bucket can be created (or you can find an existing bucket) here:
The <prefix> is just an arbitrary name that can be used to isolate your database data from other files in the bucket.
If installation fails, please refer to the “Troubleshooting Configuration and Connection Issues” section in clouse.pdf, or go to http://www.oblaksoft.com/documentation/troubleshooting/ for potential solutions.
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.