Results 1 to 12 of 12

Thread: mysql

  1. #1
    Senior Member thebillionaire's Avatar
    Join Date
    Apr 2004
    Posts
    746

    mysql

    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?

  2. #2
    Web Monkey MarkB's Avatar
    Join Date
    Nov 2003
    Location
    London, UK
    Posts
    1,783
    Sorry to be anal, but this should be in the Website Programming & Databases forum.
    Stepping On Wires - the new blog

  3. #3
    Administrator Chris's Avatar
    Join Date
    Feb 2003
    Location
    East Lansing, MI USA
    Posts
    7,055
    Yes. You can query MySQL servers remotely. However this takes longer and you may see performance issues.
    Chris Beasley - My Guide to Building a Successful Website[size=1]
    Content Sites: ABCDFGHIJKLMNOP|Forums: ABCD EF|Ecommerce: Swords Knives

  4. #4
    Senior Member chromate's Avatar
    Join Date
    Aug 2003
    Location
    UK
    Posts
    2,348
    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.

  5. #5
    Registered Mike's Avatar
    Join Date
    May 2003
    Location
    UK
    Posts
    2,755
    Yes, I think you can add another address/ip in cpanel for mysql.
    Don't you just love free internet games ?

  6. #6
    Web Monkey MarkB's Avatar
    Join Date
    Nov 2003
    Location
    London, UK
    Posts
    1,783
    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).
    Stepping On Wires - the new blog

  7. #7
    Senior Member thebillionaire's Avatar
    Join Date
    Apr 2004
    Posts
    746
    Quote Originally Posted by 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).
    what do you mean by directly connected.

  8. #8
    Senior Member AndyH's Avatar
    Join Date
    May 2004
    Location
    Australia
    Posts
    553
    Quote Originally Posted by thebillionaire
    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.
    New website released. ya rly!

  9. #9
    Senior Member thebillionaire's Avatar
    Join Date
    Apr 2004
    Posts
    746
    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?

  10. #10
    Registered intelliot's Avatar
    Join Date
    Jul 2004
    Posts
    309
    in general, MySQL is better for most applications.
    Elliot Lee
    Google Forums - Community for Google Fans!

  11. #11
    Web Monkey MarkB's Avatar
    Join Date
    Nov 2003
    Location
    London, UK
    Posts
    1,783
    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.
    Stepping On Wires - the new blog

  12. #12
    Senior Member thebillionaire's Avatar
    Join Date
    Apr 2004
    Posts
    746
    Thanks for the help

Similar Threads

  1. Excluding rows in a MySQL Query
    By nlvp in forum Website Programming & Databases
    Replies: 4
    Last Post: 06-15-2004, 08:41 AM
  2. Problem inserting into MySQL
    By mobilebadboy in forum Website Programming & Databases
    Replies: 10
    Last Post: 05-10-2004, 08:16 PM
  3. MySQL driven AWS site
    By Best.Flash in forum User Owned Websites
    Replies: 9
    Last Post: 03-27-2004, 11:04 AM
  4. MySQL crashed
    By Chris in forum Site and Forum Feedback
    Replies: 3
    Last Post: 03-23-2004, 11:22 AM
  5. PHP - MySQL Portal software
    By manonthestreet in forum Website Programming & Databases
    Replies: 3
    Last Post: 10-27-2003, 01:23 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •