Fwd: [rt-users] Re: InnoDB Ticket IDs incrementing by 10?
mike
mike at bseder.org
Tue May 1 17:26:07 EDT 2007
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 <gdunn01 at harris.com> 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: sales at bestpractical.com
>
>
> 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20070501/4dc0329b/attachment.htm>
More information about the rt-users
mailing list