On Fri, Aug 31, 2001 at 05:44:11PM +0800, Wang Aocheng wrote:
> Dear All,
>
> I have a question:
>
> How can build multi-master-host?
>
> I have 3 mysql hosts,I want to use mysql data replicate. thanks!
And you want all 3 to be masters?
If so, you need to configure them in a replication "triangle" where
the master/slave relationship looks like this, where "X -->Y" means "Y
is a slave of X"
A --> B --> C --> A
Or, easier to visualize in my poor ASCII art:
A
/ ^
/ \
v \
B ----> C
That should do what you're looking for.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.41-max: up 3 days, processed 33,382,375 queries (110/sec. avg)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
