database.properties Reference

plugins/AstralCore/database.properties configures the HikariCP JDBC connection pool used by DatabaseService. All keys follow standard HikariCP naming conventions.

Default file

jdbcUrl=jdbc:mariadb://localhost:3306/core?useSSL=false
driverClassName=org.mariadb.jdbc.Driver
dataSource.user=testuser
dataSource.password=test623
poolName=AstralCore

# Thread optimisation
minimumIdle=2
maximumPoolSize=5

# Connection lifecycle
maxLifetime=1800000
idleTimeout=600000
connectionTimeout=30000

# Leak detection
leakDetectionThreshold=60000

Connection Settings

Key	Type	Default	Description
`jdbcUrl`	String	`jdbc:mariadb://…`	Full JDBC URL. Supports MariaDB, MySQL, PostgreSQL, and H2.
`driverClassName`	String	`org.mariadb.jdbc.Driver`	JDBC driver class. Set automatically for bundled drivers.
`dataSource.user`	String	—	Database username.
`dataSource.password`	String	—	Database password.
`poolName`	String	`AstralCore`	Label shown in thread names and JVM monitoring tools.

Pool Size

Key	Type	Default	Recommended
`minimumIdle`	int	`2`	Number of idle connections always maintained.
`maximumPoolSize`	int	`5`	Maximum total connections in the pool.

Scaling Guidelines

Server size	`minimumIdle`	`maximumPoolSize`
Small (<50 players)	2	3
Medium (50–200 players)	3	5
Large (200+ players)	5	8

Lifecycle Settings

Key	Type	Default	Description
`maxLifetime`	ms	`1800000` (30 min)	Maximum age of a connection before it is retired.
`idleTimeout`	ms	`600000` (10 min)	How long an idle connection can sit before being removed.
`connectionTimeout`	ms	`30000` (30 s)	Maximum time to wait when acquiring a connection from the pool.

Diagnostics

Key	Type	Default	Description
`leakDetectionThreshold`	ms	`60000` (1 min)	If a connection is held longer than this threshold a warning is logged. Set to `0` to disable.

Supported Databases

Database	Driver class	URL format
MariaDB	`org.mariadb.jdbc.Driver`	`jdbc:mariadb://host:3306/db`
MySQL	`com.mysql.cj.jdbc.Driver`	`jdbc:mysql://host:3306/db`
PostgreSQL	`org.postgresql.Driver`	`jdbc:postgresql://host:5432/db`
H2 (in-memory)	`org.h2.Driver`	`jdbc:h2:mem:db`

23 April 2026