Re: Database load balancing

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 40670
interpreted = N
texte = Put everything into a back end sql database and then have 'triggers' (not in the sense of normal webcat triggers) that whenever the data in the back end db changes you update the data in the live webcat databases. This is what I am moving toward.Or you could do similar without the sql database by having your update/add/remove code call a file on the other server(s) while passing the data to them.But I like the back end sql idea better (if you can support this) as then you have your data all in one place and you could reduce the complexity of your webcat databases to contain on that data that is searchable and whatever is needed to join any databases together.Daleon 18/6/02 3:19 pm, Alisha Outridge at Alisha@specsimple.com wrote:> Any suggestions on how to do realtime load balancing WebDNA databases on > multiple servers? > > Curious to hear other's solutions and thoughts on this subject. ------------------------------------------------------------- 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:

    
  1. Re: Database load balancing (John Peacock 2002)
  2. Re: Database load balancing (drt - lists 2002)
  3. Database load balancing (Alisha Outridge 2002)
Put everything into a back end sql database and then have 'triggers' (not in the sense of normal webcat triggers) that whenever the data in the back end db changes you update the data in the live webcat databases. This is what I am moving toward.Or you could do similar without the sql database by having your update/add/remove code call a file on the other server(s) while passing the data to them.But I like the back end sql idea better (if you can support this) as then you have your data all in one place and you could reduce the complexity of your webcat databases to contain on that data that is searchable and whatever is needed to join any databases together.Daleon 18/6/02 3:19 pm, Alisha Outridge at Alisha@specsimple.com wrote:> Any suggestions on how to do realtime load balancing WebDNA databases on > multiple servers? > > Curious to hear other's solutions and thoughts on this subject. ------------------------------------------------------------- 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/ drt - lists

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:

Country & Ship-to address & other fields ? (1997) Pricing based on quantity (2000) Requiring that certain fields be completed (1997) suffix mapping for NT? (1997) [OT] Trying to steal databases on our server (2003) HTML Editors (1997) SiteGuard Admin Feature ? (1997) Emailer (1997) Bad Cookie / Internet Option / Internet Explorer (2004) [WebDNA] What is the diff. btwn. Commerce & Enterprise edition? (2008) Emailer again & again (1997) WebCat editing, SiteGuard WAS:SiteAssociative lookup style? (1997) help testing quicktime delivery (1997) [WebDNA] Math variable name length limitations ... (2012) NetSplat and WebCat2 (1997) WebCatalog on Windows 98 (2000) problems with 2 tags (1997) WebDNA 6 (2004) WebCommerce: Folder organization ? (1997) For you expert WebDNA coders (was Interesting speed (2003)