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