MySQL Databases
Many game plugins and mods (such as LuckPerms, CoreProtect, Dynmap, or custom registration systems) require a MySQL/MariaDB database to store player data, permissions, or block edits quickly and reliably, rather than storing them in local.json or .db flat files which can slow down your server performance.
With Vellix Hosting, you can provision and manage MySQL databases with a single click directly from your Reviactyl panel.
1. Creating a Database in the Panel
To create a new database:- Access your server dashboard on the panel at panel.vellix.host.
- Click on the “Databases” tab in the sidebar navigation menu.
- Click the “Create Database” button in the upper-right corner.
- Fill out the fields:
- Database Name: Provide a short descriptive name for the database (e.g.,
luckpermsorplayerdata). - Connections From: Set this to
%(percent sign) to allow connections from any host (this is the most flexible configuration and prevents firewall issues if connecting from outside the node, e.g., web servers or BungeeCord proxies).
- Database Name: Provide a short descriptive name for the database (e.g.,
- Click the “Create Database” button.
2. Retrieving Database Credentials
Once your database is created, you will see a card with the connection parameters. Click on the lock icon to reveal the password:- Host / Endpoint: The IP address or domain of the database server (e.g.,
mysql.vellix.hostor a node IP). - Database Name: The final name generated by the panel, usually prepended with your server ID (e.g.,
s1_luckperms). - Username: The auto-generated database username (e.g.,
u1_xYzA). - Password: The unique, secure password generated for this database user.
- Port: The standard MySQL port, which is
3306.
3. Configuring Your Plugin (Example: LuckPerms)
To connect a plugin to your new database, open the plugin’s configuration file (usuallyconfig.yml or config.conf) in the Web File Manager:
- Find the
storage-methodor storage type setting and change it fromh2orsqlitetomysql. - Replace the connection placeholders with your credentials:
- Save the file.
- Restart your game server from the console to establish the database connection.
[!NOTE] Database provisioning is completely free and database storage does not count against your primary server disk allocation. However, we advise maintaining database hygiene by purging old logs periodically to ensure optimal query performance.