Robert Hodges wrote:
Hi,
One other thing about sequences/auto-increments in general is to think
through how they work with replication, since robust implementations
tend to be non-serialized. Simple example: you have a master/slave
pair for failover. When you failover to the slave, you need to ensure
sequences allocate from values that are higher than any value
allocated on the former master or the defaults for new rows will
generate primary key violations. There are a number of difficulties
(read: implied features) that follow from this.
I looked through the mailing lists but did not see much discussion of
this aspect of the problem. Forgive me if I missed something.
Your point is very well taken and must be resolved.
Were I king and dictator, drizzle would have sequences which would
themselves replicate and address you issue. In the absence, however,
the current hackery does address the issue, however inelegant and
un-general they might be.
A very good topic for discussion, all in all.
On a totally different subject, I hope everyone has been following the
recent re-discovery of the HMS Victory 3.1. Absolutely fascinating.
And even more so if you have a deep reverence for bronze 42 pdr
muzzle loading cannon.
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
