Hello Rana, The way to create a standby instance is usually going over a data backup and restore, and a automatic log backups and restores of those log backups. If you search the mailing list for "standby database" a lot of information should materialize, that goes into details and caveats of this process.
Best regards, Tilo Heinrich SAP Labs Berlin -----Original Message----- From: Ranadave Mukherji Sent: Freitag, 20. Oktober 2006 18:06 To: Döhr, Markus ICC-H; [email protected] Subject: Re: MaxDB Logs for use in a backup system Hi, Thanks, I saw that page but it did not clarify how to do what i want to do. That requires a memory dll from the memory management system.? and works differently, i want to have my own scripts to control it, i plan on using nagios to detect an error, and switch myself. But i can not figure out how to get the SQL log of changes made to the database. Any ideas? Rana On Friday 20 October 2006 16:34, you wrote: > > I have two identical database instances (in two separate > > machines), one is > > live and the other is to be a backup. I would like to write > > all changes in > > one database to a log, copy the log over to the other > > instance, and bring the > > backup upto date. > > Check MaxDB's "Hot Standby": > > http://dev.mysql.com/doc/maxdb/en/70/57d43fdd561165e10000000a114b1d/content >. htm > > > > Greetz, > > SIEGENIA-AUBI KG > Informationswesen > > i.A. > > Markus Döhr > SAP-Competence Center/Basis > > Tel.: +49 6503 917-152 > Fax: +49 6503 917-7152 > Internet: http://www.siegenia-aubi.com -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
