Tino Wildenhain wrote:
the standard approach for master-master replicated data is to use
an UUID-Datatype (see http://en.wikipedia.org/wiki/UUID )
Good point, although we only have space for 64 bits, so the chance of
collision would be higher than it usually is in a UUID system.
That is a se
Russ Ferriday wrote:
(You could get away with a byte for the server ID, leaving masses of
bits for the item ID.)
That's probably a good idea, but I'd prefer to use the least significant
byte for the server ID, effectively allocating OIDs modulo 256. :-)
Also, it's becoming clear that each ser
Hi,
Shane Hathaway wrote:
Stefan H. Holek wrote:
We have put up two boxes in a MySQL master-master replication setup
[1]. As long as we only write to one of the masters all is fine.
Writing to both masters (and expecting MySQL to sort it out) is
giving us trouble. We see things like:
Las
Stefan! This is like holding all your eyelids apart and shouting out
for somebody with a sharp stick! ;)
Watcha gonna do when you add a third server?
er.. lemme see... Multiply all OIDs by three and allocate new OIDs
modulo three?
Eeek!
Why not make the OID a composite of server ID and se
Stefan H. Holek wrote:
We have put up two boxes in a MySQL master-master replication setup
[1]. As long as we only write to one of the masters all is fine.
Writing to both masters (and expecting MySQL to sort it out) is giving
us trouble. We see things like:
Last_Errno: 1062
Last_Error: Er
Hi Russ,
This is correct. I should have mentioned that the two servers are
configured so that server A creates odd, server B even sequence
numbers. This makes the duplicate id error pretty mysterious, IMO ;-)
Stefan
On 22.05.2008, at 13:15, Russ Ferriday wrote:
I have not read the referen
Stefan,
Thanks for opening this thread here. I'm not actually doing anything
like this, but it's great to see you pushing the envelop. I have done
a lot of work on replicated data, over the years, that's where the
following comment comes from.
On 22 May 2008, at 10:36, Stefan H. Holek wrot
We have put up two boxes in a MySQL master-master replication setup
[1]. As long as we only write to one of the masters all is fine.
Writing to both masters (and expecting MySQL to sort it out) is giving
us trouble. We see things like:
Last_Errno: 1062
Last_Error: Error 'Duplicate entry '41
(Re-send because I forgot to CC the list)
Le Monday 19 May 2008 21:13:49, vous avez écrit :
> Think a bit about your wish:
>
> As soon as one transaction ends, a new one starts.
>
> What should happen with your artificial error handling transaction?
> Should it be aborted? or committed?.
I
Le Thursday 22 May 2008 10:40:46, vous avez écrit :
> Maybe, you search the "zope-dev" archive to find the thread that convinced
> us to change the former behaviour (the one you want now again)
> into the current one?
Adding links for possible future reference:
https://bugs.launchpad.net/zope2/+b
10 matches
Mail list logo
