SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Evangelist
    Join Date
    Mar 2011
    Posts
    418
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Database Hosted On A Different Server To Web Site

    Hi,

    I have just added a MySQL Database to my web site hosted at GoDaddy.co.uk. I have never had any issues with the hosting of the web site, which is accessed as normal using FTP, as you would imagine.

    However, the MySQL Database is stored at a different server to my web site. I had previously understood from tutorials at YouTube that all files would be saved to my server, implying it would be located the same place as my web site.

    If I continue to use this service with the Database at a different server to my web hosting could I find limitations with what I can do?

    Is this standard practice for hosting a database? What problems could I run into?

    Matt.

  2. #2
    SitePoint Enthusiast bfpseller's Avatar
    Join Date
    Aug 2010
    Location
    USA
    Posts
    24
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Are these two servers belonged to a same host company or in general connected together through a broad-band network.

    If yes, you have nothing to worry
    If no, you should check insert/read data from the two servers concurrently to see if the speed is acceptable.

    In short, get both at one hosting company. Easy to support, maintain and troubleshooting

  3. #3
    Programming Since 1978 silver trophybronze trophy felgall's Avatar
    Join Date
    Sep 2005
    Location
    Sydney, NSW, Australia
    Posts
    16,608
    Mentioned
    24 Post(s)
    Tagged
    1 Thread(s)
    Having the database on a different server to the web site is a common practice. That's why there is a parameter when you connect to the database to identify what server it is on. As long as the configuration is set up correctly so that there is no firewall preventing access from one to the other there should be no problems.

    GoDaddy set up all their databases that way so they should have the database servers and web servers configured correctly to be able to access one another.
    Stephen J Chapman

    javascriptexample.net, Book Reviews, follow me on Twitter
    HTML Help, CSS Help, JavaScript Help, PHP/mySQL Help, blog
    <input name="html5" type="text" required pattern="^$">


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
  •