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:

Showif, Hideif reverse logic ? (1997) Assigning new CART number (1997) ooops...WebCatalog [FoundItems] Problem - LONG - (1997) Generating Report Totals (1997) Snake Bites (1997) [shippingtotal] & Formulas.db prob (2003) Trouble with formula.db + more explanation (1997) WebCat for mass emailings (1997) Webcat bannersleuth Qs (2001) SQL statements (2002) Database Repopulation (2004) Sorting ip addresses (2002) Attn: Bug in GeneralStore example b15 (1997) Re:2nd WebCatalog2 Feature Request (1996) unable to launch acgi in WebCat (1997) Search returns all, not 20 (1997) Multiple prices (1997) SKU lookup (1997) Which GUI HTML editors work with WC ? (1997) Shared conversion under WebTen (1998)