Users in MySQL Database

Talk about pretty much anything here, but DO NOT USE FOR SUPPORT.

Moderator: Supporters

Posts: 5
Joined: Fri Nov 05, 2010 11:26 pm

Users in MySQL Database

Post by Cooldude170 » Sat Nov 06, 2010 1:01 am

It would be better if the users were stored in a remote MySQL database rather than on the host computer.
Anyone agree, disagree? Explain why or why not.

Head of Support
Posts: 2086
Joined: Tue Jun 15, 2004 8:50 pm
Location: Chino Hills, CA, US

Re: Users in MySQL Database

Post by Stealth » Sat Nov 06, 2010 7:17 am

Storing any kind of database is always better on the host system when possible. There are very few applications or reasons when running a daemon that would be more efficient or secure by putting a database on a separate host than the host needing to read/store information in that database.

Official supporter
Posts: 1124
Joined: Sun Apr 18, 2004 5:06 pm

Re: Users in MySQL Database

Post by katsklaw » Sat Nov 06, 2010 6:25 pm

In any case though, latency will not be your friend. I'ts always faster to read/write to memory than querying a file each time. Inherently services that load user information from a flat file and "dump" information back to the file at intervals will generally see better performance than querying a db/file for each record, making the db remote makes it even slower. One should be careful when choosing which method as some applications that shall remain anonymous will hang until the task is complete, which can cause desyncs between services, crashes and ping timeouts of daemons.