Converting to a Separated Configuration Database

Converting an existing Spectrum Technology Platform installation to a separated configuration database enables you to take advantage of the improved scalability of a separated configuration database.

When you convert to a separated configuration database, your existing installation is converted from one where the configuration database is part of the server to one where the configuration database is in a separate cluster.

Note: This procedure applies both to converting a single server to a separated configuration database, and converting a cluster to a separated configuration database.

To convert to a separated configuration database:

  1. Manually back up the configuration database from your existing server.
    For more information, see Creating a Backup Manually in the Spectrum Administration Guide.
  2. Back up module-specific data for any of these modules if you have them installed.
  3. Stop the server.
    Right-click the Spectrum Technology Platform icon in the Windows system tray and select Stop Spectrum.
    If you have a clustered installation, stop the cluster.
  4. Back up the index database from the existing server.
    If you have a clustered installation, back up the index database from each node in the cluster SpectrumDirectory\index\data folder.
  5. Install the configuration database to a new server.
    1. Place the Spectrum Technology Platform installer on the machine where you want to install the configuration database. This must be a different machine from the one where you have your existing Spectrum Technology Platform server installed.
    2. Double-click installdb.exe.
    3. Follow the prompts to install the configuration database.
      Important: When prompted with the option to start Spectrum Technology Platform after the installation, you must disable this option so that the database does not start automatically when the installation completes.
    4. Restore the database that you backed up in step 1 to where you installed the configuration database.
      For more information, see Restoring a Server in the Spectrum Administration Guide.
    5. After the restore command completes, verify that a folder named graphdb is present in databases and transactions folders in these locations:

      DatabaseDirectory\repository\data\databases\graphdb
      DatabaseDirectory\repository\data\transactions\graphdb

    6. Configure the cluster properties for the database cluster by editing this file:
      DatabaseDirectory\repository\spectrum-container.properties
      For more information, see Cluster Properties for a Configuration Database Cluster
    7. Save and close the spectrum-container.properties file.
    8. Repeat steps 5.a through 5.g as required to install the configuration database on additional servers.
  6. Start each configuration database node in the cluster consecutively.
    To start the configuration database, right-click the Spectrum Technology Platform icon in the Windows system tray and select Start Spectrum.
  7. Install the server cluster.
    Note: If you want to use the same machine as part of the server cluster, then uninstall the existing Spectrum Technology Platform server.
    For more information, see Steps 6 thru 9 in Installing a Cluster with a Separated Configuration Database.
    Note: Do not start a server node until all nodes in the cluster have been configured.
  8. Restore the index database to the server cluster.
    Copy the data folder that you backed up in step 4 to the SpectrumDirectory\index folder for each node in the server cluster. If copying the backed up data folders from an existing cluster, copy the data folder to the corresponding node in the cluster.
  9. Start each server node in the cluster consecutively.
    Right-click the Spectrum Technology Platform icon on the Windows task bar, and click Start Spectrum.
    For more information, see Starting a Cluster.