MySQL Forums
Forum List  »  MaxDB

Re: Any way to trigger a backup in conjunction with AutoLog?
Posted by: Ulf Wendel
Date: December 21, 2005 02:41AM

Fred Claypool wrote:
> we've had Auto Logging enabled on all of our MaxDB
> databases. (We're currently running 7.5.00.31 on
> HP-UX & Linux.)
[...]
> them onto tape. Is there any triggering or event
> mechanism built in to MaxDB that I could configure
> that would notify the backup tool to start working
> when MaxDB calls it (as opposed to waiting until
> the next regularly scheduled backup)?

7.5 is the critical factor here. In 7.6 there is a mechanism, there's something called Eventing.

This http://blog.ulf-wendel.de/?p=19 is on german, but it gives you some code pieces and pointers in the examples. We've also put a very basic example in here http://dev.mysql.com/tech-resources/articles/maxdb-sap-hosting.pdf which is written in english. Search for "Hands on: Using Eventing for pro-active actions, for example: updating statistics" in that text.

You'll learn that the feature appeared in 7.5.00.8 but has not been declared final before 7.6. So, you might need to experiment a little bit with the syntax. It's kind of late beta in 7.5 - should work most of the time, but no documentation and use at your own "risk".

However, there should be some backup events and it should be possible to trigger an action once the automatic log backup has been done. Note that the online documentation is on 7.6 and has almost no 7.5 notes in it. The 7.5 documentation is in the archive: http://dev.mysql.com/downloads/maxdb/7.5.00.html#docu .

If it works, let the forum know about your solution.

Ulf

Ulf

Options: ReplyQuote


Subject
Written By
Posted
Re: Any way to trigger a backup in conjunction with AutoLog?
December 21, 2005 02:41AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.