On Dec 11, 2007, at 9:42 AM, Karanbir Singh wrote:
Matt Shields wrote:
the code). But I saw a presentation at the Boston MySQL Meetup.com
group about how to do master-master in mysql 5. We're about to
implement this in the next few weeks. If it's done this way both
that is imho, a mysql-5.1 only feature, where you can have rbr and
multimaster setups that actually work. and 5.1 isnt quite ready for
release as yet :D
I'm running a multi-master setup with 5.0 in production with a
moderate amount of success. I did try 5.1 a few months ago and it died
a horrible, fiery death.
You will definitely need auto_increment_increment and
auto_increment_offset and replicate-same-server-id set to 0.
FYI, I recently took a MySQL High Availability class, and multi-master
is definitely not a standard configuration. It was only briefly
touched on, and only one other person there had it running in
production. But, while it's not officially supported they do their
best to make it work.
Specifically, what makes you say it is a 5.1 only feature? What does
5.1 give you that makes it easier than 5.0?
Ryan
--
Ryan Ordway E-mail: rordway@xxxxxxxxxxxxxxx
Unix Systems Administrator rordway@xxxxxxxxxxxxxxxxxxxxxxx
OSU Libraries, Corvallis, OR 97331 Office: Valley Library #4657
_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos
