title: Permanently setting auto_increment_offset in MySQL
body: <p>I ran the command as root:</p>
  
  <pre><code>set @@auto_increment_offset = 2;
  </code></pre>
  
  <p>But the effect cannot be seen from other connections.  Why not?  It is global.</p>
  
  <p>From <a href="http://dev.mysql.com/doc/refman/5.1/en/replication-options-master.html" rel="nofollow">http://dev.mysql.com/doc/refman/5.1/en/replication-options-master.html</a>:
  "If the global value of either variable is set, its effects persist until the global value is changed or overridden by setting the session value, or until mysqld is restarted."</p>
  
  <p>That doesn't seem to agree with what I am seeing.</p>
  
  <p>Ultimately, I would like to know if there any way to permanently set the offset for all clients without restarting mysqld?</p>