yes indeed - the master is now set to mysql> SHOW VARIABLES LIKE 'auto_inc%'; +--------------------------+-------+ | Variable_name | Value | +--------------------------+-------+ | auto_increment_increment | 1 | | auto_increment_offset | 1 | +--------------------------+-------+
and the slave is mysql> SHOW VARIABLES LIKE 'auto_inc%'; +--------------------------+-------+ | Variable_name | Value | +--------------------------+-------+ | auto_increment_increment | 1 | | auto_increment_offset | 2 | +--------------------------+-------+ 2 rows in set (0.00 sec) prior to making the change suggested, the master was configured as: Current database: rt3 +--------------------------+-------+ | Variable_name | Value | +--------------------------+-------+ | auto_increment_increment | 10 | | auto_increment_offset | 1 | +--------------------------+-------+ 2 rows in set (0.00 sec) do I need to reload mysql, or is this a hot-fix? needless to say, i am not a DBA, let alone terribly cluey with MySQL (but learning more every day) ;). Thank you very much for the assistance, it's very much appreciated and I owe Mark Roedel a six-pack for the initial assist :) On 5/1/07, Graham Dunn <[EMAIL PROTECTED]> wrote:
mike wrote: > Hello, > > Since upgrading to RT 3.6.3, I've noticed that all of our tickets are > incrementing their ticket numbers/IDs by n+10 - > Are you using multiple-master replication? http://dev.mysql.com/doc/refman/5.0/en/replication-auto-increment.html _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
-- -- One way or another, everyone stops bleeding. -- -- One way or another, everyone stops bleeding.
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
