Appendix B. The Description of the DBMS Settings. The Parameters of the DBMS Driver

info

Dr.Web Server database structure is available in the form of a separate manual of the same name. The document can be opened from the Support section in Dr.Web Security Control Center.

As a database for Dr.Web Server you can use the following variants:

embedded DBMS;

external DBMS.

Embedded DBMS

When setting access to DBMS for storage and processing of data, use the parameters described in the table below for embedded DBMS.

Embedded DBMS

Name

Default value

Description

DBFILE

database.sqlite

Path to the database file

CACHESIZE

2048

Database cache size in pages

PRECOMPILEDCACHE

1048576

Cache size of precompiled sql operators (in bytes)

MMAPSIZE

10485760—for UNIX,

0—for Windows

Maximum size of the database file (in bytes) that is allowed to be mapped into process address space at a time.

CHECKINTEGRITY

QUICK

Verify integrity of the database image at Dr.Web Server startup:

FULL—full check for any errors concerning UNIQUE, CHECK, and NOT NULL constraints, malformed records, missing pages or index inconsistencies.

QUICK—fast check option, with no regards to constraint errors or index inconsistencies,

NO—integrity check is disabled.

AUTOREPAIR

NO

Automatically restore corrupted database image at Dr.Web Server startup:

YES—the database image restoration is initiated each time Dr.Web Server starts,

NO—automatic restoration is disabled.

WAL

YES

Use Write-Ahead Logging:

YES—true,

NO—false.

WAL-MAX-PAGES

1000

Max number of “dirty” pages. When reached, the pages will been written on disk.

WAL-MAX-SECONDS

30

Max time in seconds that the page writing on disk is delayed for.

SYNCHRONOUS

FULL

Mode of synchronous logging of changes in the database to the disk:

FULL—fully synchronous logging to the disk,

NORMAL—synchronous logging of critical data,

OFF—asynchronous logging.

The SQLite3 DBMS are provided as embedded—DBMS that is supported by Dr.Web Server starting from version 10.

External DBMS

The following database management systems may be used to arrange the external database for Dr.Web Server:

Oracle. The settings are given in Appendix B2. Setting Up the Database Driver for Oracle.

PostgreSQL. The settings necessary for PostgreSQL are given in Appendix В3. Using the PostgreSQL DBMS.

Microsoft SQL Server/Microsoft SQL Server Express. To access these DBMS, an ODBC driver may be used (setting up the parameters of the ODBC driver for Windows is given in Appendix B1. Setting Up the ODBC Driver).

warning

Microsoft SQL Server 2008 and later is supported. Microsoft SQL Server 2014 and later is recommended to use.

 

Microsoft SQL Server Express DB is not recommended for anti-virus network with a large number of stations (from 100 and more).

 

If the Microsoft SQL Server is used as an external DB for Dr.Web Server under UNIX system-based OS, the proper operation via the ODBC with FreeTDS is not guaranteed.

 

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.

info

To reduce a number of deadlocks when using Microsoft SQL Server DBMS with the default transaction isolation level (READ COMMITTED), it is recommended that you enable the READ_COMMITTED_SNAPSHOT option by running the following SQL command:

ALTER DATABASE <database_name>
SET READ_COMMITTED_SNAPSHOT ON;

The command above shall be run in implicit transaction mode and with a single existing connection to the database.

Comparison Characteristics

warning

An embedded DB can be used, if at most 200-300 stations are connected to Dr.Web 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 Dr.Web 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.

When choosing between an embedded and external database, take into account the following peculiar parameters of DMBS:

In large anti-virus networks (of over 200-300 stations), it is recommended to use an external DB, which is more fault-resistant than embedded DBs.

When using embedded DB, you do not need to install components of third-party software. It is recommended mainly for the typical use of databases.

Embedded database does not require DBMS administration skills and is a good choice for anti-virus network of small and medium sizes.

You may use an external database in case it will be necessary to work through a DBMS and access the DB directly. To facilitate access, standard APIs may be used, such as OLE DB, ADO.NET or ODBC.