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 thatreplicates it's data on a regular basis to the slaves. You could also submitevery SQL transaction to every SQL server, but this seems like a waste ofresources.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:
When dealing with a cluster of SQL servers, you have to have a master thatreplicates it's data on a regular basis to the slaves. You could also submitevery SQL transaction to every SQL server, but this seems like a waste ofresources.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:
Add htmlarea 3 to SiteBuilder (2004)
[Reload mydata.db] (1998)
MacAuthorize order data fields WAS:How To question... (1997)
Shipping charges (1998)
Great product and great job ! (1997)
Menu to select product variations (1997)
Autonumber (2003)
Math Problem - Format? (1997)
Problems with date math (1997)
More on the email templates (I like it) (1997)
Webcat & SIMS (1998)
setting values (1998)
unable to launch acgi in WebCat (1997)
Banner DNA (1997)
[lookup] vs. [search] (1998)
shownext (1997)
process SSI (1998)
WebCat2: multiple currency support (1997)
File Upload (1997)
Internet Advancement (2003)