Re: The evolved Server Configuration Queston
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 35231
interpreted = N
texte = >>Has anyone found a way to pull this off without SQL? > >You can duplicate the original db's to other computers, then >duplicate all your appends, replaces and deletes on those computers >as well -- but this will not work reliably if the network connection >between any two computers fails for any reason, because then one or >more of the other computers will have their db's 'out of synch' with >the original. > >Ok so by doing this: Our website could be hosted simultaneously on our >machines which would be processing together into their own dbs, which would >have to be identical with one another.Yes, but this does NOT deal with running a single online store (via webcat's built-in eCommerce code) from multiple servers. This only deals with multiple db's on separate servers, not multiple shopping cart files on separate servers. >My questions are >1. Would this be a good way to handle heavy traffic using webcat, allowing >room for future growth?It depends upon the specific ways you intend to use webcatalog. >And 2.If one machine went down breaking the connection between the 2, could >you re-synch the db on the machine that went down by copying the db's from >the machine running and flush the databases to get it current again once >you've restarted?Yes, but that does not guarantee that a temporary network problem did not previously prevent an append, replace or delete from occurring in the other direction, thus causing the loss of data ... ================================ Kenneth Grome, WebDNA Consultant 808-737-6499 http://webdna.net ================================------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>>Has anyone found a way to pull this off without SQL? > >You can duplicate the original db's to other computers, then >duplicate all your appends, replaces and deletes on those computers >as well -- but this will not work reliably if the network connection >between any two computers fails for any reason, because then one or >more of the other computers will have their db's 'out of synch' with >the original. > >Ok so by doing this: Our website could be hosted simultaneously on our >machines which would be processing together into their own dbs, which would >have to be identical with one another.Yes, but this does NOT deal with running a single online store (via webcat's built-in eCommerce code) from multiple servers. This only deals with multiple db's on separate servers, not multiple shopping cart files on separate servers. >My questions are >1. Would this be a good way to handle heavy traffic using webcat, allowing >room for future growth?It depends upon the specific ways you intend to use webcatalog. >And 2.If one machine went down breaking the connection between the 2, could >you re-synch the db on the machine that went down by copying the db's from >the machine running and flush the databases to get it current again once >you've restarted?Yes, but that does not guarantee that a temporary network problem did not previously prevent an append, replace or delete from occurring in the other direction, thus causing the loss of data ... ================================ Kenneth Grome, WebDNA Consultant 808-737-6499 http://webdna.net ================================------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Kenneth Grome
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:
Server Creation - vendors (2005)
Separate SSL Server (1997)
displaying New products (Yikes! it's Fixed!) (1997)
Number of cars in cart... (2004)
Sorting problem (2002)
[encrypt] blues.... (2000)
Running _every_ page through WebCat ? (1997)
Updating Prices in Online Database (1999)
Help formatting search results w/ table (1997)
Date fun with MySQL (2004)
WebCat2 - Getting to the browser's username/password data (1997)
Summing fields (1997)
Orderfile (2005)
different show next (1997)
Secure server question (1997)
Trouble with formula.db (1997)
[AppendFile] problem (WebCat2b13 Mac .acgi) (1997)
shipcost (1997)
Previous and Next Solution (2004)
Help! WebCat2 bug (1997)