Database Splitting And Clustering

Parallels Business Automation - Standard team has prepared a tool set that will help building the cluster. The tool is shipped in the form of Perl script, its usage is quite simple and we describe it step-by-step below.

First of all, it is necessary to prepare a clean Linux installation with installed MySQL server version not lower than 4.1 with opened SSH access for user root.

To split database from the back-end node:

Start the hspc-cluster.pl tool in the back-end configuration mode ( with -b or --backend flag).
Reply yes to the Do you want to move out database on another server? question.
Enter a new server's address. After this the script will generate (if needed) and put a DSA SSH public key to a remote server.
The script will stop the MySQL service and start migrating its data file. For a bulky dataset this can take some time.
After the database is migrated, the script will be automatically cloned at a remote server and transparently started in the database configuration mode (with -d or --database flag). The remote script will exit and its local copy will continue to work.

After the steps enlisted above are finished, the database node will be completely split from Parallels Business Automation - Standard. Any unnecessary services will be stopped to prevent parasitic loading of the hardware node. Do not forget to restart related services (will be prompted by the configuration tool as well).

Please send us your feedback on this help page