Database Configuration
SigmaOrders supports SQLite (default, file-based, zero setup, good for under ~200 players) and MySQL (external server, better for large or multi-server setups).
SQLite
database:
type: SQLITE
No additional configuration is required. Data is stored in plugins/SigmaOrders/database.db - back up by copying this file. Limitation: single-server only, slower under heavy concurrent load.
MySQL
database:
type: MYSQL
mysql:
host: localhost
port: 3306
database: sigma_orders
username: root
password: your_password
pool-size: 10
| Setting | Type | Default | Description |
|---|---|---|---|
host | String | localhost | Database server hostname |
port | Integer | 3306 | Database server port |
database | String | sigma_orders | Database name |
username | String | root | Database username |
password | String | password | Database password |
pool-size | Integer | 10 | Connection pool size; increase for high-traffic servers (50 max recommended) |
Setup: create the database/user in MySQL first (CREATE DATABASE sigma_orders CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;), set type: MYSQL with the connection details above, then restart - the plugin creates tables automatically.
warning
Migration from SQLite to MySQL is not automatic. Back up database.db first; existing data must be exported/imported manually or you start fresh.
Troubleshooting
| Symptom | Check |
|---|---|
| "Failed to connect to database" | Server running, host/port, credentials, firewall rules |
| Slow operations / timeouts | Increase pool-size, check server resources, consider MySQL for large servers |
| "Access denied" | User permissions/GRANTs, database name |