To load data into the database, ClustrixDB provides the clustrix_import parallel import tool, which takes advantage of the clustered nature of our product to speed up the process. You can download a copy of the Import tool at the Clustrix Support Forums. The import tool requires Python 2.5 or later. If you don't have Python 2.5 installed, you can use the import tool directly from the cluster.
- Perform a mysql dump from your MySQL instance.
- Copy your mysql dump file to the /clustrix directory on any node.
- Download the Clustrix Import Tool and place it in the same /clustrix directory as the dumpfile.
- Untar the file on the same server as the MySQLDump and run the following command:
To import data, invoke the import tool as follows:
The import tool connects to the specified IP address and figures out which IP addresses belong to the cluster.
For full documentation of clustrix_import, please see the page clustrix_import.