Database Backends

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

Database Backends

Post by Masher » Fri Jun 27, 2008 9:51 am

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 on the 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
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 game server, 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 and 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.

Need an affordable web control panel? Try UGCC.

Post Reply