Robert Citek
2013-03-22 19:28:33 UTC
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: ***@googlegroups.com
To subscribe: cwelug-***@googlegroups.com
To unsubscribe: cwelug-***@googlegroups.com
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 cwelug+***@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
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: ***@googlegroups.com
To subscribe: cwelug-***@googlegroups.com
To unsubscribe: cwelug-***@googlegroups.com
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 cwelug+***@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.