Managing Catalogs : Securing Catalogs : Database Mirroring : Setting up a Catalog for Mirroring
   
Setting up a Catalog for Mirroring
Before you activate mirroring for any catalog, the location for queues and the task safety files should be configured. The location is defined in server.xml file, which is found in the conf folder in the Cumulus Server installation folder.
The initial process setting up a catalog for mirroring takes some time, depending on the size of the catalog file and the SQL database system in use. During this time, other users are blocked from accessing the catalog. For this reason, Canto recommends you deactivate the sharing option for this catalog before you start the initial process.
To set up a catalog for mirroring:
 
1. Make sure the collection window containing the catalog is the active window in Cumulus.
2. Select  Cumulus /  Edit > Preferences.
3. Click Catalog Settings.
The Catalog Settings window appears. If the active collection window contains more than one catalog, select the catalog you want to edit under Catalogs.
4. Click Mirroring. This displays the current settings for the selected catalog.
5. Activate the Use Database Mirroring option.
The fields for the mirroring target database are activated.
6. Select the database system you want to use. Depending on the selected database system, the fields for defining the actual database are displayed.
7. Enter the data required. You must define a different target database for each catalog to be mirrored.
Example: With a MySQL 5 database, the following data are required:
• Server – IP address of the server hosting the SQL database
• Database – Name of the SQL database
• User – Login name of the SQL database user
• Password – Password for the SQL database user
NOTE: If the target database is another Cumulus catalog, you can either enter the path of an existing catalog or have a new one created by entering its path.
8. Click OK to start the mirroring. The field below the definition fields informs you on the status of the mirroring.
NOTE: If you want to set up multiple catalogs for mirroring, don’t start the process for the next catalog before the current catalog has been completely processed.
To stop the mirroring for a catalog, deactivate the Use Database Mirroring option and confirm the action by clicking Apply or OK. Before you stop the mirroring you should consider that starting it again, will start the mirroring for the entire catalog from the beginning again.