Skip to content

how to setup a database

Michael Kamm edited this page May 16, 2017 · 1 revision

1. Install MariaDB Server

2. Create db.conf file in ../src/resources directory^1

  • You'll find an example file at ../src/resources/db.conf.example
  • Or just copy following code:
db {
  url      = "jdbc:mysql://localhost:3306/clustering?zeroDateTimeBehavior=convertToNull"
  driver   = "com.mysql.jdbc.Driver"
  username = "..."
  password = "..."
}

❗ Check your host, port and database name

3. Increase max_connections size

  • login as root user into mysql console
  • check amount of current max_connections size w/ following command:
MariaDB [(none)]> select @@max_connections;
  • set max_connections to desired amount w/ following command:
MariaDB [(none)]> set global max_connections = 1000;

^1 or add your db.conf when starting the cluster master node as parameter --db db.conf.

Clone this wiki locally