On Mon, May 17, 2004 at 04:07:53PM -0400, [EMAIL PROTECTED] wrote:
>
> SORRY
>
> My typo--- it is NOT ready for any kind of testing. At least I have not
> heard of anything
Heh :)
But do you know if anyone is already working on it?
Luis
I don't know of anyone yet. I don'
On Mon, May 17, 2004 at 04:07:53PM -0400, [EMAIL PROTECTED] wrote:
>
> SORRY
>
> My typo--- it is NOT ready for any kind of testing. At least I have not
> heard of anything
Heh :)
But do you know if anyone is already working on it?
Luis
--
GnuPG Key fingerprint = 113F B290 C
[EMAIL PROTECTED] wrote:
Eric, you are in the same boat I am in. I also have satellite offices
across WAN links that should keep functioning even if the WAN is down.
My , yet to be tested due to "office politics", workaround design was to
have each office (satellite and main) have their own "mini-
-Way or 2-Way
Replication?
PM
On Mon, May 17, 2004 at 02:11:49PM -0400, [EMAIL PROTECTED] wrote:
> MySQL does not support distributed locking (yet).
<-- Snip -->
> MySQL will have it in a future release but it's ready for an
> initial alpha test, yet.
It is available in alpha releases? Someone is working on this already?
Wh
comes back up?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, May 17, 2004 11:12 AM
To: [EMAIL PROTECTED]
Subject: RE: 1-Way or 2-Way Replication?
>there is no mechanism for propagating slave changes from the slave back
>up to the
>there is no mechanism for propagating slave changes
>from the slave back up to the master... synchronization
>occurs *only* from master to slave
>(hence the terminology).
Then why do they call it 2-way replication? Is there such a thing as
master-to-master?
Eric,
In order
"Robinson, Eric" <[EMAIL PROTECTED]> wrote on 17/05/2004 16:29:34:
> It is there. Look for "two-way" :-)
>
> >I don't think they do... A search of the documentation for
> >"2-way" yields nothing.
I presume you mean http://dev.mysql.com/doc/mysql/en/Replication_FAQ.html
That is the simples
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 17 May 2004 10:40 am, Ditto kolankanny wrote:
> Hi all,
>
> In this A->B->C->A setup
>
> A is master and B is slave. in the same time B is master and C is
> slave.
> and C is master and A is slave.
>
> that means All are master and slave.
>
>
That is my question exactly.
-Original Message-
From: Ditto kolankanny [mailto:[EMAIL PROTECTED]
Sent: Monday, May 17, 2004 8:40 AM
To: Robinson, Eric; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: 1-Way or 2-Way Replication?
Hi all,
In this A->B->C->A setup
A is mas
ot;Robinson, Eric" <[EMAIL PROTECTED]> wrote on 17/05/2004 15:48:12:
> >there is no mechanism for propagating slave changes
> >from the slave back up to the master... synchronization
> >occurs *only* from master to slave
> >(hence the terminology).
>
> Then w
It is there. Look for "two-way" :-)
>I don't think they do... A search of the documentation for
>"2-way" yields nothing.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>Circular replication is possible... A->B->C->A
Thanks, but that still does not answer the question... why do they call
it 2-way replication? That implies two machines, not several.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscr
"Robinson, Eric" <[EMAIL PROTECTED]> wrote on 17/05/2004 15:48:12:
> >there is no mechanism for propagating slave changes
> >from the slave back up to the master... synchronization
> >occurs *only* from master to slave
> >(hence the terminol
>there is no mechanism for propagating slave changes
>from the slave back up to the master... synchronization
>occurs *only* from master to slave
>(hence the terminology).
Then why do they call it 2-way replication? Is there such a thing as
master-to-master?
--
MySQL General
"Robinson, Eric" <[EMAIL PROTECTED]> wrote on 17/05/2004 13:40:10:
>
> We want to set up replication to guard against loss of WAN connectivity.
>
> All workstations should continue to use the MySQL server at the
> corporate_office unless the WAN link goes down. Then users at the
> satellite_
Hi,
Our healthcare organization has 2 geographical locations which I will
call corporate_office and satellite_office.
Currently, we run a medical application from a MySQL server at the
corporate_office. Users at the satellite_office use the same server.
Speed across the WAN is acceptable.
Am Friday 14 November 2003 14:51 schrieb nm:
> I set a 2-way replication with 2 servers
> One is accessed and used for both select and updates. The other one is
> backup
> set to work through a failover software.. if the first server is down.
> So the backup server can easily u
I set a 2-way replication with 2 servers
One is accessed and used for both select and updates. The other one is
backup
set to work through a failover software.. if the first server is down.
So the backup server can easily update the other server when it comes up
again.
Do you see any collision
o_increment field, primary key)
You cannot. It's a race condition.
> Any way to make 2-way replication safe ?
Generate your own primary keys.
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]> | http://jeremy.zawodny.com/
MySQL 4.0.15-Ya
insert I need at DB1 and insert I need at DB2
will get same IDs ? (auto_increment field, primary key)
Any way to make 2-way replication safe ?
--
Best regards,
Ilia mailto:[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
On Mon, Jun 23, 2003 at 03:19:05AM -0400, M Lists wrote:
>
> I'm researching a specific network design and have some questions that may
> involve 2-way replication.
Ok...
> I have one master mysql server doing 1 way replication to a large
> number of remotely located slaves.
I'm researching a specific network design and have some questions that may
involve 2-way replication.
I have one master mysql server doing 1 way replication to a large number of
remotely located slaves. Each slave
serves a number of proprietary software clients running inside a private
ne
I'm currently trying to figure out a solution for the following situation:
A small event-management company will expand to a site in another town.
The existing office runs a homemade MS-Access DB application that I want
to migrate to a more viable database server like MySQL.
The two sites will
On Sun, 26 May 2002 23:15:22 +0200
Bjarne Jørgensen <[EMAIL PROTECTED]> wrote:
> Hi!
>
> I've watched the development of replication on mysql with great joy.
> However I haven't been able to understand when og if mysql is going to
> support 2 way replication.
Hi!
I've watched the development of replication on mysql with great joy.
However I haven't been able to understand when og if mysql is going to
support 2 way replication. In other words.
Will it be possible to have 2 databases on 2 different locations, that
synchronize with each othe
Hi!
I've watched the development of replication on mysql with great joy.
However I haven't been able to understand when og if mysql is going to
support 2 way replication. In other words.
Will it be possible to have 2 databases on 2 different locations, that
synchronize with each othe
damn anti-spam: sql sql sql sql sql query query query
Hi I have the same database twice.. I know that I can use replication to let
them copy it in one way... but I would like 2 way replication so you can add
records in both databases...
The databases do not alway have a connection... and
Are there currently any "hacks" to force 2-way
master/master replication with mysql, (either 3.x or
4.0). I want to mirror a database driven website in
various cities/countries, and each local copy needs to
get updated and propagate its changes to all other copies.
__
On Fri, May 11, 2001 at 11:50:27AM -0600, Joseph Chow wrote:
> Hi, everyone,
>
> This is my another question. I have one master server and one slave
> server now. In case that the master is down for any reason, I want
> the slave still accessible by clients. Is that possible in my SQL?
Yes.
Hi, everyone,
This is my another question. I have one master server and one slave
server now. In case that the master is down for any reason, I want the
slave still accessible by clients. Is that possible in my SQL? by two way
replications? This problem seems quiet complicated to me.
Please
32 matches
Mail list logo
