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?