Re: Database load balancing

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 40671
interpreted = N
texte = Alisha Outridge wrote: > Any suggestions on how to do realtime load balancing WebDNA databases on > multiple servers?It completely depends on how your data is structured. If your reference databases are all static (i.e. no updates online), you can maintain a single server as the master and push out the databases using rsync or something similar. You can also have the databases stored on a shared drive iff the databases themselves are completely static.Then your few non-static databases (like customers.db) can be stored in a single SQL database or you can have updates flow from site to site (this can be a problem if one server goes down) via [tcpconnect].WebCatalog is a RAM-based database, first and foremost. Since two machines cannot share RAM, you cannot do load balancing like you can for purely static sites.John-- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5747 ------------------------------------------------------------- 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)
Alisha Outridge wrote: > Any suggestions on how to do realtime load balancing WebDNA databases on > multiple servers?It completely depends on how your data is structured. If your reference databases are all static (i.e. no updates online), you can maintain a single server as the master and push out the databases using rsync or something similar. You can also have the databases stored on a shared drive iff the databases themselves are completely static.Then your few non-static databases (like customers.db) can be stored in a single SQL database or you can have updates flow from site to site (this can be a problem if one server goes down) via [tcpconnect].WebCatalog is a RAM-based database, first and foremost. Since two machines cannot share RAM, you cannot do load balancing like you can for purely static sites.John-- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5747 ------------------------------------------------------------- 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/ John Peacock

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:

Problems getting parameters passed into email. (1997) shipcost (1997) WebCat b15 Mac plug-in (1997) no global [username] or [password] displayed ... (1997) Separate SSL Server (1997) Seed encrypt/decrypt code error or bug? (1999) Tiny Store (1998) Results table formatting (2003) FAX solutions? (FaxBee) (2001) Page Breaks in Word (2003) Error Lob.db records error message not name (1997) carriage returns in data (1997) Search wbrk (repost) (2001) Rollovers (1999) Preloading code? (2002) First postarg not taking in $Commands (1997) Newbie questions (1999) Protect vs Authenicate (1997) Help name our technology! I found it (1997) Help Encrypt/Decrypt eMail (2003)