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
> > a
* 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, y
* 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 warnin
* 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
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: Thursda
* 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 th
;
Sent: Thursday, March 06, 2003 4:02 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.
* 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 pag
iginal Message -
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-
* 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 s
* 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 a
" <[EMAIL PROTECTED]>
To: <[EMAIL 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 d
> 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
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?
15 matches
Mail list logo
