Database Backends

Post Reply
Masher
Site Admin
Posts: 3612
Joined: Thu Apr 20, 2006 2:54 pm
Location: America's Heartland
Contact:

Database Backends

Post by Masher »

UGCC supports two backends. Which one you should use depends solely on your setup. I'll list the backends available, pros/cons, and what environment it's best used for. Knowing which one to use intially is important. Having to change backends after installing is not a trivial task.

Sqlite
Description: An open source light weight database.
Pros: Easy to setup and works with both Windows and Linux
Cons: Only accessible from the local computer, can't be used for remote servers
Who should use it: If you only have one physical computer you want to manage game servers on.
Considerations: If you plan or think you may someday add another server that will be managed by the panel (remotes/slaves); you may just want to start off with MySQL.

MySQL (applies to MariaDB as well)
Description: MySQL is an open-source SQL server.
Pros: Fast, accessible by any computer. Windows or Linux.
Cons: Another server to setup and if the MySQL server is installed on a computer hosting game servers it may tie up some resources
Who should use it: If you have 2 or more computers to manage, this is the recommended backend to use. Master/Slave mode depends on this backend.
Masher
-----------
Please do not PM me unless asked to! We are a small company. If you have an issue or question it would be best to post it in the forums where it can help others in the future.

NEW Join our Discord!
Post Reply