Re: Same Database needed on two machines

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 40962
interpreted = N
texte = On master site, create a page that simply returns the contents of the database, verbatim - just [include file=the.db].On slave site, create a trigger that does a [tcpconnect] to the above page on the master site, then replaces the database with the new data (closedatabase, then writefile). Have the trigger fire as often as you like.- brianAt 8:44 AM 6/26/02, Jeff Logan wrote: >No the traffic will be really low. Now way of just ftping the file >over with some other utility, this just seems to be the best option >I can think of with out having to develop a ton of new code. > >Jeff Logan > >>Start with the database(s) on each machine. Then on the machine >>that allows updates - write into your update code a process that >>will also update or add the new data to the second machine. >> >>Is the expected traffic so high that your machine can't handle the load? >> >>On Tue, 25 Jun 2002 15:24:21 >>Jeff Logan wrote: >>> >On 6/25/02 3:17 PM, Jeff Logan wrote: >>>> >>>>> >>>>>What other ideas then? >>>> >>>>Having everything on one server and [tcpconnecting] to a >page >>>>that displays >>>>the data you want on the other one? >>>> >>> >>>This will work but tons of extra coding to do. Just moving the >>>database every 12 hours is what I need. Any ideas from anyone >>>else? >>>Jeff >>> >> >>------------------------------------------------------------- >>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/ > > > >InsideOut Marketing and Web Solutions - 229 South Sequim Ave, Sequim, WA 98382 >Web Design and Hosting, Business Marketing, Print Design and Management > >Toll Free: 1-800-500-8401 >Phone: 360.683.5774 >Fax: 360.683.5857 >Email: mailto:jeff@insideout.com >Web: http://www.insideout.com > >----------------------------------------------------------------- >Learn about our company at http://www.savvyinnkeeper.com >Demo our B&B hosting features at http://www.sampleinn.com >----------------------------------------------------------------- > >------------------------------------------------------------- >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/ ------------------------------------------------------------- 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: Same Database needed on two machines (Kenneth Grome 2002)
  2. Re: Same Database needed on two machines (Brian Fries 2002)
  3. Re: Same Database needed on two machines (Jeff Logan 2002)
  4. Re: Same Database needed on two machines (dale 2002)
  5. Re: Same Database needed on two machines (Bob Minor 2002)
  6. Re: Same Database needed on two machines (Jesse Williams-Proudman 2002)
  7. Re: Same Database needed on two machines (Jeff Logan 2002)
  8. Re: Same Database needed on two machines (Jesse Williams-Proudman 2002)
  9. Re: Same Database needed on two machines (Jeff Logan 2002)
  10. Re: Same Database needed on two machines (Jesse Williams-Proudman 2002)
  11. Re: Same Database needed on two machines (Jeff Logan 2002)
  12. Re: Same Database needed on two machines (Jesse Williams-Proudman 2002)
  13. Same Database needed on two machines (Jeff Logan 2002)
On master site, create a page that simply returns the contents of the database, verbatim - just [include file=the.db].On slave site, create a trigger that does a [tcpconnect] to the above page on the master site, then replaces the database with the new data (closedatabase, then writefile). Have the trigger fire as often as you like.- brianAt 8:44 AM 6/26/02, Jeff Logan wrote: >No the traffic will be really low. Now way of just ftping the file >over with some other utility, this just seems to be the best option >I can think of with out having to develop a ton of new code. > >Jeff Logan > >>Start with the database(s) on each machine. Then on the machine >>that allows updates - write into your update code a process that >>will also update or add the new data to the second machine. >> >>Is the expected traffic so high that your machine can't handle the load? >> >>On Tue, 25 Jun 2002 15:24:21 >>Jeff Logan wrote: >>> >On 6/25/02 3:17 PM, Jeff Logan wrote: >>>> >>>>> >>>>>What other ideas then? >>>> >>>>Having everything on one server and [tcpconnecting] to a >page >>>>that displays >>>>the data you want on the other one? >>>> >>> >>>This will work but tons of extra coding to do. Just moving the >>>database every 12 hours is what I need. Any ideas from anyone >>>else? >>>Jeff >>> >> >>------------------------------------------------------------- >>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/ > > > >InsideOut Marketing and Web Solutions - 229 South Sequim Ave, Sequim, WA 98382 >Web Design and Hosting, Business Marketing, Print Design and Management > >Toll Free: 1-800-500-8401 >Phone: 360.683.5774 >Fax: 360.683.5857 >Email: mailto:jeff@insideout.com >Web: http://www.insideout.com > >----------------------------------------------------------------- >Learn about our company at http://www.savvyinnkeeper.com >Demo our B&B hosting features at http://www.sampleinn.com >----------------------------------------------------------------- > >------------------------------------------------------------- >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/ ------------------------------------------------------------- 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/ Brian Fries

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:

File Upload (1997) unitshipcost vs shipcosts (1997) shipcost - cleaner with a table (1998) Simple way to create unique SKU (1997) File not found error message (1998) bug in [SendMail] (1997) Who's going to MacWorld? (1999) date display (1999) Carraige returns [sendmail] (2004) bug in [SendMail] (1997) Enhancement Request for WebCatalog-NT (1996) Re:Virtual hosting and webcatNT (1997) Force a search at the default.tmpl page? (1997) [OT] WebDNA Family Album (2004) Multiple prices (1997) Newbie Tax Question (1997) The future of WebCatalog is coming with 4.0... (2000) webcat and OS 8 (1997) Problem with version 4 browsers (1998) New Command prefs ... (1997)