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:
Error Messages Returned to User (1997)
Integration? (1999)
Occasional crashes with $remove (1997)
.txt file (2000)
Saving Text Areas with Orders (1997)
WebCat2 Append problem (B14Macacgi) (1997)
Languages (1997)
URL too Long? (1997)
Searching for words equal to A or equal to B (1999)
Don't do this! (was: Crashing Type 3) (1999)
Searching multiple Databases (1997)
WebCatalog 2.0 & WebDNA docs in HTML ... (1997)
WebCatalog NT beta 18 now available (1997)
WebCat2 several catalogs? (1997)
Protecting Files (2005)
setitems, one more thing (1997)
Multiple serial numbers (1997)
[OT] Happy Turkey Day! (2003)
Help name our technology! (1997)
Location of Browser Info.txt file (1997)