Jeremy Zawodny ([EMAIL PROTECTED]) wrote: > >On Sun, Sep 08, 2002 at 03:30:35AM +0000, Sam Przyswa wrote: >> Jeremy Zawodny ([EMAIL PROTECTED]) écrivait: >> > >> >On Fri, Sep 06, 2002 at 03:52:24PM +0000, Sam Przyswa wrote: >> >> Hi, >> >> >> >> Does the next MySQL 4.x version will support cross replications >> >> between several master servers in cluster ? >> > >> >Multi-master replication works as well in 4.x as it does in 3.23.xx. >> >> Does multi-master mean master to master, imagine you have 3 MySQL >> servers, A, B, C, with a load balancer in front end, if we make an >> update on A, is it possible to replicate/sync the change on B and C >> ? > >You want to do this?
Thanks for the link, there is a lot of interesting things ! >http://jeremy.zawodny.com/mysql/managing-mysql-replication_files/slide0121.htm > >Just make B a slave of A, C a slave of B, and A a slave of C. This is a good approach. >Beware of using auto-increments in that scanario, though. You'll be >rather surprised and frustrated as explained in the manual. We are thinking about a parallel replication by use the Spread Toolkit (www.spread.org) to broadcast the writes queries on all the servers in the same time and only once with the guaranty that the messages are well received by each server, and load balance the read queries. Then we can have a very scalable clustering solution with a minimum network load. What do you think about this concept, perhaps we can find a workaround for the auto-increment problem. Many thanks for your advices. Sam. --------------------------------------------------------------------- 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
