Configuring a Preexisting Database Engine Installation

← to return to silent installation instructions

Nintex Process Discovery supports using a dedicated Windows version of MariaDB 10.3.7 (or higher) and MySQL 8.0.11 (or higher). If you already have MariaDB or MySQL installed on your server, follow the steps below to configure database installation.

Preexisting database engine configurations must always be done prior to Discovery Server installation.

Configure the database configuration file

  1. For MySQL, open the database configuration file my.ini, and add the following line:

    2. # Set default time zone

    default-time-zone = '+00:00'

    default-time-zone='timezone' where 'timezone' represents the UTC time zone of the server, for example, default-time-zone='+00:00' (the format 'system' is not supported)

  2. For both MySQL and MariaDB, we recommend the following settings to improve database performance. Set the following parameter values in my.ini:

    3. long_query_time=1

    max_connections=200

    table_open_cache=1000

    tmp_table_size=64M

    thread_cache_size=200

    key_buffer_size=128M

    innodb_flush_log_at_trx_commit=1

    innodb_log_buffer_size=16M

    innodb_buffer_pool_size=8G

    innodb_log_file_size=1000M

    innodb_thread_concurrency=8

    innodb_buffer_pool_instances=8

    innodb_open_files=2000

    innodb_stats_on_metadata=OFF

    innodb_checksum_algorithm=crc32

    back_log=200

    max_allowed_packet=1G

    table_definition_cache=500

    character_set_server=utf8mb4

    collation_server=utf8mb4_unicode_ci

  3. Save the file.

  4. Restart the database service.

Configure the discovery server json configuration file parameters

See here for a full explanation of Discovery Server JSON configuration file parameters.

  1. Open the JSON file provided with the installation package, PDServer64BitSetup.exe.json with a text editor.

  2. Enter the values for your existing database engine (between the double-quotes that correspond to the parameters below):

    3. "DB_SERVICE_NAME": "your service name"

    "DB_SERVER": "your DB server"

    "DB_PORT": "your DB port"

    "DB_ROOT_NAME": "DB root user name"

    "DB_ROOT_PASSWORD": "DB root user password"

    "DB_USER_NAME": "DB user name"

    "DB_USER_PASSWORD": "DB user password"

  3. Save the JSON file.