mysql

[thebillionaire]

I had a question with my sql I was making a game and am using mysql for the user data base, but I was wondering if there is a way to load the data in the mysql from another server. So one server has the game and another server has the mysql database can I first server read the data from the second?

[MarkB]

Sorry to be anal, but this should be in the Website Programming & Databases (http://www.websitepublisher.net/forums/forumdisplay.php?f=25) forum.

[Chris]

Yes. You can query MySQL servers remotely. However this takes longer and you may see performance issues.

[chromate]

Mark's right. But it'll get moved anyway, so what the heck I'll reply. :)

Yes, you can host the database on another server. Just use the address of the server as the "host" parameter when you use mysql_connect. Depending on how the mysql server is set up, you may need to register the requesting server's IP address with the mysql server. You should be able to find this in cpanel (if that's what you're using). Also be aware that some, but probably a minority of, hosts choose to deny any requests from remote servers for security reasons.

[Mike]

Yes, I think you can add another address/ip in cpanel for mysql.

[MarkB]

If you're using dual servers, make sure they're directly connected to cut down on lag between them - many busy servers use multiple servers (ie clusters).

[thebillionaire]

If you're using dual servers, make sure they're directly connected to cut down on lag between them - many busy servers use multiple servers (ie clusters).

what do you mean by directly connected.

[AndyH]

what do you mean by directly connected.

That there is a network cable from the front end server to the database server. This will make it pretty much as fast if the webserver and the database were on the same machine.

If not, it means that the data has to go through switches, routers and maybe even different networks (depending on where the other server is). This is when you will see lag.

[thebillionaire]

See Im making a game and when people sign up they will be registered onto a mysql database, on a server but there are going to be multiple servers so is there a way to allow all servers to save with one sign up and ever time the usersaves all the other mysql save the data, will this be faster or only my sql. Would Microsoft Access be better at saving alot of variables or mysql?

[intelliot]

in general, MySQL is better for most applications.

[MarkB]

This is really a question you should ask a hosting company - they'd be better suited to tell you what would be best when designing a server cluster for this kind of application.

[thebillionaire]

Thanks for the help