Database server configuration module

From ISPWiki
Jump to: navigation, search

This article walks you through the steps you need to perform to configure a database server module in ISPmanager 5.

How it works

In ISPmanager 5 Lite go to "Database servers" -- "Settings"

In ISPmanager 5 Business go to "Cluster nodes" -- "Database servers")

The module retrieves a list of settings from the database servers (MySQL or PostgreSQL). This list contains both current and default parameters.

When editing a parameter, you can set a new value, which will be specified into the configuration file of the database server.

If the parameter value differs from defaults, you can reset it. The value for this parameter will be deleted from the database server configuration file.

After the configuration file of the database server has been changed, the database server will be rebooted. If this procedure fails, the configuration file will be reset to its previous state, and the database server will be rebooted again.

The following paths are specified in the control panel's configuration file:

 path mysqld.ini - path to the MySQL configuration file 
 path mysql_restart - command to restart  MySQL
 path postgresql.conf - path to the PostgreSQL configuration file 
 path postgresql_restart - command to restart PostgreSQL

Notes for ISPmanager 5 Business

If you configure the MySQL database server on a local cluster node, additional actions will be performed to prevent restart of MySQL while running the control panel.

The master control panel, which uses MySQL, will be suspended before MySQL starts. After that other actions will be performed to apply a new parameter.

 Attention! If the local cluster node is added into the control panel as a remote node, the control panel won't be restarted.  
 This will result in termination of the master panel.