MySQL Server Pooling is the ability to manage multiple physical MySQL servers from a single installation of InterWorx. MySQL Servers can be added and then assigned to new SiteWorx accounts, so their database storage is being done by another server.
The external MySQL server must be setup in a way to allow remote connections from the InterWorx server. For the initial setup you will also need to provide a root-level MySQL username and password.
Changing the database server that a SiteWorx account uses can only be done via the command line at this time.
/home/interworx/bin/iworxdb-transfer.pex
iworxdb-transfer.pex
has several command line parameters:
Required Parameters | |
---|---|
Parameter | Description |
--domain=Domain |
Domain of the SiteWorx account you wish to transfer. |
--new-server-nickname=Server Name |
Nickname of the MySQL Server for where you want to transfer the SiteWorx databases. |
--force |
Transfer all databases regardless of collisions. WARNING: If a collision is found the database on the new server WILL BE DROPPED. |
--dont-transfer-data |
Only directs the current SiteWorx account to use the new server. Does NOT transfer users or databases. |
The following command copies the databases from the existing database server to "Server2".
/home/interworx/bin/iworxdb-transfer.pex --domain=yourdomain.com --new-server-nickname=Server2
If there are collisions then you can force the iworxdb-transfer script to drop the colliding tables using the --force flag.
/home/interworx/bin/iworxdb-transfer.pex --domain=yourdomain.com --new-server-nickname=Server2 --force
If the database is quite large and you only want the table structure to be transferred to the new server then specify the --dont-transfer-data flag.
/home/interworx/bin/iworxdb-transfer.pex --domain=yourdomain.com --new-server-nickname=server2 --dont-transfer-data