Try SQLyog at http://www.webyog.com. It has a very
good schedulable Data Sync Tool.
--- Roger Baklund [EMAIL PROTECTED] wrote:
* Andreas
[...]
On the other hand one could use intervals for key
assignment.
Every time a server runs out of keys it throws a
warning at the admin
and rejects
* Gaston Escobar
I need to sincronice two mysql databases that are in different
places. It is imposible to centralice everything in one database.
Then I would need to sincronice the changes made in both of them
one time per day. Is there any way to do this?
* Roger Baklund
This very much
* Andreas
[...]
On the other hand one could use intervals for key assignment.
Every time a server runs out of keys it throws a warning at the admin
and rejects further inserts until it gets a new key interval.
It's a way to go at least with a low number of servers.
Maybe even give a warning
* Roger
Maybe even give a warning some time _before_ you run out of keys...? ;)
You should never run out of keys. Every time you sync, you also check if
there are many keys left to use... if you sync once a day, as soon as you
have less than 10 times the expected daily usage of keys left to use,
* Jerry
I'm fairly sure it won't do master-master at the moment.
I'd like to be wrong though.
http://www.mysql.com/doc/en/Replication_FAQ.html
* me
master-master replication is the same as two-way replication, and
it is mentioned in the above FAQ, halfway down the page:
Q: What issues
Well no because real two-way replication would happen at the dB level, or
through some distributed transactional layer.
- Original Message -
From: Roger Baklund [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: Jerry [EMAIL PROTECTED]
Sent: Thursday, March 06, 2003 4:02 PM
Subject: Re: Data
* me
ok... then you are not doing real two-way replication, you are only
replicating two ways, so to speak... if I understand you correctly,
which I probably don't... why do you tell us this? :)
* Jerry
Well no because real two-way replication would happen at the
dB level, or through
If you confused I wouldn't bother replying.
I was answering another question from a while ago.
J
- Original Message -
From: Roger Baklund [EMAIL PROTECTED]
To: Jerry [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, March 06, 2003 4:23 PM
Subject: Re: Data sincronization
* me
I need to sincronice two mysql databases that are in different places. It is
imposible to centralice everything in one database. Then I would need to
sincronice the changes made in both of them one time per day.
Is there any way to do this?
It must be in a master master way.
-Mensaje original-
De: Jerry [mailto:[EMAIL PROTECTED]
Enviado el: Martes, 04 de Marzo de 2003 10:50 a.m.
Para: Gaston Escobar
Asunto: Re: Data sincronization
Synchronise in a master master way or just to replicate the data for safety
I need to sincronice two mysql databases that are in different places. It
is
imposible to centralice everything in one database. Then I would need to
sincronice the changes made in both of them one time per day.
Is there any way to do this?
See the section on replication in the manual at
PROTECTED]
Sent: Tuesday, March 04, 2003 1:51 PM
Subject: Data sincronization
It must be in a master master way.
-Mensaje original-
De: Jerry [mailto:[EMAIL PROTECTED]
Enviado el: Martes, 04 de Marzo de 2003 10:50 a.m.
Para: Gaston Escobar
Asunto: Re: Data sincronization
* Gaston Escobar
I need to sincronice two mysql databases that are in different
places. It is imposible to centralice everything in one database.
Then I would need to sincronice the changes made in both of them
one time per day. Is there any way to do this?
This very much depends on your
* Jerry
I'm fairly sure it won't do master-master at the moment.
I'd like to be wrong though.
http://www.mysql.com/doc/en/Replication_FAQ.html
master-master replication is the same as two-way replication, and it is
mentioned in the above FAQ, halfway down the page:
Q: What issues should I
-
From: Roger Baklund [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: Jerry [EMAIL PROTECTED]
Sent: Tuesday, March 04, 2003 2:45 PM
Subject: Re: Data sincronization
* Jerry
I'm fairly sure it won't do master-master at the moment.
I'd like to be wrong though.
http://www.mysql.com/doc/en
15 matches
Mail list logo