Connecting to MYSQL on PC or Via website?

Neonyo · **Joined:** Sat Jun 23, 2007 9:42 pm **Posts:** 151

Finally ready to host a Test of my game, but im curious on what would be the best way to do it. My webhost has SQL database enable should i upload my database through the website and use it? OR should i Just host both the Server and mysql off my computer?

THough I have Tried to host it through my website. Following the wiki instructions, I got the database to boot up from my computer but still cant get the client to connect.

ANyway wanna get your opinions and help on which way would be best?

Kyori · **Posted:** Sun Mar 22, 2009 4:16 am

You'll save bandwidth by hosting the database on the same machine as the gameserver, that's probably the best way to do it.

It'll most likely not make a huge difference to the people playing it, because as Darkfrost pointed out in a recent post, the gameserver doesn't use the database too often.

Neonyo · **Joined:** Sat Jun 23, 2007 9:42 pm **Posts:** 151

Im using the ulitamte plan for Godaddy.com so unlimited everything, just trying to figure out the best way for a dedicated 24/7 server

Darkfrost · **Posted:** Sun Mar 22, 2009 4:43 am

It doesn't really matter. It depends how you want it set up.

With SVO, we opted to having it on our webhosting, that way, if the main server went down (Which it did quite often...) we could just throw up another server (no-ip ip could be changed) it was also faster for VBGoreSP, which was nice.

However, if you keep it in the main server, it's a tiiiiny bit faster. It really makes no difference, just pick whichever is more convenient for you.

Neonyo · **Joined:** Sat Jun 23, 2007 9:42 pm **Posts:** 151

I was thinking that too, if for somereason the puter with the database went down could always just boot a new server and the database is saved online...think that is how i will do it. So i got it to connect to the remote SQL server, but i can get the client to connect to it. I went into the client VB and changed the IP to the blahblah.com but nothin says not connect to the net or the server is down.

I have remote connect enable(of course)

how did u get it with SVO?

Darkfrost · **Posted:** Sun Mar 22, 2009 6:15 am

The client doesn't connect to the sql server, it connects to the gameserver.

Neonyo · **Joined:** Sat Jun 23, 2007 9:42 pm **Posts:** 151

Oh im a dumbass then lol so i would just set up a DNS on my host to forward to my IP addy for the client right

anyone ever used godaddy to host they give me this

Quote:

To create a new A record for this zone file, please enter the Host Name, "Points To" IP Address, and TTL in the fields below; then click "Continue."
An A record . short for address record . is a record within a zone file that maps a domain name to an IP address. Thus, you can use an A record to indicate the IP address you want your domain or subdomain to point to. Also referred to as a host or host name. For example, if you want your domain "domainnamegoeshere.com" to point to your home computer (whose IP address is, for example, 172.0.0.1), the A record would list "domainnamegoeshere.com", or "@" as the host and "172.0.0.1" as the "Points To" IP address. Entering "@" will automatically insert your domain name as the host name for the A Record. If the A Record is for the domain "www.domainnamegoeshere.com", the host name should be entered as "www".
Do not enter "www.domainnamegoeshere.com" as the host name for an A Record.
You can create a wildcard A record by setting the Host Name value to "*" (asterisk). The wildcard causes the server to respond with the IP address specified instead of an error if the subdomain queried does not exist within your zone file.

so totaly lost :p

vbGore Free Online RPG Engine

Connecting to MYSQL on PC or Via website?