<div dir="ltr"><div class="gmail_default" style="font-family:courier new,monospace">Apparently that is is protect the atomicity of the auto-increment fields when INSERT requests come in from multiple nodes.</div><div class="gmail_default" style="font-family:courier new,monospace">
<br></div><div class="gmail_default" style="font-family:courier new,monospace"><br></div><div class="gmail_default" style="font-family:courier new,monospace">Thanks for helping me out there!</div><div class="gmail_default" style="font-family:courier new,monospace">
<br></div><div class="gmail_default" style="font-family:courier new,monospace">Sam </div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Fri, Jul 12, 2013 at 9:50 AM, Samuel Winchenbach <span dir="ltr"><<a href="mailto:swinchen@gmail.com" target="_blank">swinchen@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div class="gmail_default" style="font-family:'courier new',monospace">Well... what do you know:</div>
<div class="gmail_default" style="font-family:'courier new',monospace"><br></div><div class="gmail_default"><div class="im">
<div class="gmail_default"><font face="courier new, monospace">mysql> SHOW VARIABLES LIKE 'auto_inc%';</font></div></div><div class="gmail_default"><font face="courier new, monospace">+--------------------------+-------+</font></div>
<div class="gmail_default"><font face="courier new, monospace">| Variable_name | Value |</font></div><div class="gmail_default"><font face="courier new, monospace">+--------------------------+-------+</font></div>
<div class="gmail_default"><font face="courier new, monospace">| auto_increment_increment | 3 |</font></div><div class="gmail_default"><font face="courier new, monospace">| auto_increment_offset | 1 |</font></div>
<div class="gmail_default"><font face="courier new, monospace">+--------------------------+-------+</font></div><div class="gmail_default"><font face="courier new, monospace">2 rows in set (0.00 sec)</font></div><div class="gmail_default">
<font face="courier new, monospace"><br></font></div><div class="gmail_default"><font face="courier new, monospace"><br></font></div><div class="gmail_default"><font face="courier new, monospace">Hrmmm, I will have to ask the percona people if that is normal.</font></div>
<div class="gmail_default"><br></div><div class="gmail_default"><font face="courier new, monospace">Thanks,</font></div><div class="gmail_default"><font face="courier new, monospace">Sam</font></div></div></div><div class="HOEnZb">
<div class="h5"><div class="gmail_extra">
<br><br><div class="gmail_quote">On Fri, Jul 12, 2013 at 9:32 AM, (JDN) Martin van Wilderen <span dir="ltr"><<a href="mailto:mvwilderen@jdn.nl" target="_blank">mvwilderen@jdn.nl</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div style="word-wrap:break-word">Please check your mySQL config:<div><br></div><div>mysql> SHOW VARIABLES LIKE 'auto_inc%';</div><div><br></div><div><div>
<div>Met vriendelijke groet,<br><br>Martin van Wilderen<br>Technical Manager</div>
</div><div><div>
<br><div><div>On Jul 12, 2013, at 3:19 PM, Samuel Winchenbach wrote:</div><br><blockquote type="cite"><div dir="ltr"><div class="gmail_default" style="font-family:courier new,monospace">Hi Mike,</div><div class="gmail_default" style="font-family:courier new,monospace">
<br></div><div class="gmail_default" style="font-family:courier new,monospace">
I do not have that option set in mysql.conf. I am running a three node Percona/Galera Cluster as my database backend. Perhaps that has something to do with it?</div><div class="gmail_default" style="font-family:courier new,monospace">
<br></div><div class="gmail_default" style="font-family:courier new,monospace">Thanks,</div><div class="gmail_default" style="font-family:courier new,monospace">Sam</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">
On Fri, Jul 12, 2013 at 4:47 AM, Mike Wilson <span dir="ltr"><<a href="mailto:geekinutah@gmail.com" target="_blank">geekinutah@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">The instance-xxxxxxxxx is generated based on the id field of the instances table I believe. Do you perchance have an auto-increment_offset in your mysql conf?<div><br></div><div>-Mike</div></div><div class="gmail_extra">
<br><br><div class="gmail_quote"><div><div>On Thu, Jul 11, 2013 at 8:02 PM, Samuel Winchenbach <span dir="ltr"><<a href="mailto:swinchen@gmail.com" target="_blank">swinchen@gmail.com</a>></span> wrote:<br>
</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div>
<div dir="ltr"><div class="gmail_default" style="font-family:'courier new',monospace">Hi All,</div><div class="gmail_default" style="font-family:'courier new',monospace"><br></div><div class="gmail_default" style="font-family:'courier new',monospace">
Any idea why the instance name would increment by a value other than one (three in my case) when launching a new vm? I get things like:</div><div class="gmail_default" style="font-family:'courier new',monospace">
<br></div><div class="gmail_default" style="font-family:'courier new',monospace">instance-000000003</div><div class="gmail_default" style="font-family:'courier new',monospace">instance-000000006</div><div class="gmail_default" style="font-family:'courier new',monospace">
instance-000000009</div><div class="gmail_default" style="font-family:'courier new',monospace">...</div><div class="gmail_default" style="font-family:'courier new',monospace"><br></div><div class="gmail_default" style="font-family:'courier new',monospace">
and so on.</div><div class="gmail_default" style="font-family:'courier new',monospace"><br></div><div class="gmail_default" style="font-family:'courier new',monospace">This seems very strange. I _am_ running three nodes with everything in Active/Active mode (except L3 agent, I only have that on two node)</div>
<div class="gmail_default" style="font-family:'courier new',monospace"><br></div><div class="gmail_default" style="font-family:'courier new',monospace">Thanks!</div><div class="gmail_default" style="font-family:'courier new',monospace">
<br></div><div class="gmail_default" style="font-family:'courier new',monospace">Sam</div></div>
<br></div></div>_______________________________________________<br>
OpenStack-operators mailing list<br>
<a href="mailto:OpenStack-operators@lists.openstack.org" target="_blank">OpenStack-operators@lists.openstack.org</a><br>
<a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators</a><br>
<br></blockquote></div><br></div>
</blockquote></div><br></div>
_______________________________________________<br>OpenStack-operators mailing list<br><a href="mailto:OpenStack-operators@lists.openstack.org" target="_blank">OpenStack-operators@lists.openstack.org</a><br><a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators</a><br>
</blockquote></div><br></div></div></div></div></blockquote></div><br></div>
</div></div></blockquote></div><br></div>