At the moment our mysql server hosted by an ISP, is updated every second by a program running on our local Internet connection from our own office network. We have seen no performance issues from our websites hosted by the same ISP running our mySQL server. My question is because of this remote update, would we see a problem if we queried the mysql database from webpages from another ISP ?
> Date: Thu, 10 Aug 2006 16:09:29 -0500> From: [EMAIL PROTECTED]> To: [EMAIL > PROTECTED]> Subject: Re: Access mySQL database across Internet> CC: > mysql@lists.mysql.com> > A good point to make here is that averages are > generally a poor> calculation to use when planning for load, since your > systems have to> handle the peaks as well as the average. I know this, > fought a number> of fights over it at my last job - don't know why I just > quoted you> averages!> > If 99% of your 1000 hits occur between 7:59 AM and > 8:01 AM (some sort> of workday login validaton system perhaps ) then > obviously you need to> handle as many as 500 a minute or more. So it may > vary from average> quite a bit based on your peak times - that will be good > information> to research as part of your planning process.> > Dan> > > On > 8/10/06, Dan Buettner <[EMAIL PROTECTED]> wrote:> > No, 1000 hits / day isn't > terribly high traffic, if you're serving> > pretty normal "stuff". That > averages out to a hit every 32 seconds or> > so during the course of an 8 to > 5 business day, a hit every 86 seconds> > or so in a full day. No problems > at that level.> >> > When you get to 1000 hits / minute, then you're talking > high traffic!> >> > Dan> >> > On 8/10/06, Neil Tompkins <[EMAIL PROTECTED]> > wrote:> > > 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> >> >> > -- > MySQL > General Mailing List> For list archives: http://lists.mysql.com/mysql> To > unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]> _________________________________________________________________ Be one of the first to try Windows Live Mail. http://ideas.live.com/programpage.aspx?versionId=5d21c51a-b161-4314-9b0e-4911fb2b2e6d
