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

Artem Silenkov asilenkov at mirantis.com
Tue Dec 15 15:33:33 UTC 2015


Hello!

We use mysql-wsrep-5.6 which is latest for galera.
It is based on MySQL-5.6.27.
So JSON features here is not available yet.

Regards,
Artem Silenkov
---
MOS-Packaging

On Tue, Dec 15, 2015 at 6:06 PM, Mike Bayer <mbayer at redhat.com> wrote:

>
>
> 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
> >
>
> __________________________________________________________________________
> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20151215/db1e7e11/attachment.html>


More information about the OpenStack-dev mailing list