Open Stack

Igor

Sorry, this vote is irrelevant as it is not about all the concerns rasied
by Artem, Aleksandra and me. It is about JSON vs non-JSON Postgres which is
not exactly the case.

On Tue, Dec 15, 2015 at 9:47 PM, 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
>



-- 
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 <http://www.mirantis.ru/>
www.mirantis.ru
vkuklin at mirantis.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20151215/99a05d15/attachment.html>