Slightly OT - SQL- Clustering

This WebDNA talk-list message is from

2006


It keeps the original formatting.
numero = 66721
interpreted = N
texte = For me, the confusing thing about clustering multiple servers is understanding how the cluster handles huge loads. Is the general idea that user sessions are distributed to and maintained with one of multiple servers? If that is the case, does each server have a synchronized copy of the database(s), or are there multiple web servers all accessing a single SQL server? Perhaps there can be a web cluster that interacts with an SQL cluster. I've been blissfully ignorant about these things because I haven't hit the wall with WebDNA like Ken has. I guess the gist of my question is simply how difficult is it to deal with a cluster of database servers versus a single server? ------------------------------------------------------------- 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://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Slightly OT - SQL- Clustering ( Adam O'Connor 2006)
  2. Re: Slightly OT - SQL- Clustering ( Clint Davis 2006)
  3. Slightly OT - SQL- Clustering ( Pat McCormick 2006)
For me, the confusing thing about clustering multiple servers is understanding how the cluster handles huge loads. Is the general idea that user sessions are distributed to and maintained with one of multiple servers? If that is the case, does each server have a synchronized copy of the database(s), or are there multiple web servers all accessing a single SQL server? Perhaps there can be a web cluster that interacts with an SQL cluster. I've been blissfully ignorant about these things because I haven't hit the wall with WebDNA like Ken has. I guess the gist of my question is simply how difficult is it to deal with a cluster of database servers versus a single server? ------------------------------------------------------------- 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://webdna.smithmicro.com/ Pat McCormick

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:

Text variables do not show (1999) RequiredFields template (1997) Separate SSL Server (1997) sending formatted e-mail? (1998) Multiple fields on 1 input (1997) WebCat2b15MacPlugin - showing [math] (1997) Orders coming up blank (2004) emailer (1997) Web Catalog 2 demo (1997) Many $WebCat.exe processes (1998) Limitations on fields? Server is crashing (1997) RE: 2nd WebCatalog2 Feature Request (1996) Add more fields to an existent data base (1997) possible, WebCat2.0 and checkboxes-restated (1997) Banner Ads (2000) alternatives for WebDNA (2004) [cart] how is it generated (2002) [searchString] (1997) I assume it is a safe bet this does not help (1998) Removing [showif] makes a big difference in speed (1997)