<div>hate to be repetitive, but i also don't like bouncing production databases (our mysql handles a lot more than our RT system)....do I need to reload/restart mysql for the auto_increment_increment change to take hold? our tickets are still incrementing n+10 rather than n+1, and the slave's config is set for auto_increment_offset=2 rather than 1 like the master is.
</div>
<div> </div>
<div>thanks!<br><br> </div>
<div><span class="gmail_quote">On 5/1/07, <b class="gmail_sendername">mike</b> <<a href="mailto:mike@bseder.org">mike@bseder.org</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div>hmm....does this require a restart of mysql? It now *looks* correct, but is still incrementing n+10?</div><span class="q">
<div> </div>
<div>mysql> SHOW VARIABLES LIKE 'auto_inc%';<br>+--------------------------+-------+<br>| Variable_name | Value |<br>+--------------------------+-------+<br>| auto_increment_increment | 1 | <br>
| auto_increment_offset | 1 | <br>+--------------------------+-------+</div>
<div> </div></span>
<div>I made this change as as the root/dba account, so I'm confused...</div>
<div><span class="e" id="q_11249aa258716633_3">
<div><br><br> </div>
<div><span class="gmail_quote">On 5/1/07, <b class="gmail_sendername">mike</b> <<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:mike@bseder.org" target="_blank">mike@bseder.org</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div><span>
<div><span>
<div>
<div>yes indeed - the master is now set to</div><span>
<div> </div>
<div>mysql> SHOW VARIABLES LIKE 'auto_inc%';<br>+--------------------------+-------+<br>| Variable_name | Value |<br>+--------------------------+-------+<br>| auto_increment_increment | 1 | <br>| auto_increment_offset | 1 |
<br>+--------------------------+-------+<br> </div></span>
<div>and the slave is </div>
<div> </div>
<div><span>mysql> SHOW VARIABLES LIKE 'auto_inc%';<br>+--------------------------+-------+<br>| Variable_name | Value |<br>+--------------------------+-------+<br>| auto_increment_increment | 1 |
<br></span>| auto_increment_offset | 2 | <br>+--------------------------+-------+<span><br>2 rows in set (0.00 sec)<br> </span></div>
<div>prior to making the change suggested, the master was configured as:</div>
<div> </div>
<div><span>
<p>Current database: rt3</p>
<p>+--------------------------+-------+<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></p></span>
<p>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) ;).</p>
<p>Thank you very much for the assistance, it's very much appreciated and I owe Mark Roedel a six-pack for the initial assist :) </p></div><br><br> </div>
<div><span class="gmail_quote">On 5/1/07, <b class="gmail_sendername">Graham Dunn</b> <<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:gdunn01@harris.com" target="_blank">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>> Hello,<br>><br>> Since upgrading to RT 3.6.3, I've noticed that all of our tickets are
<br>> incrementing their ticket numbers/IDs by n+10 -<br>><br>Are you using multiple-master replication?<br><br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://dev.mysql.com/doc/refman/5.0/en/replication-auto-increment.html" target="_blank">
http://dev.mysql.com/doc/refman/5.0/en/replication-auto-increment.html </a><br><br>_______________________________________________<br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users" target="_blank">
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a><br><br>Community help: <a onclick="return top.js.OpenExtLink(window,event,this)" href="http://wiki.bestpractical.com/" target="_blank">http://wiki.bestpractical.com
</a><br>Commercial support: <a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:sales@bestpractical.com" target="_blank">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 onclick="return top.js.OpenExtLink(window,event,this)" href="http://rtbook.bestpractical.com/" target="_blank">http://rtbook.bestpractical.com</a><br></blockquote></div><br><br clear="all"><br></span>
</div>--
<div><span><br>--<br>One way or another, everyone stops bleeding. </span></div><br clear="all"><br>-- <br>--<br>One way or another, everyone stops bleeding. </span></div></blockquote></div><br><br clear="all"><br>-- <br>
--<br>One way or another, everyone stops bleeding. </span></div></blockquote></div><br><br clear="all"><br>-- <br>--<br>One way or another, everyone stops bleeding.