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:

[search] in formulas.db (1997) same products but different (1998) Help name our technology! I found it (1997) Some Questions (1997) Pacific Coast Software responsiveness (was WebMerchant - MacAuthorize) (1999) Protect vs Authenicate (1997) template not found error (1998) SV: Text in coloums... (2000) Webcatalog acgi conflict? (1999) [LOOKUP] (1997) form image (2000) [WebDNA] Integration with QuickBooks (2011) WebMerchant 1.6 and SHTML (1997) Listserver problem (1997) [WebDNA] WebDNA receiving numerous signal SIGSEGV then crashing (2016) textarea data entry and display (2000) using showpage and showcart commands (1996) WebCat2b12 CGI Mac -- Problems propagating the cart through frames...still (1997) [WebDNA] Error 500 with SUMM=T (2017) rn doesn't work on date fields (1998)