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
If Zend Server Cluster Manager
cannot connect to the database, the only available action in the Administration
Interface is to login.
If the problem persists, contact Customer Support at http://www.zend.com/en/support-center/.
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:
- 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.
- 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.
manually create and setup a Zend Server Cluster Manager database:
- 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
- Open MySQL to external connections by editing the MySQL
configuration file (usually my.cnf on Linux; my.ini on Windows)
- Backup your current configuration file
- Comment-out or remove skip-networking
(if it is set)
- Set bind-address
- Restart MySQL
- Connect to the MySQL database with an administrator user
- Create a schema named 'zend_monitor'. This will be used
by Zend Server Cluster Manager to store Data:
DATABASE IF NOT EXISTS zend_monitor;
- 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.
TABLES,LOCK TABLES,CREATE VIEW,SHOW VIEW,ALTER ROUTINE,CREATE
ROUTINE,EXECUTE ON `zend_monitor`.* TO '<username>'@'%'
IDENTIFIED BY '<password>';
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. Zend Server Cluster Manager
will create tables and populate the database as needed.