B4. Using the MySQL DBMS

General Description

MySQL—cross-platform relational databases management system. MySQL DBMS may be used as an external DB for Dr.Web Enterprise Security Suite.

To use MySQL as an external database

1.Install the MySQL server.

2.Set up Dr.Web Server to use the respective external database. You can do this in configuration file or via Dr.Web Security Control Center: in the Dr.Web Server configuration menu, the Database tab.

Installation and Supported Versions

Dr.Web Enterprise Security Suite supports the following versions of MySQL DBMS:

•MySQL—from 5.5.14 to 5.7; all versions starting from 8.0.12,

•MariaDB—10.0, 10.1, 10.2, 10.3, 10.4.

After DBMS installation, before creating a new database, it is necessary to specify the following settings in its configuration file (see your DBMS documentation for more details):

For MySQL of 5.Х versions:

[mysqld]

innodb_large_prefix = true

innodb_file_format = barracuda

innodb_file_per_table = true

max_allowed_packet = 64M

For MySQL of 8.Х versions:

[mysqld]

innodb_file_per_table = true

max_allowed_packet = 64M

If the used DBMS MariaDB has version earlier than 10.2.4, when you also must set the following in the configuration file:

binlog_format = mixed

Parameters

To adjust access to the MySQL DBMS, use the parameters described in Table below.

Parameters of the MySQL DBMS

Name

Default value

Description

HOST

localhost

•Database server address—when connecting to database via TCP/IP.

•Path to UNIX socket file—when using UDS. If not set, Dr.Web Server tries to locate the file in one of standard mysqld directories.

PORT

3306

•Connection port number—when connecting to database via TCP/IP.

•UNIX socket file name—when using UDS.

DBNAME

 

Database name

USER

 

Registration name of database user

PASSWORD

QUICK

Database user password

PRECOMPILEDCACHE

1048576

Cache size of precompiled sql operators (in bytes)

SSL

NO

Allow SSL connections only:

•YES — connect to database only if SSL protocol is used,

•NO — SSL protocol is not necessary to connect to database.