MySQL - How to set auto_increment_increment permanently, to last server restart? <p>Is it possible to set MySQL auto_increment_increment so that it survives the server restart?</p> <p>Currently I'm setting it like this:</p> <pre><code>SET @@auto_increment_increment=2; </code></pre> <p>But it loses the value when I:</p> <pre><code>sudo service mysql restart </code></pre> <p>And returns to default value of 1.</p> <p>I'm on a AWS and I would like to be able to handle possible doomsday errors as easy as possible: by setting up a new instance from an AMI. I would like it to be ready to serve right away when it's up and avoid things like setting the auto_increment_increment -value by hand.</p>