[Openstack-operators] instance name increments by 3

Samuel Winchenbach swinchen at gmail.com
Fri Jul 12 14:01:32 UTC 2013


Apparently that is is protect the atomicity of the auto-increment fields
when INSERT requests come in from multiple nodes.


Thanks for helping me out there!

Sam


On Fri, Jul 12, 2013 at 9:50 AM, Samuel Winchenbach <swinchen at gmail.com>wrote:

> 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/6ebf5eb5/attachment.html>


More information about the OpenStack-operators mailing list