-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Dan Trainor wrote:
> Good afternoon, all -
>
> I've been reading about replication the last few days, and really like
> what I see. I've been able to get replication set up and working in my
> lab, and thus far, am very pleased with my results. However, there is
> one thing which I'm trying to find more information on, which I cannot
> seem to find.
>
> I'm reading about two-way replication, as mentioned in the FAQ of the
> 5.0 Reference Manual. What I'm reading in the manual is, well, the
> piece of text that says "two-way replication" - aside from that, I'm not
> able to find any othere references to it.
>
> The situation which I'm shooting for is as follows; I'd like a small
> replication setup with a single master -> slave relationship. Should
> anything happen with the master, the slave would snag the master's IP
> address via linux-ha. At this time, the slave should become and
> recognize itself as the master. When the master returns, comes back up,
> gets fixed, whatever - the slave relinquishes it's "mastership", and
> gives it back to the original master. The slave would then update the
> master on all the information, if any, that the then-dead master would
> have seen. Once the master is back up, a normal master -> slave
> relationship should be re-established.
>
> I've been reading about MySQL cluster, but I cannot apply it to this
> situation, since I need this master -> slave setup to work between only
> two machines. If I had a third, a mediator, I'd be quite happy using
> mysql cluster. Even better, I'd like to learn more about repliation
> right now, not cluster.
>
> If any more information is required about my situation, I'd be happy to
> elaborate. However, I wanted to at least get a starting point out
> there. Is this do-able?
>
> Thanks for the time, it's much appreciated
> -dant
Hi -
So, I did get this to work. With a bit of hacking around, I was able to
implement master <-> master replication. It preforms exactly as I had
suspected, once I got it working.
Just wanted to let you all know, so you guys can stop posting to my
question ;)
Thanks
- -dant
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFD1r8ZhTPx3xy3bu0RAkrSAJ9zckLHvnAILvr8JV9Ml2cVOFlOSwCfYWy1
lmbxFwxvTfYrqYFZmfX5/Fg=
=FfFx
-----END PGP SIGNATURE-----
