Tamino XML Server Version 9.7
 —  Tamino Manager User Documentation  —

Replicate a Database

The Tamino Manager contains commands that you can use to create and manage replication databases. For further information about database replication and when to use it, please refer to the document Replication Guide.


Creating a Replication Database

The first step in creating a replication database is to create an exact copy (slave) of the database to be replicated (master) from the most recent backup of that database. To do so, you first have to create a database from a (non-initial) backup of your current database. For further information about creating a database from a backup, please refer to the section Create a Database From a Backup.

Warning:
Do not start a replication database before you have performed the step Setting a Replication Database

Top of page

Adding/removing a Replication Database Name

Once the database has been created from backup, its name has to be added to the list of permitted replication databases for the master database. A master database can have one or more replication databases. The database to which the replication database name is to be added must be active (running).

Start of instruction setTo add/remove a replication database name

  1. Expand the database object to which you want to add a replication database name.

  2. Select the object Replication Management and choose Add Replication Database from the context menu. The Add Replication Database page appears.

    graphics/addrepdb.png

  3. Enter the name of a slave database in the Replication Database Name text box (the one you have created from backup) and choose OK. It is possible to enter the name of a replication database that has not yet been created from backup, but will be in the future. Thus, you can create a "pool" of replication database names to be used at a later point in time, so that you do not have to repeat this step each time a new replication database is to be created.

    Note:
    The first time you add an entry to the list it is not necessary to restart the master database.

  4. If you want to remove the name of a database from the list of permitted replication databases, select the object Replication Management for the master database - the Permitted Replication Databases page appears.

    graphics/perrepdb.png

    Choose Remove to remove the database name from the list.

Top of page

Setting a Replication Database

Once the name of the replication database has been added to the master database, the replication database must be set as a replication database. This is done by specifying the name of the master database that is to be replicated. The replication database must be inactive (stopped).

Start of instruction setTo set a replication database

  1. Expand the database object that has been defined as the replication database (the one you have created from backup), select Replication Management and choose Set Type to Replication from the context menu. The Set replication database page appears.

    graphics/setrepdb.png

  2. Enter the name of the master database in the Master Database Name text field. If you want to enable queries to this database while replication is in progress, select the Simultaneous Query checkbox. and choose OK.

    Note:
    Once a database has been set to a replication database, the subtree under the database object in question changes and contains only the child objects Information, Replication Management, Database Spaces, Locations, Properties and Web Servers. Also, the only commands that can be performed on a replication database are Start Database, Stop Database and Delete Database. You can view the replication status of a database by selecting the object Replication Management.

Top of page

Resetting a Replication Database

If, for any reason, the master database is lost, you can reset the replication database to a normal database, which can then be used as a substitute for the lost master. The replication database to be reset must be inactive (stopped).

Start of instruction setTo reset a replication database

  1. Expand the database object of the replication database, select Replication Management and choose Set Type to Normal Database from the context menu . The Confirm Reset Replication Database page appears.

    graphics/resrepdb.png

  2. Choose OK to reset the replication database to a normal database.

Note:
Once you have reset a replication database, replication cannot be continued.

Top of page

Replication Management

Depending on whether you work with a normal database or with a replication database, the options that are available with Replication Management differ.

Replication Management for a Replication Database

If you select the object Replication Management for a replication database, information similar to the following is displayed:

graphics/man_repinfo.png

The window shows the name of the replication database's master database, the timestamp when the replication database was created, and if simultaneous query is enabled. The command Add Replication Database is not available.

Replication Management for a Normal Database

If you select the object Replication Management for a normal (master) database, information similar to the following is displayed:

graphics/man_norinfo.png

The window lists the names of the replication databases that are allowed for the master database. It also shows if simultaneous query is enabled. The buttons Set Type to Replication and Set Type to Normal Database are not available.

Top of page