Re: synching databases on multiple servers
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 14635
interpreted = N
texte = >I am still wondering about this post from yesterday. Can someone >suggest how(/if?) WebCat solutions are scalable over multiple servers? >Turning away traffic is not a good thing... > >Thanks! > > >Our WebCat server is getting slammed big time and we need to increase >our capacity ASAP. We'd like to use the Men and Mice/WebStar plug in for >fault tolerance and load balancing. Our databases change often, though, >and by people outside our organization. We need to keep the databases in >synch between the 2 servers whenever a record is added, deleted or >modified. > >Anyone have ideas about the best way to do this? > >Karl Schroll >Digital FrontierThe fastest thing to do is to move non webcat sensative traffic to a different box -- like graphics....Beyond that there are lots of directions to go, but with the databases changing that often you would need to make one the master and the others only pull the info -- I would need to know more about the specific setup to offer a more complete description -- Again - moving the graphics to another box is the simplest and usually more than enough.... Jay Van Vark ******************************* Pacific Coast Software | eCommerce (WebCatalog) 11770 Bernardo Plaza Court | Site Hosting & Development Suite 453 | http://www.smithmicro.com San Diego, CA 92128 ******************************* 619.675.1106** PGP key available upon request. **
Associated Messages, from the most recent to the oldest:
>I am still wondering about this post from yesterday. Can someone >suggest how(/if?) WebCat solutions are scalable over multiple servers? >Turning away traffic is not a good thing... > >Thanks! > > >Our WebCat server is getting slammed big time and we need to increase >our capacity ASAP. We'd like to use the Men and Mice/WebStar plug in for >fault tolerance and load balancing. Our databases change often, though, >and by people outside our organization. We need to keep the databases in >synch between the 2 servers whenever a record is added, deleted or >modified. > >Anyone have ideas about the best way to do this? > >Karl Schroll >Digital FrontierThe fastest thing to do is to move non webcat sensative traffic to a different box -- like graphics....Beyond that there are lots of directions to go, but with the databases changing that often you would need to make one the master and the others only pull the info -- I would need to know more about the specific setup to offer a more complete description -- Again - moving the graphics to another box is the simplest and usually more than enough.... Jay Van Vark ******************************* Pacific Coast Software | eCommerce (WebCatalog) 11770 Bernardo Plaza Court | Site Hosting & Development Suite 453 | http://www.smithmicro.com San Diego, CA 92128 ******************************* 619.675.1106** PGP key available upon request. **
Jay Van Vark
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Shop from PDF (2004)
Grouping fields problem (1998)
Add Unit Ship Cost to Cart (2000)
WebDNA maxing out processor (2008)
Loops N Variables (1998)
Re:Emailer and encryption (1997)
locking variables? (2000)
webdelivery not working (1998)
calculate age (2003)
SetMIMEHeader ATTN:John P. (2001)
[Announce] Newest Commerce Site based on WebCatalog (1997)
Searchable list archive (1997)
Root Folder problems cont. (1998)
webcat2b12 CGI -- Date comparisons (1997)
[ConvertChars] problem (1997)
Erotic Sites (1997)
WebDNA quitting (2008)
OK, here goes... (1997)
Zip Code Lookups (1999)
SpiderBotLock! (2003)