<div>yep, found and changed those values on both master and slave dbs in my.cnf after reading more through the docs to make sure i don't miss/screw up anything doing my DB restarts. i have a reload of both mysql daemons scheduled for my next maintenance window, which should put this to bed once and for all. there are no good reasons for any of the other tables to be auto_incrementing n+10, so this should sort it out. i really need to brush up on my mysql skills....i appreciate the clues, cheers guys and gals.
</div>
<div> </div>
<div>mike<br><br> </div>
<div><span class="gmail_quote">On 5/2/07, <b class="gmail_sendername">Graham Dunn</b> <<a href="mailto:gdunn01@harris.com">gdunn01@harris.com</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">mike wrote:<br>> hate to be repetitive, but i also don't like bouncing production<br>> databases (our mysql handles a lot more than our RT system)....do I need
<br>> to reload/restart mysql for the auto_increment_increment change to take<br>> hold? our tickets are still incrementing n+10 rather than n+1, and the<br>> slave's config is set for auto_increment_offset=2 rather than 1 like the
<br>> master is.<br>><br><br>The values will revert to their defaults if you've restarted mysql. Do<br>you have those values set in the my.cnf?<br><br>"If one of these variables is set globally, its effects persist until
<br>the global value is changed or overridden by setting them locally, or<br>until mysqld is restarted.<br><br>If set locally, the new value affects AUTO_INCREMENT columns for all<br>tables into which new rows are inserted by the current user for the
<br>duration of the session, unless the values are changed during that session."<br><br>Are you setting them to different values on different hosts on purpose?<br><br>If so, it sounds like you're seeing the "set locally" behaviour.
<br><br><br>> thanks!<br>><br>><br>> On 5/1/07, *mike* <<a href="mailto:mike@bseder.org">mike@bseder.org</a> <mailto:<a href="mailto:mike@bseder.org">mike@bseder.org</a>>> wrote:<br>><br>> hmm....does this require a restart of mysql? It now *looks*
<br>> correct, but is still incrementing n+10?<br>><br>> mysql> SHOW VARIABLES LIKE 'auto_inc%';<br>> +--------------------------+-------+<br>> | Variable_name | Value |
<br>> +--------------------------+-------+<br>> | auto_increment_increment | 1 |<br>> | auto_increment_offset | 1 |<br>> +--------------------------+-------+<br>><br>> I made this change as as the root/dba account, so I'm confused...
<br>><br>><br>><br>> On 5/1/07, *mike* <<a href="mailto:mike@bseder.org">mike@bseder.org</a> <mailto:<a href="mailto:mike@bseder.org">mike@bseder.org</a>>> wrote:<br>><br>> yes indeed - the master is now set to
<br>><br>> mysql> SHOW VARIABLES LIKE 'auto_inc%';<br>> +--------------------------+-------+<br>> | Variable_name | Value |<br>> +--------------------------+-------+
<br>> | auto_increment_increment | 1 |<br>> | auto_increment_offset | 1 |<br>> +--------------------------+-------+<br>><br>> and the slave is<br>><br>> mysql> SHOW VARIABLES LIKE 'auto_inc%';
<br>> +--------------------------+-------+<br>> | Variable_name | Value |<br>> +--------------------------+-------+<br>> | auto_increment_increment | 1 |<br>> | auto_increment_offset | 2 |
<br>> +--------------------------+-------+<br>> 2 rows in set (0.00 sec)<br>><br>> prior to making the change suggested, the master was configured as:<br>><br>><br>> Current database: rt3
<br>><br>> +--------------------------+-------+<br>> | Variable_name | Value |<br>> +--------------------------+-------+<br>> | auto_increment_increment | 10 |<br>
> | auto_increment_offset | 1 |<br>> +--------------------------+-------+<br>> 2 rows in set (0.00 sec)<br>><br>> do I need to reload mysql, or is this a hot-fix? needless to
<br>> say, i am not a DBA, let alone terribly cluey with MySQL (but<br>> learning more every day) ;).<br>><br>> Thank you very much for the assistance, it's very much<br>> appreciated and I owe Mark Roedel a six-pack for the initial
<br>> assist :)<br>><br>><br>><br>><br>> On 5/1/07, *Graham Dunn* <<a href="mailto:gdunn01@harris.com">gdunn01@harris.com</a><br>> <mailto:<a href="mailto:gdunn01@harris.com">
gdunn01@harris.com</a>>> wrote:<br>><br>> mike wrote:<br>> > Hello,<br>> ><br>> > Since upgrading to RT 3.6.3, I've noticed that all of our
<br>> tickets are<br>> > incrementing their ticket numbers/IDs by n+10 -<br>> ><br>> Are you using multiple-master replication?<br>><br>>
<a href="http://dev.mysql.com/doc/refman/5.0/en/replication-auto-increment.html">http://dev.mysql.com/doc/refman/5.0/en/replication-auto-increment.html</a><br>> <<a href="http://dev.mysql.com/doc/refman/5.0/en/replication-auto-increment.html">
http://dev.mysql.com/doc/refman/5.0/en/replication-auto-increment.html</a>><br>><br>> _______________________________________________<br>> <a href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a><br>><br>> Community help: <a href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</a><br>> <<a href="http://wiki.bestpractical.com/">
http://wiki.bestpractical.com/</a>><br>> Commercial support: <a href="mailto:sales@bestpractical.com">sales@bestpractical.com</a><br>> <mailto:<a href="mailto:sales@bestpractical.com">sales@bestpractical.com
</a>><br>><br>><br>> Discover RT's hidden secrets with RT Essentials from<br>> O'Reilly Media.<br>> Buy a copy at <a href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com
</a><br>> <<a href="http://rtbook.bestpractical.com/">http://rtbook.bestpractical.com/</a>><br>><br>><br>><br>><br>> --<br>><br>> --<br>> One way or another, everyone stops bleeding.
<br>><br>><br>> --<br>> --<br>> One way or another, everyone stops bleeding.<br>><br>><br>><br>><br>> --<br>> --<br>> One way or another, everyone stops bleeding.
<br>><br>><br>><br>><br>> --<br>> --<br>> One way or another, everyone stops bleeding.<br>><br>><br>> ------------------------------------------------------------------------<br>><br>> _______________________________________________
<br>> <a href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a><br>><br>> Community help: <a href="http://wiki.bestpractical.com">
http://wiki.bestpractical.com</a><br>> Commercial support: <a href="mailto:sales@bestpractical.com">sales@bestpractical.com</a><br>><br>><br>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
<br>> Buy a copy at <a href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a><br><br>_______________________________________________<br><a href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a><br><br>Community help: <a href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</a><br>Commercial support: <a href="mailto:sales@bestpractical.com">
sales@bestpractical.com</a><br><br><br>Discover RT's hidden secrets with RT Essentials from O'Reilly Media.<br>Buy a copy at <a href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a><br></blockquote>
</div><br><br clear="all"><br>-- <br>--<br>One way or another, everyone stops bleeding.