# Configure MariaDB

Installing a MariaDB server is useful for development, or for running your own Whois server.

# Configuration

Set the following variables in the MariaDB configuration (location varies depending on installation, the configuration file is normally called my.cnf).

# Development machine

If MariaDB was installed through brew on an Apple Silicon machine, new configuration files can be added under /opt/homebrew/etc/my.cnf.d/.

Add the following configuration (e.g. in ripedb.cnf):

[server]
default-time-zone=+00:00
innodb_file_per_table = OFF
max_connections=1000

# Running your own Whois server

If you wish to run your own Whois server, you need additional variables to be modified:

  • max_allowed_packet = 20M

    • We need big packet sizes as some objects are very big
    • Default is 1M
    • Ref. https://mariadb.com/kb/en/mariadb/server-system-variables/#max_allowed_packet

  • innodb_buffer_pool_size = 2G

    • as we only have innodb databases, this should be set to use all the remaining memory available
    • leave some memory for the OS, and the Whois Java process, and check for swap activity
    • default is 128MB
    • Ref. https://mariadb.com/kb/en/mariadb/xtradbinnodb-server-system-variables/#innodb_buffer_pool_size

Restart MariaDB once all configuration changes have been made.

# Configure access to the database

  • Check if MariaDB is running mysqladmin -u root -p ping
  • Login to MariaDB using mysql -u root -p (or mysql with the default setup)
  • Create users:
CREATE USER 'dbint'@'localhost' IDENTIFIED BY '';
GRANT ALL PRIVILEGES ON *.* TO 'dbint'@'localhost';
CREATE USER 'rdonly'@'localhost' IDENTIFIED BY '';
GRANT SELECT PRIVILEGES ON *.* TO 'rdonly'@'localhost';

Logout with CTRL+D