Question:

How do I setup replication for databases that are managed by MySQL in Deskpro On-Premise?

Answer:

You will need to setup a second database server and have replication already configured between it and the Deskpro On-Premise server.

From within the On-Premise Controller choose the instance you want to add Deskpro replication to, go to the bottom of the page and click the "Database" box in the services entry.

Under the main SQL details you will have an option to "Add read only database", click this button and it will take you to the replication setup page:

Here you need to provide the configuration for the second server that will be handling replication.

Hostname: The Hostname or IP address that replication is setup on.

Port: The default SQL port is 3306, update this if you are using a custom port for MySQL.

Database name: The database associated with the Deskpro instance.

Username/Password: This user needs to have at least replication permissions.

You also have the option to provide a second login for an SQL user that has super/root permissions. These details will be used to check SQL replication status.

Once the details are added you need to validate the settings before they can be saved. Once validated and saved replication will be in place.