Many game servers require databases to store player data, statistics, and configurations. This guide will help you manage your server’s databases.
Creating a Database
1
Navigate to Databases
Click on the Databases tab in your server’s control panel
2
Create New Database
Click the New Database button at the top of the page
3
Configure Database
Enter a name for your database (e.g.,
my_server_db)Database names should be lowercase and can include underscores
4
Create Database
Click Create Database to finalize the creation
Connecting to Your Database
1
Get Connection Details
Click the eye icon next to your database to view details
2
Copy Credentials
Use the copy buttons to get:
- Endpoint: The server address and port
- Username: Your database username
- Password: Your secure password
- Database: The database name
3
Update Configuration
Add these details to your game server’s config file:
Database Operations
Resetting Password
Resetting the password will disconnect any active connections. Make sure to update your server configuration immediately after.
1
Open Database Details
Click the eye icon next to your database
2
Rotate Password
Click the Rotate Password button
3
Update Configurations
Copy the new password and update all server configs using this database
Deleting a Database
Deleting a database is permanent and cannot be undone. All data will be lost!
1
Click Delete
Click the trash icon next to the database
2
Confirm Deletion
Type the full database name to confirm
3
Delete
Click Delete Database to permanently remove it
Common Use Cases
Multiple Game Modes
Multiple Game Modes
Create separate databases for different game modes:
survival_db- For survival world datacreative_db- For creative world dataminigames_db- For minigame statistics
Plugin Databases
Plugin Databases
Many plugins require their own database:
- Economy plugins: Store player balances
- Permission plugins: Store ranks and permissions
- Logging plugins: Store player actions
Website Integration
Website Integration
Connect your game server to a website:
- Player statistics pages
- Online shops
- Forum integrations
- Vote systems
Troubleshooting
Connection Refused
Connection Refused
Problem: Can’t connect to databaseSolutions:
- Verify the endpoint address is correct
- Check if the port is included in the connection string
- Ensure password hasn’t been changed
- Confirm database hasn’t been deleted
Access Denied
Access Denied
Problem: Authentication failedSolutions:
- Double-check username and password
- Try rotating the password
- Ensure you’re using the database-specific credentials
- Check for special characters that need escaping
Too Many Connections
Too Many Connections
Problem: Connection limit reachedSolutions:
- Restart your game server to close stale connections
- Check for plugins creating excessive connections
- Contact support to increase connection limit
- Implement connection pooling in your plugins
Best Practices
Regular Backups
Export your database regularly, especially before major updates
Secure Passwords
Use the auto-generated passwords and rotate them periodically
Connection Pooling
Configure plugins to reuse connections instead of creating new ones
Monitor Usage
Keep an eye on database size and query performance