Neil, in theory, this should work fine, given sufficient bandwidth between the two sites.
In practice, if it is a high traffic site generating a large number of connections, or a high traffic site pulling large pieces of data (BLOBs or TEXT) from the remote database, you may find performance to be unacceptable. Latency to establish a connection will be slightly higher, on a "busy internet day" possibly noticeable to end uers. You'll have to be sure you open up any firewalls and also MySQL's own access control to your remote server. Some ISPs prohibit connections like this, so check with yours - would be disappointing for sure to build it all then get a call saying "cease and desist; read our acceptable use policy". Dan On 8/10/06, Neil Tompkins <[EMAIL PROTECTED]> wrote:
Hi We have a mysql database hosted with a IIS server on the same network accessible over the Internet. Now we want to set-up a new website with another ISP therefore located in a different datacenter. Has anyone had any experience of this. What performance issues would I get if I access the database from the other datacenter across the Internet ? Thanks Neil _________________________________________________________________ Be one of the first to try Windows Live Mail. http://ideas.live.com/programpage.aspx?versionId=5d21c51a-b161-4314-9b0e-4911fb2b2e6d
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
