MySQL Installation on Windows

Prerequisites

Download the MySQL server installer for Windows: https://dev.mysql.com/downloads/windows/installer/.

Install Microsoft .NET Framework version 4 if required. Depending on the OS version.

Installation and configuration

1.Run the downloaded installer file to start the installation. In the Choosing a Setup Type screen, select Server only version and then click Next.

2.For Group Replication, select Standalone MySQL Server / Classic MySQL Replication.

3.In the Type and Networking screen, select any Config Type, type in your preferred Port Number (or use port 3306 by default) and then click Next.

4.In the Accounts and Roles screen, set the MySQL Root Password and click Add User to create another MySQL user account secured with a password and with a DBA role assigned.

important

Important

Remember the username and password you configured for a new user with DB admin role, as it is used during the installation of the EEI server process.

6.In the Windows Service screen, we recommend that you select Configure MySQL Server as Windows Service and Start the MySQL Server at System Startup. Otherwise, you will have to start the server manually each time (for example, using the net start mysql command from an administrative command prompt).

7.In the Plugins and Extensions screen, keep the default values.

8.In the Apply Configuration screen, click Execute. If the configuration steps are complete successfully, click Finish.

9.In the subsequent screen, click Next, and then Finish.

warning

Warning

For editing my.ini file, please make sure it is saved in ANSI, not in UTF-8 format. We recommend using Notepad++ that will not change the file format after save.

important

Important

You have to modify the my.ini file located in C:\ProgramData\MySQL\MySQL Server X.X. for further EEI Server installation. Before editing, backup the ini file.

Find the following variables and change their values. If a variable doesn’t exist, add it at the end of my.ini file:

Increase the value of open_files_limit to at least 30000.

Change the value of innodb_flush_log_at_trx_commit to 0.

Set innodb_buffer_pool_size to 80% percent of the RAM. For instance, if the server has 16GB of RAM it should be set in the following way: innodb_buffer_pool_size=12G. The minimum value is 1G.

Set innodb_log_file_size to 50% of value of setting innodb_buffer_pool_size

Set lower_case_table_names to 1. This attribute is only valid for 5.7 version.

Set thread_stack=256K.

Set log_bin_trust_function_creators=1.

Set event_scheduler=ON.

Set local_infile=1. This attribute is only valid for 8.x version.

After saving these changes, restart the MySQL service.

important

Important

Since ESET Enterprise Inspector executes a massive number of SQL statements, MySQL's general log and MySQL's binary log can be huge. Please consider disabling the general log and a binary log if they are not used. Consider also limiting their size or time of logging, using MySQL configuration parameters.

note

Note

MySQL is the most crucial part of the EEI server and can consume whole disk space. Due to operating system stability, we recommend moving the MySQL data and a temporary folder to the dedicated partition (follow steps below) or to a separate server machine.

Follow these steps:

1.Stop MySQL Service.

2.Move or copy the Data folder onto the dedicated partition i.e. D:\.

3.Edit my.ini file located by default in C:\ProgramData\MySQL\MySQL Server X.X. and search for the '# Path to the database root' string and change the path to the location of the new Data folder, for example, D:\Data. The folder has to be created before altering the my.ini file.

4.If MySQL is installed on a separate server than EEI Server, you need to modify permissions for the Network Service to be able to access that folder. Otherwise, continue to step 5:

1.Go to Start > Administrative Tools > Computer Management > System Tools > Local Users and Groups > Groups.

2.Double-click Users.

3.Click Add.

4.Click Locations and select your computer node, click OK.

5.Type 'Network Service' into the 'Enter the object names' or click Advanced, then Find Now and select it from the Search Results.

5.Edit my.ini file located by default in C:\ProgramData\MySQL\MySQL Server X.X. Under [mysqld] search for "tmpdir". If missing, add the following line tmpdir = D:/mysqltemp where the "mysqltemp" is a custom folder. The folder has to be created before altering the my.ini file.

6.Start MySQL Service.

When calculating required disk space, we are tracking three folders:

Database folder—The folder where MySql or SQL Server stores EEI database

Temporary database—The folder where MySql or SQL Server stores temporary tables

The EEI Server data folder—C:\ProgramData\ESET\EnterpriseInspector\Server folder

If the database is installed on the same machine as the EEI Server, then EEI stops accepting new events when:

There is less than 3% of free space on the disk with the database folder

There is less than 3% of free space on the disk with the temporary database folder

There is less than 5% of free space on the disk with the EEI Server data folder

If the EEI Server data folder and temporary database folder are on the same disk, EEI stops accepting new events if there is less than 10% of free space on this disk

If the database is located on the same machine as EEI, there has to be at least 10% free disk space where the temporary folder is for the Purge to be working. Any problems with the database purge are displayed as red markers on the Events processed chart on the Events Load Dashboard’s tab.