Re: [openstack-dev] [neutron][db] online schema upgrades

2015-06-18 Thread Mike Bayer
my initial proposal for scripted expand/contract migrations is up: https://review.openstack.org/#/c/192937/ On 6/18/15 5:54 AM, Anna Kamyshnikova wrote: On Wed, Jun 17, 2015 at 8:23 PM, Mike Bayer mba...@redhat.com mailto:mba...@redhat.com wrote: On 6/17/15 12:40 PM, Ihar

Re: [openstack-dev] [neutron][db] online schema upgrades

2015-06-18 Thread Anna Kamyshnikova
On Wed, Jun 17, 2015 at 8:23 PM, Mike Bayer mba...@redhat.com wrote: On 6/17/15 12:40 PM, Ihar Hrachyshka wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA256 On 06/17/2015 11:27 AM, Anna Kamyshnikova wrote: Ihar, thanks for bringing this up! This is very interesting and I think it

Re: [openstack-dev] [neutron][db] online schema upgrades

2015-06-17 Thread Mike Bayer
On 6/17/15 12:40 PM, Ihar Hrachyshka wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA256 On 06/17/2015 11:27 AM, Anna Kamyshnikova wrote: Ihar, thanks for bringing this up! This is very interesting and I think it worth trying. I'm +1 on that and want to participate in this work.

Re: [openstack-dev] [neutron][db] online schema upgrades

2015-06-17 Thread Anna Kamyshnikova
Ihar, thanks for bringing this up! This is very interesting and I think it worth trying. I'm +1 on that and want to participate in this work. In fact a lot *not strict* migrations are removed with juno_initial, so I hope it won't be so hard for now to apply stricter rules for migration. But what

Re: [openstack-dev] [neutron][db] online schema upgrades

2015-06-17 Thread Ihar Hrachyshka
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 On 06/16/2015 05:58 PM, Mike Bayer wrote: On 6/16/15 11:41 AM, Ihar Hrachyshka wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA256 - - instead of migrating data with alembic rules, migrate it in runtime. There should be a abstraction

Re: [openstack-dev] [neutron][db] online schema upgrades

2015-06-17 Thread Ihar Hrachyshka
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 On 06/17/2015 11:27 AM, Anna Kamyshnikova wrote: Ihar, thanks for bringing this up! This is very interesting and I think it worth trying. I'm +1 on that and want to participate in this work. Awesome. In fact a lot *not strict* migrations

[openstack-dev] [neutron][db] online schema upgrades

2015-06-16 Thread Ihar Hrachyshka
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Hi neutron folks, I'd like to discuss a plan on getting support for online db schema upgrades in neutron. *What is it even about?* Currently, any major version upgrade, or master-to-master upgrade, requires neutron-server shutdown. After

Re: [openstack-dev] [neutron][db] online schema upgrades

2015-06-16 Thread Mike Bayer
On 6/16/15 11:41 AM, Ihar Hrachyshka wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA256 - - instead of migrating data with alembic rules, migrate it in runtime. There should be a abstraction layer that will make sure that data is migrated into new schema fields and objects, while