Skip to content
Thoroughbred Software InternationalThoroughbred Software InternationalThoroughbred DocumentationDocs

MariaDB Configuration

To run TS DataServer for MariaDB the following changes must be made to the default MariaDB configuration:

  • Use the InnoDB plugin:
    • Ignore the internal InnoDB storage engine
    • Set the location of the MariaDB plugins directory
    • Load the InnoDB plugin
  • Set the default storage engine to InnoDB
  • Set the transaction isolation level
  • Set the InnoDB transaction timeout value to 15 seconds.
  • Set/increase the maximum size of a packet or generated string.
  • Set/increase the time the MariaDB server will wait before closing a connection due to inactivity.
  • Change the character set and collation to Latin.

For MariaDB 10.0, the following changes must be made to the MariaDB configuration:

[mysqld]
transaction-isolation = READ-COMMITTED
innodb_lock_wait_timeout = 15
# innodb_page_size = 32KB
# for large text fields:
max_allowed_packet = 32M
# to prevent error 2006:
wait_timeout=86400
# strict mode override
innodb_strict_mode = OFF
# UTF8 overrides
skip-character-set-client-handshake
collation-server=latin1_general_ci
character-set-server=latin1

The MariaDB service must be restarted in order for the above changes to take effect.

A tsmariadb.cnf file will be included in the master file. This configuration file can be copied into the MariaDB configuration directory to enable the changes in the MariaDB server needed by TS DataServer for MariaDB to function properly.

The mysql.sock file

Section titled “The mysql.sock file”

An empty file named mysql.sock is created when MariaDB is running on a system. This file is usually located in the /var/lib/mysql directory. The permissions on the directory where the mysql.sock file is located must be at least 755 ( i.e. drwxr-xr-x ).

From the TS DataServer for MariaDB Reference, version 8.9.1. Open this page in the PDF