ManageEngine Applications Manager High Availability setup with dual database (MySQL).

ManageEngine Applications Manager High Availability setup with dual database (MySQL).

Apart from the Failover setup,  which uses a single database and dual Application Server, we also support a failover with dual database and Application Server. Failover support requires you to configure Applications Manager Secondary (Standby server) and keep monitoring the Applications Manager Primary server.

In case of failure in the Primary server, the Standby server automatically starts monitoring the network. The transition is so quick and smooth that the end user does not feel the impact of the failure of the Primary server or the subsequent taking over by Standby. In parallel, the Standby server also triggers an email alert about the Primary's failure. 

Once the Primary server is restored back to operation, the Standby server automatically goes back to standby mode. We use MySql’s built-in replication feature to sync the data from the primary to secondary database.

 

 

For steps to set up the failover with dual database, please refer this PDF.


                  New to ADSelfService Plus?

                    • Related Articles

                    • Resolving Issues When Onboarding SSL-Enabled MySQL Database Servers

                      Error Message: Connections using insecure transport are prohibited while --require_secure_transport=ON Solution: To overcome this issue follow the steps given below: Execute the following query in the corresponding MySQL shell script: ALTER USER ...
                    • How to view data under Session & Performance tab in MySQL monitor?

                      Note: If the server is a MariaDB server, check whether the SYS database is installed by executing the below query on MariaDB shell: show databases; If the output does not contain the SYS database, then install the SYS database suitable for the ...
                    • How can I upgrade the MySQL connector.jar?

                      For all the following issues mentioned below, the solution is same. Invalid authorization specification message from server. Unknown character set index for field '255' received from server. Communication link failure: javax.net.ssl.SSLException. ...
                    • Maintenance of Applications Manager backend database

                      Note: Please take complete database backup without fail prior to these steps. I. Applications Manager with PostgreSQL Database. Shutdown all Applications Manager related process as follows: For windows: Open services.msc --> stop ManageEngine ...
                    • Unable to upgrade Applications Manager - MySQL Deprecation

                      Problem: You encounter the following error while trying to install service pack for Applications Manager v16140 and above: Reason: This error occurs because MySQL backend database has been deprecated in Applications Manager. Solution: You have to ...