MariaDB

Database Setup

create databases named palmyra, demo

Create database palmyra

Run the scripts available under setup/database/mariadb folder. Run the scripts in the below order

1. palmyra_schema.sql
2. palmyra_data.sql
3. demo_data.sql

For MySQL also, the above steps should be performed.

Connect to database

After the database schema is successfully created, Configure the connection parameters in the property file

resources/database/myapp.properties

db.server=127.0.0.1
db.port=3306
db.user=mariadb
db.password=secretkey
db.schema=palmyra
db.addl.schema=demo


# Do not modify the below settings
db.type=mariadb
db.driver=org.mariadb.jdbc.Driver
db.poolMaxSize=25
db.poolMinIdle=10
db.poolMaxIdle=20
db.poolInitialSize=5

Now the database setup is complete. Restart the server to make the changes effective.