On Thu, Aug 07, 2003 at 01:00:12PM -0700, Ian Neubert wrote: > I was trying to design it so that the slaves wouldn't know they had > connected to a different master, as they both masters would have the same IP > address that gets failed over based on the Linux Virtual Server software and > VRRP (like heartbeat from Linux-HA).
That path is a very, very, very difficult one. How can you absolutely guarantee that each master's binlog will be indentical in name, size, and content? If you can't, this scenario really falls apart. (I've suggested enhancements to MySQL that would fix this but don't know if they're terribly high on the priority list...) Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.13: up 6 days, processed 212,501,412 queries (399/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]