At 06:14 10-10-2006, Michael Scheidell wrote:
I am experimenting with mysql replication, and have done some research
on key collisions in the case of a 'load balancing' situation (live sql

[snip]


My concern is over use of SERIAL keys in amavisd-new tables, vs
AUTO_INCREMENT keys.
(are SERIAL keys an alias for AUTO_INCREMENT? Are SERIAL keys safe in
replication situations?)

It's an alias for BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE.

See auto_increment_increment and auto_increment_offset (MySQL 5.x).

Regards,
-sm

Reply via email to