View Full Version : Replicated backup restore to Master server

April 26th, 2009, 11:25 PM
2 node replicated master->slave config.
Both solaris 10 sparc boxes.
Backing up all DBs nightly running on slave node using zfs snapshots and replication =1. All look good.

Restoring Is where my issues lie...

Is it possible to remotely restore from the backup sets on the slave to the master accross the network using the ssh plugin? Gig link, using zmanda.

Or should i install a seperate zrm-mysql server instance on the master server and alter the config files approriately to restore from a zfs exported copy from the slave.

Or just manually copy the files over scp and then replay the binlog on the master until just before the drop/truncate ..