Skip to Content
avatar image
Former Member

Autorecover for standby database....

Does anyone know if there are plans to allow the autorecover function to apply log files to a standby database without bringing the database online? It would seem like a logical option to have and greatly simplify the management of log files on the standby server.

Alternatively, does anyone have any template scripts (RHEL4) that they could post for applying log files on a standby server. I don't believe in re-inventing the wheel if I don't have to.

Thanks,

George M-A

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Dec 21, 2007 at 08:34 AM

    Hello George,

    we are in the same situation of not to re-invent the wheel.

    So I used the forum search and some google and found the following link:

    http://lists.mysql.com/maxdb/24407

    In this thread a script for autorecovering is discussed.

    We are now trying to verify the script and to customize it for our environment.

    Regards,

    Thomas

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 21, 2007 at 11:28 AM

    Thomas, thanks for the link.

    I've had a quick look and the scripts look ideal. I'm going to do a bit of work on this over Christmas so I'll use these as the base. It would be good if we all posted our finished scripts on this post in case anyone else needs them in the future. Might even be worth making this a sticky.

    I'd already spent time doing a search but missed this somehow. Anyway, that's the power of forums like this on SDN!

    Cheers, George

    PS: Have a great Christmas and New Year!

    Add comment
    10|10000 characters needed characters exceeded