Re: Slightly OT - SQL- Clustering

This WebDNA talk-list message is from

2006


It keeps the original formatting.
numero = 66722
interpreted = N
texte = When dealing with a cluster of SQL servers, you have to have a master that replicates it's data on a regular basis to the slaves. You could also submit every SQL transaction to every SQL server, but this seems like a waste of resources. On 4/4/06 7:46 AM, "Pat McCormick" wrote: > 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)
When dealing with a cluster of SQL servers, you have to have a master that replicates it's data on a regular basis to the slaves. You could also submit every SQL transaction to every SQL server, but this seems like a waste of resources. On 4/4/06 7:46 AM, "Pat McCormick" wrote: > 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/ Clint Davis

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:

Cart Database (1999) BBEdit and WebCatalog 2.0? (1997) Transferring textareas (1997) RE: Automatic thumbnail images (1998) If Empty ? (1997) WebCat2 several catalogs? (1997) [WebDNA] [table] and COMMA in a Field (2015) RE: E-mailer error codes (1997) Interfacing WebMerchant to www.fedex.com (1997) headers (2004) Hello??? (1997) Uniqueness of [cart] - revisited (2004) WebCatalog for guestbook ? (1997) Searching for all records (1998) Email and name capture (1999) RE: ASP and Web DNA (1998) Secure server question (1997) Bug or syntax error on my part? (1997) Look out kiwis! (2003) Multiple Passwords (1997)