[openstack-dev] [Fuel] PostgreSQL 9.3 and JSON operations

Mike Bayer mbayer at redhat.com
Tue Dec 15 15:06:14 UTC 2015



On 12/15/2015 07:20 AM, Igor Kalnitsky wrote:
> Hey Julien,
> 
>> https://blueprints.launchpad.net/fuel/+spec/openstack-ha-fuel-postgresql
> 
> I believe this blueprint is about DB for OpenStack cloud (we use
> Galera now), while here we're talking about DB backend for Fuel
> itself. Fuel has a separate node (so called Fuel Master) and we use
> PostgreSQL now.
> 
>> does that mean Fuel is only going to be able to run with PostgreSQL?
> 
> Unfortunately we already tied up to PostgreSQL. For instance, we use
> PostgreSQL's ARRAY column type. Introducing JSON column is one more
> way to tighten knots harder.

actually not.  if you replace your ARRAY columns with JSON entirely,
MySQL has JSON as well now:
https://dev.mysql.com/doc/refman/5.7/en/json.html

there's already a mostly finished PR for SQLAlchemy support in the queue.



> 
> - Igor
> 
> On Tue, Dec 15, 2015 at 12:28 PM, Julien Danjou <julien at danjou.info> wrote:
>> On Mon, Dec 14 2015, Igor Kalnitsky wrote:
>>
>>> The things I want to notice are:
>>>
>>> * Currently we aren't tied up to PostgreSQL 9.3.
>>> * There's a patch [2] that ties Fuel up to PostgreSQL 9.3+ by using a
>>> set of JSON operations.
>>
>> I'm curious and have just a small side question: does that mean Fuel is
>> only going to be able to run with PostgreSQL?
>>
>> I also see
>> https://blueprints.launchpad.net/fuel/+spec/openstack-ha-fuel-postgresql,
>> maybe it's related?
>>
>> Thanks!
>>
>> --
>> Julien Danjou
>> // Free Software hacker
>> // https://julien.danjou.info
> 
> __________________________________________________________________________
> OpenStack Development Mailing List (not for usage questions)
> Unsubscribe: OpenStack-dev-request at lists.openstack.org?subject:unsubscribe
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
> 



More information about the OpenStack-dev mailing list