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

Alexey Shtokolov ashtokolov at mirantis.com
Tue Dec 15 22:47:08 UTC 2015


Dmitry,

Thank you for this document!
Please move it on https://etherpad.openstack.org to make it accessible

Best regards,
Alexey Shtokolov

2015-12-16 1:38 GMT+03:00 Dmitry Teselkin <dteselkin at mirantis.com>:

> Hello,
>
> I made an attempt to gather all valuable points 'for' and 'against'
> 9.2.x in one document [1]. Please take a look on it, I also put some
> comments there to keep everything in one place. I believe this can help
> us to make deliberated decision.
>
> Please add more pros / cons there as I don't pretend to make a
> full picture at the first attempt.
>
> Just in case, I'd prefer to 'downgrade' to 9.2 :)
>
> [1] https://etherpad.mirantis.net/p/7ZUruwlwJM
>
> On Tue, 15 Dec 2015 20:47:41 +0200
> Igor Kalnitsky <ikalnitsky at mirantis.com> wrote:
>
> > FYI: so far (according to poll [1]) we have
> >
> > * 11 votes for keeping 9.2
> > * 4 votes for restoring 9.3
> >
> > [1]
> >
> https://docs.google.com/spreadsheets/d/1RNcEVFsg7GdHIXlJl-6LCELhlwQ_zmTbd40Bk_jH1m4/edit?usp=sharing
> >
> > On Tue, Dec 15, 2015 at 8:34 PM, Vladimir Kuklin
> > <vkuklin at mirantis.com> wrote:
> > > Folks
> > >
> > > Let me add my 2c here.
> > >
> > > I am for using Postgres 9.3. Here is an additional argument to the
> > > ones provided by Artem, Aleksandra and others.
> > >
> > > Fuel is being sometimes highly customized by our users for their
> > > specific needs. It has been Postgres 9.3 for a while and they might
> > > have as well gotten used to it and assumed by default that this
> > > would not change. So some of their respective features they are
> > > developing for their own sake may depend on Postgres 9.3 and we
> > > will never be able to tell the fraction of such use cases.
> > > Moreover, downgrading DBMS version of Fuel should be inevitably
> > > considered as a 'deprecation' of some features our software suite
> > > is providing to our users. This actually means that we MUST provide
> > > our users with a warning and deprecation period to allow them to
> > > adjust to these changes. Obviously, accidental change of Postgres
> > > version does not follow such a policy in any way. So I see no other
> > > ways except for getting back to Postgres 9.3.
> > >
> > >
> > > On Tue, Dec 15, 2015 at 7:39 PM, Igor Kalnitsky
> > > <ikalnitsky at mirantis.com> wrote:
> > >>
> > >> Hey Mike,
> > >>
> > >> Thanks for your input.
> > >>
> > >> > actually not.  if you replace your ARRAY columns with JSON
> > >> > entirely,
> > >>
> > >> It still needs to fix the code, i.e. change ARRAY-specific queries
> > >> with JSON ones around the code. ;)
> > >>
> > >> > there's already a mostly finished PR for SQLAlchemy support in
> > >> > the queue.
> > >>
> > >> Does it mean SQLAlchemy will have one unified interface to make
> > >> JSON queries? So we can use different backends if necessary?
> > >>
> > >> Thanks,
> > >> - Igor
> > >>
> > >> On Tue, Dec 15, 2015 at 5: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
> > >>
> > >>
> __________________________________________________________________________
> > >> 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
> > >
> > >
> > >
> > >
> > > --
> > > Yours Faithfully,
> > > Vladimir Kuklin,
> > > Fuel Library Tech Lead,
> > > Mirantis, Inc.
> > > +7 (495) 640-49-04
> > > +7 (926) 702-39-68
> > > Skype kuklinvv
> > > 35bk3, Vorontsovskaya Str.
> > > Moscow, Russia,
> > > www.mirantis.com
> > > www.mirantis.ru
> > > vkuklin at mirantis.com
> > >
> > >
> __________________________________________________________________________
> > > 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
>
>
>
> --
> Thanks,
> Dmitry Teselkin
>
>
> __________________________________________________________________________
> 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/20151216/9deefaf3/attachment.html>


More information about the OpenStack-dev mailing list