On the Database tab, you can configure a DBMS required for Dr.Web Server operation.
|
You can get the structure of Dr.Web Server DB via the init.sql script, located in the etc subfolder of Dr.Web Server installation folder. |
To specify parameters of operating with the database
1.In the Number of connections field, specify the maximal number of connections of the Server with database. It is recommended to change default value only after consultation with the technical support.
2.Set the Automatically purge the database after maintenance procedures flag to automatically perform the delayed purging of the database after its initialization, upgrade and import. If the flag is cleared, automatic purge is not performed. In this case, it is recommended to configure the Purge database task in the Server schedule or purge database manually in the Database Management section.
To perform the automatic purging, the hidden task is created in the Server schedule. The task is launched at nearest night after the named maintenance procedures, at 01:17 by local time of the Server. The task is executed only if the Server schedule does not contain another Purge database task within the next 24 hours relative to the named maintenance procedures.
3.Select the type of database in the Database drop-down list:
•MySQL—external DB,
•ODBC—to use external DB via the ODBC connection,
|
If warnings or errors occur in Dr.Web Server interaction with Microsoft SQL Server DBMS via the ODBC, please make sure that you are using the latest available DBMS version for this edition. How to determine updates level, you can find on the following page of Microsoft corporation: https://docs.microsoft.com/en-US/troubleshoot/sql/general/determine-version-edition-update-level. |
•Oracle—external DB for all platforms except FreeBSD,
|
If an Oracle external DBMS is used via the ODBC connection, it is necessary to install the latest version of the ODBC driver delivered with this DBMS. It is strongly recommended not to use the Oracle ODBC driver supplied by Microsoft. |
•PostgreSQL—external DB,
•SQLite3—embedded DB (a component of Dr.Web Server).
4.Specify requirement settings for an embedded DB operation:
•If necessary, specify the full path to the database file into the File name field.
•Specify the DB cache size.
•Specify the cache size of precompiled sql operators.
•In the Memory mapped file size (B) field, specify the maximum number of bytes of the DB file.
•In the Image integrity verification drop-down list, select the verification mode of DB image integrity at Dr.Web Server startup.
•Set the Restore corrupted image automatically flag to automatically restore corrupted DB image at Dr.Web Server startup.
•Set the Enable WAL flag to enable Write-Ahead Logging. If the Enable WAL flag is set, you can also configure additional parameters:
▫In the Maximal number of "dirty" pages field, specify the maximal number of "dirty" pages on reaching of which pages will been written on the disk.
▫In the Maximal delay of pages writing (sec.) field, specify the maximal time to delay writing the pages on the disk (in seconds).
• Specify the flush mode.
5.Click Save to apply specified settings.
The parameters of an external DB are described in detail in the Appendices document in Appendix B. The Description of the DBMS Settings. The Parameters of the DBMS Driver.
|
Dr.Web Server distribution kit contains embedded clients for supported DBMS, so note: •If you plan to use embedded DBMS clients which are supported within Dr.Web Server, then during installation (upgrade) of the Server, in the installer settings, select the Custom option of the installation and in the next window make sure that installation of corresponding embedded DBMS client is enabled in the Database support section. •If you are going to use the Oracle DB as an external database via the ODBC connection, then during installation (upgrading) of the Server, in the installer settings, disable the installation of embedded client for Oracle DBMS (in the Database support → Oracle database driver section).
Server installer supports change mode of the product. To add or remove separate components e.g. databases management drivers, it is enough to run Server installer and select the Change option. |
Using an embedded DBMS is selected by default. This mode considerably increases the load on the Server. It is recommended to use an external DBMS in large anti-virus networks. Changing the type of the DBMS is described in the Appendices, document, in the Changing the Type of the DBMS for Dr.Web Enterprise Security Suite section.
|
An embedded DB can be used, if at most 200-300 stations are connected to the Server. If the hardware configuration of the computer with Dr.Web Server and the load level of other executing tasks are permissible, up to 1000 stations can be connected. Otherwise, you must use an external DB. If you use an external DB and more than 10 000 stations are connected to the Server, it is recommended to perform the following minimal requirements: •3 GHz processor CPU, •RAM at least 4 GB for Dr.Web Server and at least 8 GB for the DB server, •UNIX system-based OS. |
|
It is possible to perform transactions connected with clearing the database used by Dr.Web Server, in particular to delete records of events and data about the workstations which have not visited the Server for a certain period of time. To clear the database, open the Server schedule and add a corresponding task. |