Re: Master/Master Asynchronous replication

2003-07-30 Thread Joe Gainey
Excellent are there any doc pointers describing how to set this up? /Joe Jeremy Zawodny wrote: On Wed, Jul 23, 2003 at 04:47:35PM -0400, Joe Gainey wrote: Currently we have a web based application that is mostly reads (4:1 r/w). It is using a single MySQL database server. Is there any way

Re: Master/Master Asynchronous replication

2003-07-29 Thread Michael Brunson
On Mon, 28 Jul 2003 22:23:06 -0700, Jeremy Zawodny used a few recycled electrons to form: | On Wed, Jul 23, 2003 at 04:47:35PM -0400, Joe Gainey wrote: | | Currently we have a web based application that is mostly reads (4:1 | r/w). It is using a single MySQL database server. Is there

Re: Master/Master Asynchronous replication

2003-07-28 Thread Gaspar Bakos
Hi, Joe, I have exactly the same scenario. Did you get any valuable response you could share with me? I haven't seen any on the list. In fact, my case is slightly more complicated; I have N computers, all having their local databases, and have an additional computer, which I call the central

Re: Master/Master Asynchronous replication

2003-07-28 Thread Joe Gainey
Well, the bad news is that I did not get any positive responses (that I can recall) from the list. But I did a little digging. suppossedly in the latest release you can do A-B-C-D-A. Something to do with the server name encoded in the blog. I'm not much of a dba but in todays ID sweatshops

Re: Master/Master Asynchronous replication

2003-07-28 Thread Jeremy Zawodny
On Wed, Jul 23, 2003 at 04:47:35PM -0400, Joe Gainey wrote: Currently we have a web based application that is mostly reads (4:1 r/w). It is using a single MySQL database server. Is there any way to have two database servers in a master/master configuration such that writes to

Master/Master Asynchronous replication

2003-07-23 Thread Joe Gainey
Currently we have a web based application that is mostly reads (4:1 r/w). It is using a single MySQL database server. Is there any way to have two database servers in a master/master configuration such that writes to either database server are replicated to eachother. Basically even