<div dir="ltr">Igor<div><br></div><div>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.</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Dec 15, 2015 at 9:47 PM, Igor Kalnitsky <span dir="ltr"><<a href="mailto:ikalnitsky@mirantis.com" target="_blank">ikalnitsky@mirantis.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">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] <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>
<div class="HOEnZb"><div class="h5"><br>
On Tue, Dec 15, 2015 at 8:34 PM, Vladimir Kuklin <<a href="mailto:vkuklin@mirantis.com">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 ones<br>
> provided by Artem, Aleksandra and others.<br>
><br>
> Fuel is being sometimes highly customized by our users for their specific<br>
> needs. It has been Postgres 9.3 for a while and they might have as well<br>
> gotten used to it and assumed by default that this would not change. So some<br>
> of their respective features they are developing for their own sake may<br>
> depend on Postgres 9.3 and we will never be able to tell the fraction of<br>
> such use cases. Moreover, downgrading DBMS version of Fuel should be<br>
> inevitably considered as a 'deprecation' of some features our software suite<br>
> is providing to our users. This actually means that we MUST provide our<br>
> users with a warning and deprecation period to allow them to adjust to these<br>
> changes. Obviously, accidental change of Postgres version does not follow<br>
> such a policy in any way. So I see no other ways except for getting back to<br>
> Postgres 9.3.<br>
><br>
><br>
> On Tue, Dec 15, 2015 at 7:39 PM, Igor Kalnitsky <<a href="mailto:ikalnitsky@mirantis.com">ikalnitsky@mirantis.com</a>><br>
> wrote:<br>
>><br>
>> Hey Mike,<br>
>><br>
>> Thanks for your input.<br>
>><br>
>> > actually not. if you replace your ARRAY columns with JSON 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 the<br>
>> > queue.<br>
>><br>
>> Does it mean SQLAlchemy will have one unified interface to make JSON<br>
>> 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">mbayer@redhat.com</a>> 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 use<br>
>> >> PostgreSQL now.<br>
>> >><br>
>> >>> does that mean Fuel is only going to be able to run with PostgreSQL?<br>
>> >><br>
>> >> Unfortunately we already tied up to PostgreSQL. For instance, we use<br>
>> >> PostgreSQL's ARRAY column type. Introducing JSON column is one more<br>
>> >> way to tighten knots harder.<br>
>> ><br>
>> > actually not. if you replace your ARRAY columns with JSON entirely,<br>
>> > 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 the<br>
>> > queue.<br>
>> ><br>
>> ><br>
>> ><br>
>> >><br>
>> >> - Igor<br>
>> >><br>
>> >> On Tue, Dec 15, 2015 at 12:28 PM, Julien Danjou <<a href="mailto:julien@danjou.info">julien@danjou.info</a>><br>
>> >> 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 using a<br>
>> >>>> set of JSON operations.<br>
>> >>><br>
>> >>> I'm curious and have just a small side question: does that mean Fuel<br>
>> >>> 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: <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>
> <a href="tel:%2B7%20%28495%29%20640-49-04" value="+74956404904">+7 (495) 640-49-04</a><br>
> <a href="tel:%2B7%20%28926%29%20702-39-68" value="+79267023968">+7 (926) 702-39-68</a><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">vkuklin@mirantis.com</a><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><br>
><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><br>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature"><div dir="ltr"><div><div dir="ltr">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.ru/" target="_blank">www.mirantis.com</a><br><a href="http://www.mirantis.ru/" target="_blank">www.mirantis.ru</a><br><a href="mailto:vkuklin@mirantis.com" target="_blank">vkuklin@mirantis.com</a></div></div></div></div>
</div>