Navigation:  Setup >

Configure MySQL Server

Top  Previous  Next

If you checked the Configure the MySQL Server now check box on the final dialog of the MySQL Server installation, then the MySQL Server Instance Configuration Wizard will automatically start.

 

Follow the instructions below carefully to configure your MySQL Server to run correctly with EventSentry.

 

 

mysql5

 

Select Detailed Configuration

 

 

mysql6

 

It is recommended that you use a Dedicated MySQL Server Machine for your

MySQL database, if this is not an option then select "Server Machine".

 

alert or warning 1 24 n g

If you selected Dedicated MySQL Server Machine and your MySQL service does not start after the wizard completes, then try to re-run the wizard (or re-install) MySQL, but this time select the Server Machine option.

 

 

mysql7

 

Select Transactional Database Only, this will make sure that

InnoDB is the main storage engine.

 

 

mysql8

 

Select the drive where the database files will be stored.

Select the drive on the fastest drive(s) on your server.

 

mysql9

 

Enter the number of agents you are monitoring, multiplied by two.

For example, if you are monitoring 20 servers then enter 40.

 

 

mysql10

 

It is recommended that you leave the default port 3306 in place, however

EventSentry will also work with non-standard ports if necessary.

 

 

mysql11

 

Select the Standard Character Set for EventSentry.

 

 

mysql12

 

It is highly recommended that you run the MySQL Server as a Windows

service and include the binary directory in the search path.

 

 

mysql13

 

Specify a secure root password, you may want to check the box Enable root access

from remote machines if you plan on administering your MySQL server

from your workstation or other servers.

 

alert or warning 1 24 n g

If you are getting an error message after clicking the Next button, then please see the Windows XP Firewall Settings chapter for more information.

 

mysql14

 

If you see this dialog then your instance was setup correctly.