| Column |
|---|
| database.The for Zephyr Enterprise Data Center will be referenced as part of the installation of Zephyr Enterprise Data Center. It will need to be installed separately and prior to the installation of Zephyr Enterprise Data Center. These instructions will help you connect your Zephyr Enterprise Data Center installation to a Microsoft SQL Server Database
This guide is for setting up a instance of MySQL to allow use for Zephyr Enterprise Server and Data Center. This guide assumes MySQL is already present and in its desired root location |
...
Supported Databases
...
MySQL Community Server
Prerequisites
...
- Check whether your version of MySQL is supported
- If you are upgrading from Zephyr Enterprise 4.7, a MySQL Database will already be present, so you won't need to install this again
- Have an installation of MySQL ready
- Ensure the JDBC driver is stored locally on the Application Server where Zephyr Enterprise Data Center will be installed
...
The following steps will need to be followed:
Step 1: Login to your MySQL Server
Open command prompt and navigate to your MySQL installation folder (i.e. C:\Program Files\MySQL\MySQL Server 5.6\bin)
...
In this example the username is root. In a new MySQL instance, root is the default user and can be logged in without a password. If you are using an existing MySQL Server instance, the username and password may be different.
Step 2: Create a new user for Zephyr
Create a new database user which Zephyr Enterprise Data Center will connect as. The command to create a new user is seen below:
| Code Block |
|---|
|
CREATE USER 'zephyrDBuser@'localhost' IDENTIFIED BY 'zephyrDBuserPass'; |
Step 3: Set permissions for remote access
Now type the below command to make the Database accessible remotely.
...
zephyrDBuser represents the username and ZephyrDBuserPass is the password for the newly created user from Step 2.
The '*.*' is granting permissions to all databases. Replace 127.0.01 with the IP address of the server Zephyr Enterprise will be installed on. This command will grant access to ALL databases for the IP addresses given. The minimum permission requirement are the privileges to create and populate tables.
...
Now you an access your MySQL database remotely from the designated IP(s).
Step 4: Set Memory and Max Connections
Navigate to the my.ini file (Windows) or my.cnf (Linux), the default locations are the MySQL root folders.
Set the following values for the parameters:
| Parameter | Minimum value |
|---|
| innodb_buffer_pool_size= | 4096M |
| query_cache_size= | 1M |
| key_buffer_size= | 8M |
| max_connections= | 500 |
If no lines contain these parameters, then create new lines for them.
...
| Tip |
|---|
| title | Queries for checking Memory |
|---|
|
To check values of a parameter, use the following SQL queries: | Code Block |
|---|
| SELECT @@innodb_buffer_pool_size;
SHOW VARIABLES LIKE 'query_cache_size';
SHOW VARIABLES LIKE ' key_buffer_size ';
SHOW VARIABLES LIKE 'max_connections'; |
|
Step 5: Install Zephyr Enterprise Data Center and Connect to the Database
Now the MySQL database is ready, open the Zephyr Enterprise Data Center installer. The wizard will take you through the setup steps. You can find the guide for installing Zephyr Enterprise Data Center on Windows and Linux /wiki/spaces/ZEE48/pages/57835522.
...
| Info |
|---|
|
MySQL Logging If you are having problems with your MySQL database after making these changes, please consult your OS's application logs for issue details. |
Back to Top ^