Zend Server Cluster Manager Database

Zend Server Cluster Manager requires a MySQL 5.0 (or above) database in order to store information aggregated from the servers belonging to the cluster.

 

When installing Zend Server Cluster Manager for the first time, you will be prompted to setup the Zend Server Cluster Manager database.

This can be done in one of two methods:

  1. Create the database for me - allows you to provide an administrator username (usually root) and password for the database. The setup wizard will then use these credentials to create a schema and a dedicated (unprivileged) user which will be used by Zend Server Cluster Manager to store data. The administrator credentials are not saved and will never be used beyond this step.
  2. I have already set up the database - allows you to manually create a schema and a user in your existing database and set Zend Server Cluster Manager to use these existing credentials. While this method requires additional manual intervention, it may be more suitable for environments where the person installing Zend Server Cluster Manager does not have administrator permissions to access the database. Instructions on how to manually configure the Zend Server Cluster Manager database are as follows:

Manually Configuring the Zend Server Cluster Manager Database

This procedure describes how to manually create and setup a Zend Server Cluster Manager database schema and user.

Before creating the database, make sure that the server on which you are installing the database is accessible by Zend Server Cluster Manager and all Zend Server instances that are potential cluster members.

 

 

Instructions on how to complete a procedure

To manually create and setup a Zend Server Cluster Manager database:

  1. Install a MySQL Server 5.0.X or 5.1.X you can also use an existing database server for this purpose as long as it is a compatible MySQL version and accessible from all the servers.
  2. Open MySQL to external connections by editing the MySQL configuration file (usually my.cnf on Linux; my.ini on Windows)
    1. Backup your current configuration file
    2. Comment-out or remove skip-networking (if it is set)
    3. Set bind-address to 0.0.0.0
    4. Restart MySQL
  3. Connect to the MySQL database with an administrator user (e.g. root)
  4. Create a schema named 'zend_monitor'. This will be used by Zend Server Cluster Manager to store Data:

CREATE DATABASE IF NOT EXISTS zend_monitor;

  1. Run the following commands to create a user (e.g. 'zend') which will be used by Zend Server Cluster Manager to access the database you just created:
    Note: Replace <username> and <password> in the following SQL commands with the username and password you wish to use.

GRANT CREATE,DROP,ALTER,DELETE,INDEX,INSERT,SELECT,UPDATE,CREATE TEMPORARY TABLES,LOCK TABLES,CREATE VIEW,SHOW VIEW,ALTER ROUTINE,CREATE ROUTINE,EXECUTE ON `zend_monitor`.* TO '<username>'@'%' IDENTIFIED BY '<password>';
FLUSH PRIVILEGES;

  1. Disconnect from the database and populate the database you have just created by running the following command as root:
    Replace <username> with the username you created in step 5, you will also be prompted to type the password for this user.

mysql -u <username> -p zend_monitor < <install_path>/share/mysql_create_monitor_db.sql

In the Zend Server Cluster Manager Configuration Wizard (step 4), select the option "I have already setup the database and enter the user name, password, host, and port for the schema you have just created.

 

 

Related Links

Related Links:

Licenses and Registration