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

Question on replication terminology

2009-04-27 Thread Vikram Vaswani
Hi I'm new to replication and looking through some docs on how to use it. Could someone please tell me if the following terms mean the same thing or, if not, what is the difference: master-master replication dual-master replication bidirectional replication TIA -BT

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?

Question on replication

2008-09-25 Thread Kandy Wong
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? Thank you. Kandy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[E

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

question on replication

2007-08-02 Thread Rilawich Ango
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 to a slave. Is it poss

Newbie Question on Replication

2002-04-08 Thread Howie Kamholz
After a orderly system and MySQL shutdown and restart of both slave and master, replication failed to start on the slave. Any suggestions on how to get replication going again without shutting down, taking a snapshot and starting replication would be greatly appreciated. The error logs on th

Re: newbie question on replication and load balancing...

2001-01-21 Thread Ganen Ganeswaran
"Jeremy D. Zawodny" wrote: > On Tue, Jan 16, 2001 at 03:41:14PM +0800, Ganen Ganeswaran wrote: > > > I'm a relative newbie in mySQL. I have 10 mySQL databases. At the > > moment I'm only using 1 of the databases. I was wondering if it's > > possible (and how) to setup some sort of replication/loa

Re: newbie question on replication and load balancing...

2001-01-16 Thread Jeremy D. Zawodny
On Tue, Jan 16, 2001 at 03:41:14PM +0800, Ganen Ganeswaran wrote: > I'm a relative newbie in mySQL. I have 10 mySQL databases. At the > moment I'm only using 1 of the databases. I was wondering if it's > possible (and how) to setup some sort of replication/load balancing > between all 10 dbs. Bas

newbie question on replication and load balancing...

2001-01-15 Thread Ganen Ganeswaran
Hi, I'm a relative newbie in mySQL. I have 10 mySQL databases. At the moment I'm only using 1 of the databases. I was wondering if it's possible (and how) to setup some sort of replication/load balancing between all 10 dbs. Basically I want the information in one db replicated across the other