Open Stack

Well... what do you know:

mysql> SHOW VARIABLES LIKE 'auto_inc%';
+--------------------------+-------+
| Variable_name            | Value |
+--------------------------+-------+
| auto_increment_increment | 3     |
| auto_increment_offset    | 1     |
+--------------------------+-------+
2 rows in set (0.00 sec)


Hrmmm, I will have to ask the percona people if that is normal.

Thanks,
Sam


On Fri, Jul 12, 2013 at 9:32 AM, (JDN) Martin van Wilderen <
mvwilderen at jdn.nl> wrote:

> Please check your mySQL config:
>
> mysql> SHOW VARIABLES LIKE 'auto_inc%';
>
> Met vriendelijke groet,
>
> Martin van Wilderen
> Technical Manager
>
> On Jul 12, 2013, at 3:19 PM, Samuel Winchenbach wrote:
>
> Hi Mike,
>
> 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?
>
> Thanks,
> Sam
>
>
> On Fri, Jul 12, 2013 at 4:47 AM, Mike Wilson <geekinutah at gmail.com> wrote:
>
>> 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?
>>
>> -Mike
>>
>>
>> On Thu, Jul 11, 2013 at 8:02 PM, Samuel Winchenbach <swinchen at gmail.com>wrote:
>>
>>> Hi All,
>>>
>>> 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:
>>>
>>> instance-000000003
>>> instance-000000006
>>> instance-000000009
>>> ...
>>>
>>> and so on.
>>>
>>> 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)
>>>
>>> Thanks!
>>>
>>> Sam
>>>
>>> _______________________________________________
>>> OpenStack-operators mailing list
>>> OpenStack-operators at lists.openstack.org
>>> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators
>>>
>>>
>>
> _______________________________________________
> OpenStack-operators mailing list
> OpenStack-operators at lists.openstack.org
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-operators/attachments/20130712/bad3a9f4/attachment.html>