<div dir="ltr">Wow such a hot topic... <div>I'm also the one who voted for 9.2. But I also voted like Alexey S., "I'm conservative..." - I am actually mostly conservative, and would question every new cool tool/feature of library unless there is a very good proof on using it. You can't build a product which will have 90% of cool pars designed over the last year, that's the reason I'm conservative here too.</div><div><br></div><div>Then I learned that we actually had 9.3 before, and now asking if we want to downgrade to 9.2. My answer is _NO_ under any circumstances to such changes after Feature Freeze. We've been running lots of installs on 9.3, and it is too late to change package version after FF from risk management perspectives. Whether it is downgrade or upgrade.</div><div><br></div><div>We could consider downgrading in Fuel 9.0, but I'd very carefully consider that. As Vladimir Kuklin said, there are may be other users who already rely on 9.3 for some of their enhancements.</div><div><br></div><div>Good question from Julien - even though we are unlikely to replace Postgres by something else in Fuel, we should still try to use as less postgres-specific features as possible. Reason is that we might want to make HA for DB layer some day. In case of MySQL, we can take our existing ocf scripts for Galera. In case of Postgres, we would have to learn how to make it HA.</div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr">On Tue, Dec 15, 2015 at 2:48 PM Alexey Shtokolov <<a href="mailto:ashtokolov@mirantis.com">ashtokolov@mirantis.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Dmitry, <div><br></div><div>Thank you for this document!</div><div>Please move it on <a href="https://etherpad.openstack.org" target="_blank">https://etherpad.openstack.org</a> to make it accessible</div><div><br></div><div><div class="gmail_extra" style="font-size:13px">Best regards,</div><div class="gmail_extra" style="font-size:13px">Alexey Shtokolov</div></div></div><div dir="ltr"><div class="gmail_extra"><br><div class="gmail_quote">2015-12-16 1:38 GMT+03:00 Dmitry Teselkin <span dir="ltr"><<a href="mailto:dteselkin@mirantis.com" target="_blank">dteselkin@mirantis.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hello,<br>
<br>
I made an attempt to gather all valuable points 'for' and 'against'<br>
9.2.x in one document [1]. Please take a look on it, I also put some<br>
comments there to keep everything in one place. I believe this can help<br>
us to make deliberated decision.<br>
<br>
Please add more pros / cons there as I don't pretend to make a<br>
full picture at the first attempt.<br>
<br>
Just in case, I'd prefer to 'downgrade' to 9.2 :)<br>
<br>
[1] <a href="https://etherpad.mirantis.net/p/7ZUruwlwJM" rel="noreferrer" target="_blank">https://etherpad.mirantis.net/p/7ZUruwlwJM</a><br>
<div><div><br>
On Tue, 15 Dec 2015 20:47:41 +0200<br>
Igor Kalnitsky <<a href="mailto:ikalnitsky@mirantis.com" target="_blank">ikalnitsky@mirantis.com</a>> wrote:<br>
<br>
> FYI: so far (according to poll [1]) we have<br>
><br>
> * 11 votes for keeping 9.2<br>
> * 4 votes for restoring 9.3<br>
><br>
> [1]<br>
> <a href="https://docs.google.com/spreadsheets/d/1RNcEVFsg7GdHIXlJl-6LCELhlwQ_zmTbd40Bk_jH1m4/edit?usp=sharing" rel="noreferrer" target="_blank">https://docs.google.com/spreadsheets/d/1RNcEVFsg7GdHIXlJl-6LCELhlwQ_zmTbd40Bk_jH1m4/edit?usp=sharing</a><br>
><br>
> On Tue, Dec 15, 2015 at 8:34 PM, Vladimir Kuklin<br>
> <<a href="mailto:vkuklin@mirantis.com" target="_blank">vkuklin@mirantis.com</a>> wrote:<br>
> > Folks<br>
> ><br>
> > Let me add my 2c here.<br>
> ><br>
> > I am for using Postgres 9.3. Here is an additional argument to the<br>
> > ones provided by Artem, Aleksandra and others.<br>
> ><br>
> > Fuel is being sometimes highly customized by our users for their<br>
> > specific needs. It has been Postgres 9.3 for a while and they might<br>
> > have as well gotten used to it and assumed by default that this<br>
> > would not change. So some of their respective features they are<br>
> > developing for their own sake may depend on Postgres 9.3 and we<br>
> > will never be able to tell the fraction of such use cases.<br>
> > Moreover, downgrading DBMS version of Fuel should be inevitably<br>
> > considered as a 'deprecation' of some features our software suite<br>
> > is providing to our users. This actually means that we MUST provide<br>
> > our users with a warning and deprecation period to allow them to<br>
> > adjust to these changes. Obviously, accidental change of Postgres<br>
> > version does not follow such a policy in any way. So I see no other<br>
> > ways except for getting back to Postgres 9.3.<br>
> ><br>
> ><br>
> > On Tue, Dec 15, 2015 at 7:39 PM, Igor Kalnitsky<br>
> > <<a href="mailto:ikalnitsky@mirantis.com" target="_blank">ikalnitsky@mirantis.com</a>> wrote:<br>
> >><br>
> >> Hey Mike,<br>
> >><br>
> >> Thanks for your input.<br>
> >><br>
> >> > actually not. if you replace your ARRAY columns with JSON<br>
> >> > entirely,<br>
> >><br>
> >> It still needs to fix the code, i.e. change ARRAY-specific queries<br>
> >> with JSON ones around the code. ;)<br>
> >><br>
> >> > there's already a mostly finished PR for SQLAlchemy support in<br>
> >> > the queue.<br>
> >><br>
> >> Does it mean SQLAlchemy will have one unified interface to make<br>
> >> JSON queries? So we can use different backends if necessary?<br>
> >><br>
> >> Thanks,<br>
> >> - Igor<br>
> >><br>
> >> On Tue, Dec 15, 2015 at 5:06 PM, Mike Bayer <<a href="mailto:mbayer@redhat.com" target="_blank">mbayer@redhat.com</a>><br>
> >> wrote:<br>
> >> ><br>
> >> ><br>
> >> > On 12/15/2015 07:20 AM, Igor Kalnitsky wrote:<br>
> >> >> Hey Julien,<br>
> >> >><br>
> >> >>><br>
> >> >>> <a href="https://blueprints.launchpad.net/fuel/+spec/openstack-ha-fuel-postgresql" rel="noreferrer" target="_blank">https://blueprints.launchpad.net/fuel/+spec/openstack-ha-fuel-postgresql</a><br>
> >> >><br>
> >> >> I believe this blueprint is about DB for OpenStack cloud (we use<br>
> >> >> Galera now), while here we're talking about DB backend for Fuel<br>
> >> >> itself. Fuel has a separate node (so called Fuel Master) and we<br>
> >> >> use PostgreSQL now.<br>
> >> >><br>
> >> >>> does that mean Fuel is only going to be able to run with<br>
> >> >>> PostgreSQL?<br>
> >> >><br>
> >> >> Unfortunately we already tied up to PostgreSQL. For instance,<br>
> >> >> we use PostgreSQL's ARRAY column type. Introducing JSON column<br>
> >> >> is one more way to tighten knots harder.<br>
> >> ><br>
> >> > actually not. if you replace your ARRAY columns with JSON<br>
> >> > entirely, MySQL has JSON as well now:<br>
> >> > <a href="https://dev.mysql.com/doc/refman/5.7/en/json.html" rel="noreferrer" target="_blank">https://dev.mysql.com/doc/refman/5.7/en/json.html</a><br>
> >> ><br>
> >> > there's already a mostly finished PR for SQLAlchemy support in<br>
> >> > the queue.<br>
> >> ><br>
> >> ><br>
> >> ><br>
> >> >><br>
> >> >> - Igor<br>
> >> >><br>
> >> >> On Tue, Dec 15, 2015 at 12:28 PM, Julien Danjou<br>
> >> >> <<a href="mailto:julien@danjou.info" target="_blank">julien@danjou.info</a>> wrote:<br>
> >> >>> On Mon, Dec 14 2015, Igor Kalnitsky wrote:<br>
> >> >>><br>
> >> >>>> The things I want to notice are:<br>
> >> >>>><br>
> >> >>>> * Currently we aren't tied up to PostgreSQL 9.3.<br>
> >> >>>> * There's a patch [2] that ties Fuel up to PostgreSQL 9.3+ by<br>
> >> >>>> using a set of JSON operations.<br>
> >> >>><br>
> >> >>> I'm curious and have just a small side question: does that<br>
> >> >>> mean Fuel is<br>
> >> >>> only going to be able to run with PostgreSQL?<br>
> >> >>><br>
> >> >>> I also see<br>
> >> >>><br>
> >> >>> <a href="https://blueprints.launchpad.net/fuel/+spec/openstack-ha-fuel-postgresql" rel="noreferrer" target="_blank">https://blueprints.launchpad.net/fuel/+spec/openstack-ha-fuel-postgresql</a>,<br>
> >> >>> maybe it's related?<br>
> >> >>><br>
> >> >>> Thanks!<br>
> >> >>><br>
> >> >>> --<br>
> >> >>> Julien Danjou<br>
> >> >>> // Free Software hacker<br>
> >> >>> // <a href="https://julien.danjou.info" rel="noreferrer" target="_blank">https://julien.danjou.info</a><br>
> >> >><br>
> >> >><br>
> >> >> __________________________________________________________________________<br>
> >> >> OpenStack Development Mailing List (not for usage questions)<br>
> >> >> Unsubscribe:<br>
> >> >> <a href="http://OpenStack-dev-request@lists.openstack.org?subject:unsubscribe" rel="noreferrer" target="_blank">OpenStack-dev-request@lists.openstack.org?subject:unsubscribe</a><br>
> >> >> <a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev" rel="noreferrer" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a><br>
> >> >><br>
> >> ><br>
> >> ><br>
> >> > __________________________________________________________________________<br>
> >> > OpenStack Development Mailing List (not for usage questions)<br>
> >> > Unsubscribe:<br>
> >> > <a href="http://OpenStack-dev-request@lists.openstack.org?subject:unsubscribe" rel="noreferrer" target="_blank">OpenStack-dev-request@lists.openstack.org?subject:unsubscribe</a><br>
> >> > <a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev" rel="noreferrer" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a><br>
> >><br>
> >> __________________________________________________________________________<br>
> >> OpenStack Development Mailing List (not for usage questions)<br>
> >> Unsubscribe:<br>
> >> <a href="http://OpenStack-dev-request@lists.openstack.org?subject:unsubscribe" rel="noreferrer" target="_blank">OpenStack-dev-request@lists.openstack.org?subject:unsubscribe</a><br>
> >> <a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev" rel="noreferrer" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a><br>
> ><br>
> ><br>
> ><br>
> ><br>
> > --<br>
> > Yours Faithfully,<br>
> > Vladimir Kuklin,<br>
> > Fuel Library Tech Lead,<br>
> > Mirantis, Inc.<br>
> > +7 (495) 640-49-04<br>
> > +7 (926) 702-39-68<br>
> > Skype kuklinvv<br>
> > 35bk3, Vorontsovskaya Str.<br>
> > Moscow, Russia,<br>
> > <a href="http://www.mirantis.com" rel="noreferrer" target="_blank">www.mirantis.com</a><br>
> > <a href="http://www.mirantis.ru" rel="noreferrer" target="_blank">www.mirantis.ru</a><br>
> > <a href="mailto:vkuklin@mirantis.com" target="_blank">vkuklin@mirantis.com</a><br>
> ><br>
> > __________________________________________________________________________<br>
> > OpenStack Development Mailing List (not for usage questions)<br>
> > Unsubscribe:<br>
> > <a href="http://OpenStack-dev-request@lists.openstack.org?subject:unsubscribe" rel="noreferrer" target="_blank">OpenStack-dev-request@lists.openstack.org?subject:unsubscribe</a><br>
> > <a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev" rel="noreferrer" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a><br>
> ><br>
><br>
> __________________________________________________________________________<br>
> OpenStack Development Mailing List (not for usage questions)<br>
> Unsubscribe:<br>
> <a href="http://OpenStack-dev-request@lists.openstack.org?subject:unsubscribe" rel="noreferrer" target="_blank">OpenStack-dev-request@lists.openstack.org?subject:unsubscribe</a><br>
> <a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev" rel="noreferrer" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a><br>
<br>
<br>
<br>
</div></div><span><font color="#888888">--<br>
Thanks,<br>
Dmitry Teselkin<br>
</font></span><div><div><br>
<br>
__________________________________________________________________________<br>
OpenStack Development Mailing List (not for usage questions)<br>
Unsubscribe: <a href="http://OpenStack-dev-request@lists.openstack.org?subject:unsubscribe" rel="noreferrer" target="_blank">OpenStack-dev-request@lists.openstack.org?subject:unsubscribe</a><br>
<a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev" rel="noreferrer" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a></div></div></blockquote></div>
</div></div>
__________________________________________________________________________<br>
OpenStack Development Mailing List (not for usage questions)<br>
Unsubscribe: <a href="http://OpenStack-dev-request@lists.openstack.org?subject:unsubscribe" rel="noreferrer" target="_blank">OpenStack-dev-request@lists.openstack.org?subject:unsubscribe</a><br>
<a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev" rel="noreferrer" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a><br>
</blockquote></div><div dir="ltr">-- <br></div><div dir="ltr">Mike Scherbakov<br>#mihgen</div>