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:

OT ImageMagick and Thumbnails (2003) OT - not enough humour on the list lately (2003) WebDelivery: One step closer !! (1997) Emailer help....! (1997) Comments in db? (1997) Beta (?) version of WebCatalog 2.1 (1998) Add a field to the error log? (1997) Size limit for tmpl editor ? (1997) how do I delete 1 of 2 identical records? (2003) Press Release hit the NewsWire!!! (1997) large database (2000) Dummy Credit Card Number for debug? (1997) Adding up weights (1998) Future of WebDNA (was urls) (2005) expired beta (1997) Loss in Form (1998) Alternating colors (1997) [dos] command (1997) Its not that weird. (1997) Re:WebCatalog/WebMerchant III (1998)