Database Setup

Database Setup

asLiteTeam supports three storage backends. Set your choice in config.yml:

database:
  type: sqlite   # yml | sqlite | mysql

---

YML

database:
  type: yml

Data is stored in flat YAML files inside plugins/asLiteTeam/data/. Good for: testing, very small servers. Not recommended for production — no concurrent access protection.

---

SQLite (Default)

database:
  type: sqlite

Data is stored in a single database.db file in the plugin folder. Good for: most servers that do not need a remote database. No additional setup required.

---

MySQL

database:
  type: mysql

  mysql:
    host: localhost
    port: 3306
    database: asliteteam
    username: root
    password: ''

    pool-size: 10
    pool-min-idle: 2
    pool-max-lifetime: 1800000
    pool-connection-timeout: 30000
    useSSL: false
    characterEncoding: utf8mb4

Setting	Description
host	MySQL server IP or hostname
port	MySQL port (default: 3306)
database	The database name (must exist before starting)
username	MySQL username
password	MySQL password (leave empty if none)
pool-size	Max concurrent connections (HikariCP)
pool-min-idle	Minimum idle connections kept open
pool-max-lifetime	Max connection lifetime in ms (default: 30 min)
pool-connection-timeout	Connection timeout in ms (default: 30 sec)
useSSL	Enable SSL (recommended true in production)
characterEncoding	Character set (utf8mb4 recommended)

MySQL Setup Steps

1. Create the database on your MySQL server:

CREATE DATABASE asliteteam CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

2. Create a user and grant permissions:

CREATE USER 'asteam_user'@'localhost' IDENTIFIED BY 'yourpassword';
GRANT ALL PRIVILEGES ON asliteteam.* TO 'asteam_user'@'localhost';
FLUSH PRIVILEGES;

3. Fill in the credentials in config.yml.
4. Restart the server or run /asteam reload.

The plugin automatically creates all required tables on first start.