Setting up a Database

To install MariaDB in CentOS, run the following:

# sudo yum install mariadb mariadb-server 

Creating a Database Account

Create a database and a database user for a SignServer. Example:

# mysql -u root 

CREATE DATABASE signserver; 

GRANT ALL PRIVILEGES ON signserver.* TO signserver@localhost IDENTIFIED BY 'signserver'; 

Creating Tables and Indexes

The application server will attempt to create tables during the startup of a SignServer and if the database user does not have the permissions to create tables, the tables should be created manually. For information on database schemas for different databases, refer to doc/sql-scripts/create-tables-signserver-*.sql.

To improve the performance, the appropriate database indexes should also be applied. This is extremely important for the AuditRecordData table, otherwise the SignServer is much slower at the start. Refer to the doc/sql-scripts/create-index-signserver.sql.

Configuring MariaDB Binlog Format

For MariaDB, set the binlog_format to "row", for instance in the /etc/mysql/my.cnf, /etc/my.cnf, /etc/my.cnf.d/mariadb-server.cnf set:

# binlog_format=row