Ulysses

General => Off-Topic => Topic started by: Digital Spit on March 24, 2012, 09:28:48 AM

Title: Who hosts your SQL database?
Post by: Digital Spit on March 24, 2012, 09:28:48 AM

I'm new to sql and I'm tyring to get a database running for RP servers I run, anyone care to share some info on where they host theirs?

Title: Re: Who hosts your SQL database?
Post by: MrPresident on March 24, 2012, 11:11:55 AM

I host my own. :) There are really no GOOD free SQL hosts that I've been able to find. Usually the free ones are incredibly slow and you wouldn't want to use that on a game server. I've found in my experience that if you host your SQL on a different server than the game itself you'll run into trouble with lag and uptime. Make sure that any scripts you write are redundant and have a backup in case the database is unavailable. Also... try and use the multithreaded plugin if you can. The GmMySQL or whatever the popular (older) plugin is not multithreaded and will cause the server to hang if it doesn't get a good connection to the database.

Title: Re: Who hosts your SQL database?
Post by: JamminR on March 24, 2012, 01:30:13 PM

Definitely not free, but reasonable cost and decent customer service;
The Team Ulysses web site, forums, database and occasional other projects use Dreamhost. www.dreamhost.com.

I forget whethor or not when Megiddo/we host a Gmod server whether it's on Dreamhost or not. I don't think it is.

Title: Re: Who hosts your SQL database?
Post by: Digital Spit on March 24, 2012, 02:07:54 PM

I'll definately be looking into that! For now I found a suitable host, however I have a quick question. I got this error code while my database was being accessed by my gmod server

Code: [Select]

attempt to index local 'query1' (a nil value)

Title: Re: Who hosts your SQL database?
Post by: Megiddo on March 25, 2012, 08:45:46 AM

Quote from: Digital Spit on March 24, 2012, 02:07:54 PM

I'll definately be looking into that! For now I found a suitable host, however I have a quick question. I got this error code while my database was being accessed by my gmod server

Code: [Select]

attempt to index local 'query1' (a nil value)

We'd need to see the code to be of any help. :)

Title: Re: Who hosts your SQL database?
Post by: Digital Spit on March 27, 2012, 06:54:29 AM

Well, would you like the whole _MySQL file?
I'm perfectly fine with giving it :)

Title: Re: Who hosts your SQL database?
Post by: JamminR on March 27, 2012, 07:09:37 PM

No, but all or a major portion of the lua file calling the database would be handy.