openstack team mailing list archive

[Jay Pipes <jaypipes@xxxxxxxxx>]

Fair enough :)

On Tue, Jan 10, 2012 at 8:48 PM, Monty Taylor <mordred@xxxxxxxxxxxx> wrote:
> I think we manage enough of the schema via sqlalchemy that expecting a
> DBA to do this is unexpected. Also, it's nova,keystone and glance that
> want to ensure a behavior of key matching - if we leave this up to
> deployers, they will be more likely to get it wrong (and there isn't
> really a great argument as to why they'd ever want to do it the other way)
>
> I think it's possible to get sqlalchemy to do db-engine specific
> properties in the case of the use of that engine...
>
> On 01/10/2012 05:16 PM, Jay Pipes wrote:
>> Not sure I would think that a migrate patch is the right approach
>> here... I kind of feel like this is a DBA or sysops responsibility.
>>
>> Thoughts?
>>
>> -jay
>>
>> On Tue, Jan 10, 2012 at 4:43 PM, Nachi Ueno
>> <ueno.nachi@xxxxxxxxxxxxxxxxxxxx> wrote:
>>> Hi Jay
>>>
>>> Thanks
>>> Is it possible to do it on sqlalchemy.migration ?
>>>
>>>
>>> 2012/1/10 Jay Pipes <jaypipes@xxxxxxxxx>:
>>>> +1 for Case Sensitive. For MySQL, this is a configuration issue. The
>>>> default character set and collation should use the *_cs variants. For
>>>> existing MySQL installations, an ALTER TABLE ... MODIFY COLUMN ...
>>>> CHARACTER SET ... COLLATION ... *_cs would need to be done for
>>>> affected tables.
>>>>
>>>> -jay
>>>>
>>>> On Tue, Jan 10, 2012 at 4:15 PM, Nachi Ueno
>>>> <ueno.nachi@xxxxxxxxxxxxxxxxxxxx> wrote:
>>>>> Hi folks
>>>>>
>>>>> Nova,Keystone,Glance uses RDBMS and they use unique key constraints.
>>>>> Nowadays, we can use Mysql,Sqlite,Postgresql.
>>>>> Unfortunately, the unique key behaviors of each DB are different.
>>>>>
>>>>> - Mysql : case-insensitive
>>>>> - Sqlite : case-sensitive
>>>>> - Postgresql : case-sensitive
>>>>>
>>>>> I wanna know the spec of OpenStack.
>>>>> Unique key is case-sensitive or *in*sensitive?
>>>>>
>>>>> Cheers
>>>>> Nati
>>>>>
>>>>> _______________________________________________
>>>>> Mailing list: https://launchpad.net/~openstack
>>>>> Post to     : openstack@xxxxxxxxxxxxxxxxxxx
>>>>> Unsubscribe : https://launchpad.net/~openstack
>>>>> More help   : https://help.launchpad.net/ListHelp
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~openstack
>> Post to     : openstack@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~openstack
>> More help   : https://help.launchpad.net/ListHelp
>>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~openstack
> Post to     : openstack@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~openstack
> More help   : https://help.launchpad.net/ListHelp