Views:
This service allows an external database server to replicate data from the SMS. Using an external database for data replication allows you to offload report processing to an external server which can provide performance gains to your existing system. Reboot the SMS to completely enable or disable this service.
Before you begin, make sure that your replication system has sufficient disk space to accommodate the database and any increase in size due to additional data or reporting.

Procedure

  1. In the SMS, go to Admin → Database.
  2. On the External Database Settings panel, click Edit.
  3. In the Edit External Database Settings wizard, select External Replication Settings.
    Note
    Note
    To configure external database replication, you must create an SMS database snapshot, and then copy the snapshot to the target replication system and import it into a MariaDB database before the SMS server can replicate its data to the target system.
  4. Select Enable external database replication to enable the service. (To disable the service, clear the check box.)
  5. Provide the following:
    • Username – Provide the user name for an account with sufficient rights to read all the desired data from the SMS database.
    • Password – Provide the password for the user account. Retype the password in the Confirm Password field.
  6. If you changed the replication settings, click Reboot to restart the SMS server and initialize the service.
    Note
    Note
    Follow your company’s server downtime policies, including notification to SMS clients of a pending reboot. Before you reboot the SMS, gracefully stop other client connections to the server.
  7. Click Create Snapshot, and select Include Events in Snapshot if you want the snapshot to include event data.
    Note
    Note
    The snapshot is saved locally on the SMS server. You must copy the snapshot to the target replication system and import it into a new or existing MariaDB database before the SMS server can replicate its data to the target system.
  8. Click OK.
    Note
    Note
    External database replication and the SMS High Availability (HA) features both leverage the same functionality in the underlying MariaDB database. The SMS database does not support replication to multiple destinations; therefore, we do not recommend using SMS HA and external database replication at the same time.