Re: Hot Backup - D3/Linux

"JJCSR" <JCronin@xxxxxxx> wrote in message news:190f7226-0670-459f-8e79-8cd3ac7675d1@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Is anyone out there experienced with "hot-backup", using D3/Linux?
If so, can you report pros and cons? Has anyone who might be using
hot-backup found any reason to use transaction-logger in conjunction
with hot-backup?

Thanks,

Jim Cronin
Director MIS
Kittery Trading Post


Jim,

Hot backup IS transaction logger. In a nutshell, here's what happens.

You do a full save of your system. You start logging transactions.

You take your filesave to a second machine, one with at least as much disk and i/o speed.

You do a full restore on this backup machine. You define a slave master relationship between the two boxes via the software provided. Then start hot-backup.

Hot backup takes the transaction log from the master machine and distributes it to the slave machine(s), keeping the critical files updated.

With reasonably fast lan speeds and reasonably fast hardware, the two boxes are almost virtual twins. Which is what you want. If the master box goes down, you switch over to box two and your back up and running. The only data it is possible to lose is whatever is in the transaction logger pipeline, so the idea is to keep it to a minimum by "tuning" system parameters.

Some fairly large players use hot backup. Auto Trader Magazine pops to mind.

It can take hours to restore a large system and additional hours to restore the transaction logs.

If it is reasonably monitored (slave and/or master phantoms die sometimes) and don't let the logger queue get too big, I've never heard of anyone with a better solution.

--
Mark Brown
Sr. Software Engineer
Drexel Management Svc Inc.
484-716-6154 (cell)

.

Relevant Pages

  • Re: Tracing IPs
    ... then you're talking about how easy is it to spoof an originating IP ... That narrows the request reason down a bit. ... transaction, specifically its HELO or EHLO transaction, to be absolutely any ... way is for a spammer or virus to "bounce" a message as undeliverable to some ...
    (microsoft.public.security.virus)
  • Re: Oyster PAYG on rail to the edge of zone
    ... Is there a technical reason why it's hard to make ticket machines or ticket office equipment capable of activating auto top-up? ... then i can't think of a good reason. ... The fundamental reason is that the card processors insist that the inital setup transaction is processed in the same way as the ongoing transactions, and it isn't practical to carry out this type of transaction at a ticket office. ...
    (uk.transport.london)
  • capturing and returning system errors to client application
    ... I am trying to catch an SqlException in an asp.net 3.5 client. ... A stored proc to insert a headline called Headlines_Insert. ... commit transaction ... 'This is being ignored like there is no exceptions for some reason. ...
    (microsoft.public.sqlserver.programming)
  • Re: Problem saving records from code
    ... so you are using the Click event of the command button. ... unless there is some reason why you cannot move ... > transaction record I just created. ... >>> that form to open the frmIncidents that captures incident for current ...
    (microsoft.public.access.formscoding)
  • Re: Update and Append Query
    ... UPDATE Master RIGHT JOIN [Transaction] ... "Tom Lake" wrote: ... One query will do both. ...
    (microsoft.public.access.queries)