Re: Question on replication terminology

2009-04-29 Thread Curtis Maurand
I think what's really being sought after, here is clustering. --C Eric Bergen wrote: Dual master replication can be either dual master dual write or dual master single writer. The latter is preferred. In this configuration replication is connected in both directions but clients only ever conne

Re: Question on replication terminology

2009-04-29 Thread Eric Bergen
Dual master replication can be either dual master dual write or dual master single writer. The latter is preferred. In this configuration replication is connected in both directions but clients only ever connect to one master at a time. It's just as safe as master -> slave replication if you handle

Re: Question on replication terminology

2009-04-28 Thread Claudio Nanni
Hi there, I would only like to stress that the only supported (and recommended) replication solution in MySQL is Master--->Slave replication. In this scenario you can have ONLY one master and (virtually) any number of slaves. There is NO other safe replication solution. The terms you mention

Re: Question on replication

2008-09-25 Thread Jimmy Guerrero
Hello, Check out: --replicate-do-db=db_name http://dev.mysql.com/doc/refman/5.0/en/replication-options.html -- Jimmy Kandy Wong wrote: Hi, Is there a replication setup method just to replicate a specific database not all the databases or exclude a specific database not to be replicated?

Re: question on replication

2007-08-02 Thread Baron Schwartz
Rilawich Ango wrote: Hi all, Most of the web site and document talk about master to slave or master to slaves setting. Is it possible to do masters to slave replication? Say I have 2 masters, one has a database call d1 and other one has a database call d2. I want to replicate both d1 and d2