What would you assume to be high traffic ? 1000 hits per day or more ?
> Date: Thu, 10 Aug 2006 13:05:11 -0500> From: [EMAIL PROTECTED]> To: [EMAIL > PROTECTED]> Subject: Re: Access mySQL database across Internet> CC: > mysql@lists.mysql.com> > 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> > > _________________________________________________________________ Be one of the first to try Windows Live Mail. http://ideas.live.com/programpage.aspx?versionId=5d21c51a-b161-4314-9b0e-4911fb2b2e6d
