Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

Re: Re: dbi cookbook for database administration

by busunsl (Vicar)
on Nov 08, 2002 at 07:11 UTC ( [id://211359]=note: print w/replies, xml ) Need Help??


in reply to Re: dbi cookbook for database administration
in thread dbi cookbook for database administration

I posted a space checking script here

Great, I'll have a look. I suppose it handles mixing of data and log right.

I know Rob and his site, it is a great source of information.

I guess that monitoring databases and log also means running the backups, right?

I will put backups in the disaster recovery section.
Automatic backups of the transaction log should go into the thresholdaction procedure. I'll think about that.

Many thanks!

  • Comment on Re: Re: dbi cookbook for database administration

Replies are listed 'Best First'.
Re: Re: Re: dbi cookbook for database administration
by mpeppler (Vicar) on Nov 08, 2002 at 16:05 UTC
    Automatic backups of the transaction log should go into the thresholdaction procedure.
    I guess it's a matter of taste - but I prefer to have manual tran dumps run every X minutes/hours rather than letting the thresholdaction proc handle it - this gives me a better defined recovery window when handling a site without a warm standby.

    Michael

[reply]
      Yes, you're right. I was not clear enough.

      Regular backups every x minutes are a must.
      The thresholdaction procedure is for emergency.

[reply]

In Section Meditations

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?

www.com | www.net | www.org
Node Status?
node history
Node Type: note [id://211359]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? • Last hour • Other CB clients
Other Users?
Others scrutinizing the Monastery: (4)
As of 2024-04-25 12:11 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found