nova-database team mailing list archive

[Monty Taylor <mordred@xxxxxxxxxxxx>]

I mainly was just thinking that for the cases where someone wants to use
MySQL as the sqlalchemy backend, perhaps using the pure-python driver
might be a better choice than the one that's based on libmysqlclient.
Sqlalchemy already supports it, and it's actually well tested - it just
has a full-time dev on it now. (I certainly wasn't suggesting that we
ditch sqlalchemy. :) The only real change here would be changing the
dburi configured to:

mysql+mysqlconnector://<user>:<password>@<host>[:<port>]/<dbname>

from

mysql://<user>:<password>@<host>[:<port>]/<dbname>

If it winds up being a good choice, then great. If not, then great. :)

On 11/01/2011 02:54 AM, Christopher MacGown wrote:
> In light of the context of the DB api cleanup, and Jesse's desire that
> we implement a zookeeper (or zookeeper like) db backend, does it really
> make sense to bother with a native Python mysql client? The reason we're
> using SQLalchemy at all is that we're not tied to a particular DB server
> on the backend, switching to this seems a step backward, especially if
> it's untested.
> 
> 
> Christopher MacGown
> Piston Cloud Computing, Inc.
> w: (650) 24-CLOUD
> m: (415) 300-0944
> chris@xxxxxxxxxxxxxxx <mailto:chris@xxxxxxxxxxxxxxx>
> 
> On Oct 31, 2011, at 7:12 PM, Monty Taylor wrote:
> 
>> Hey all!
>>
>> I mentioned this at a little around ODS time, but there is a pure python
>> MySQL driver (connector/python) that Geert Vanderlaken (formerly of
>> MySQL now of Oracle) wrote. Up until just recently, it's been something
>> he's been working on in his spare time. However, Oracle have just
>> changed his job so that he can work on it full time.
>>
>> SO - it seems like given the eventlet fun we have, perhaps giving it a
>> try, seeing how it goes and if there are any issues with it reporting
>> them back to geert might not be the world's worst thing to try.
>>
>> FWIW,
>>
>> Monty
>>
>> -- 
>> Mailing list: https://launchpad.net/~nova-database
>> Post to     : nova-database@xxxxxxxxxxxxxxxxxxx
>> <mailto:nova-database@xxxxxxxxxxxxxxxxxxx>
>> Unsubscribe : https://launchpad.net/~nova-database
>> More help   : https://help.launchpad.net/ListHelp
>