Pete Kuczynski wrote:
>
> Hi,
> I've posted this question before, and some were kind enough to respond
> with suggestions to my question [replication], but I'm looking for
> something more difinitave.
>
> Background: I'm running a production mysql database/php4/Apache on a NT4
> IBM Netfinity server [3500 records, growing by 100 a day or so]. I do
> not have the option to go to lunux/unix [company's call not mine].
> I am backing up the database twice a day, noon and 6 pm.
>
> Question: if a disk should crash, I can recover the database from the
> last tape backup, but not the transactions that took place in between.
> Is replacation of the database on another box my only option?
> Dosn't mysql support transaction logging like MSSQL or Oricle, or
> Postgres?.
Yes it does - look for update log in the manual.
But if a disk gets toasted what are you going to do then (with any
system) ?
>
> I don't wan't to switch to another database, but as this one grows, it's
> becoming incrisingly important to be able to do a complete database
> recovery in the event of a crash.
Use a proper operating system, with RAID (either hardware or software
RAID 1, or 5)
Greg
>
> Kindest thanks!
>
> Pete
>
> --
> _______________________________________
> Pete Kuczynski
> Sr. Field Engineer
> DHL Airways Inc.
> Infrastructure Technology & Services
> (773)-462-9758
> 24/7 Helpdesk 1-800-434-5767
>
> ------------------------------------------------------------------------
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
