I meant that it would be beneficial to do the reset on the master at
the same time you issue the stop slave, so that the binary log file on the
master would only contain updates that are not the backup. It would be
very difficult to ensure data integrity though - if an update happened
betwe
Gary,
We go through the process of removing the slave DB and restoring from
backup on a fairly regular basis (due to testing new functionality of our
app). My first question would be about your backups - how are you doing
them?
If you are doing a filesystem backup (taring the entire
I would need log-bin and log-slave-updates enabled on the slave, correct?
So to automate the process it would be better to start both servers
without the Master-host info in the conf file, letting Heartbeat issue the
commands on startup to convert one box to slave. During a fail-over,
heartbe
Hello,
I've been lurking about the lists for a few months now, hoping to gain
some knowledge on MySQL's replication features for HA setup. I have a
fairly good understanding of the setup process, but I'm a little confused
on one points. We are running a 2 node - master-slave setup, and we are