Imagine the following MySQL replication configuration:
M1 -> S1
\-> S2
Where the DB Master (M1) replicates to two slaves, S1 and S2, each of
which have bin-logging turned on and slave updates are logged. Now
image that M1 crashes. How does one go about turning S1 into the
Master and S2 into a slave of S1 (or vice versa)?
Options:
1) export data from S1 using mysqldump, import on S2, and configure replication.
2) calculate replication coordinate offsets between S1 and S2, adjust,
and configure replication.
Is option 2 possible? It seems like it should be by comparing log
entries, timestamps, and positions. But I haven't found any source
that has done this.
Regards,
- Robert
--
--
Central West End Linux Users Group (via Google Groups)
Main page: http://www.cwelug.org
To post: [email protected]
To subscribe: [email protected]
To unsubscribe: [email protected]
More options: http://groups.google.com/group/cwelug
---
You received this message because you are subscribed to the Google Groups
"Central West End Linux Users Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
