<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">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>
<br><div><div>On Jul 12, 2013, at 3:19 PM, Samuel Winchenbach wrote:</div><br class="Apple-interchange-newline"><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 class="h5">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 class="h5">
<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">OpenStack-operators@lists.openstack.org</a><br>http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators<br></blockquote></div><br></div></body></html>