Database hosts

Add MySQL, MariaDB or PostgreSQL hosts that users create server databases on, scope them to a node, install phpMyAdmin, and run panel migrations.

Database hosts are the MySQL, MariaDB or PostgreSQL servers that users create databases on for their game servers. The panel itself uses its own database, which you set up during installation; this page is about the hosts for customers.

Preparing a host

Create an account the panel can log in with from the panel machine. It must be able to create databases and users and grant privileges, because each server database gets its own user with GRANT ALL PRIVILEGES on that database. For MySQL or MariaDB:

CREATE USER 'featherpanel'@'PANEL_IP' IDENTIFIED BY 'a-long-password';
GRANT ALL PRIVILEGES ON *.* TO 'featherpanel'@'PANEL_IP' WITH GRANT OPTION;
FLUSH PRIVILEGES;

Server database users are created for %, so the database must listen on an address game servers can reach, not only 127.0.0.1. Firewall the port to the hosts that need it.

Adding a host

Admin area, Node Databases (or Manage node databases on a node), Add Database:

• Database Name, a label for the host.
• Database Type: MySQL, MariaDB or PostgreSQL.
• Host and Port (3306 for MySQL and MariaDB, 5432 for PostgreSQL).
• Database Hostname (optional), shown to users in their credentials instead of the host.
• Username and Password.
• Availability. All nodes (global) shows the host to every server. Single node only shows it to servers on that node, and new databases on that node go there. You can also scope a host to a FeatherQuilld web node for WebSpaces.

Check Health tests the connection. To change the password later, fill it in; leaving it blank keeps the current one.

How many databases a server can create is its Database Limit, set on the server’s Limits tab.

Database Management

Admin area, Database Management covers the panel’s own database:

• Engine version, uptime, queries per second, connections and network counters.
• Run Migrations applies pending schema changes after an update or plugin install and shows the output. Back up first.
• Install phpMyAdmin. After that every database in the panel gets an Open in phpMyAdmin button, so users can manage tables and import dumps in the browser. Delete phpMyAdmin removes it again.

API