Hi, Most of the documents talk about the normal replication and dual master. None of them talk about the conflict handling. Does it mean that we need to handle the conflict ourselves? As I know, MSSQL has a way to implement 2 ways replication. Any drawback if using MSSQL for this kind of replication? Any comparison about database replication?
On 2/14/07, Rilawich Ango <[EMAIL PROTECTED]> wrote:
Thanks for the links. It seems helpful for me. I will read it then. BTW, does anyone implement multi-master replication successfully? I have read a lot of document and they all don't recommend to do it. On 2/13/07, Juan Eduardo Moreno <[EMAIL PROTECTED]> wrote: > Dear all, > > > We can view interesting tipic into : > http://www.onlamp.com/lpt/a/6549 > > > Regards, > Juan Eduardo > > > > On 2/12/07, Atle Veka < [EMAIL PROTECTED]> wrote: > > > > 2 way replication, also referred to as dual master replication, has been > > available for quite some time. However implementation can be tricky. Look > > for the "Dual master" section in chapter 7 of the High Performance MySQL > > book: > > > http://dev.mysql.com/books/hpmysql-excerpts/ch07.html > > > > If you need more than 2 masters, then all bets are off.. > > > > > > Atle > > > > > > On Mon, 12 Feb 2007, Rilawich Ango wrote: > > > > > Hi all, > > > > > > I know it is an old question and I have read from the mysql website > > > about the topic. Until now, mysql still doesn't support 2 ways > > > replication, quoted from mysql website. As I have multiple location > > > and each location will have a DB. Most of all need to read and write > > > to the database. > > > > > > In my case, 2 ways replication is the most direct way to do it. Any > > > other solution is suitable for me to implement if 2 ways replication > > > is not a good way? Anyone has successfully implement 2 ways > > > replication? Any suggestion? > > > > > > 1PC-read/update-DB(a) <--- 2 ways replication --> DB(b)-read/update-PC2 > > > > > > ango > > > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > >
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
