The primary will be used for configuration and log data and stored in a high available Microsoft SQL server environment.
The secondary datastore will be used for Usage Tracking and I have selected to store this in a MySQL server database running on RedHat Enterprise Linux 5.6.
Before we go ahead and split the data store we have to make sure that all clients have the MySQL Connector ODBC drivers installed. This is done in a few seconds with RES Automation Manager.
When the connector software has been installed we can go ahead and split the data store.
When the split is complete, RES Workspace Manager will automatically create a new pointer on the Workspace Composer so Usage Tracking data is copied to the new datastore.