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:
Searching multiple fields (1997)
weight based shipping cost questions (1997)
Custom formulas.db (1998)
OT: Digger (2007)
URGENT! ACGI Stopped!!!! (1997)
Multiple prices (1997)
Country & Ship-to address & other fields ? (1997)
I hate talking to myself on this list (2004)
How do you TEAM Code? (2004)
Closing databases (2003)
problems with 2 tags (1997)
Snake Bites (1997)
too many nested tags ... (1997)
Other Databases, access, filemaker etc. (2000)
[Replace] (2000)
how does [middle] work? (1998)
New commands in Final candidate (1997)
can WC render sites out? (1997)
Off Topic: Help Wanted (1997)
Integrating Bar Codes with WebDNA (2006)