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

Ihar Hrachyshka ihrachys at redhat.com
Wed Jun 17 16:39:10 UTC 2015


-----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 layer that will make sure
>> that data is migrated into new schema fields and objects, while
>> preserving data originally stored in 'old' schema elements.
>> 
>> That would allow old neutron-server code to run against new
>> schema (it will just ignore new additions); and new
>> neutron-server code to gradually migrate data into new
>> columns/fields/tables while serving user s.
> Hi Ihar -
> 
> I was in the middle of writing a spec for neutron online schema 
> migrations, which maintains "expand / contract" workflow but also 
> maintains Alembic migration scripts.   As I've stated many times in
> the past, there is no reason to abandon migration scripts, while
> there are many issues related to abandoning the notion of the
> database in a specific versioned state as well as the ability to
> script any migrations whatsoever.   The spec amends Nova's approach
> and includes upstream changes to Alembic such that both approaches
> can be supported using the same codebase.
> 

I probably don't follow completely. It was not my intent to propose
complete abandonment of migration scripts. In any case, eagerly
waiting for your proposal in gerrit. :)

Note that now that neutron process leans more to RFEs in Launchpad, it
may be the case that a better place for the description of your
proposal is in neutron's devref. Anyway, we'll see.

Ihar
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2

iQEcBAEBCAAGBQJVgaKrAAoJEC5aWaUY1u574o0H/0C84GFx16w62k59UZEtLv/J
jwf4dxxQi0tEx1+cGpmYje4Yn56KqMYPhuZ/woFmAJ4o2WWO+qLD9Mi4Mmc91MiD
xY4oLbHriNmMoDpgzLoib17aOIbFSMuwi5fyBJUP8Hu2/3in1N5c0iuHIXnLV/i+
szB8LdJTd1FBIfbcQMPll1IZNCo0D4V+HGoFFtFQOcls9L4TAsEs8AkMR54zZXio
MGhTGj+9VhxJlpL7k6zeCukVtdgFiqWzbWXUh+/fZuInhVnsWGMAxnr3cFEaTKmT
0Ju5Hf/9np4nmlKFpY7L5hxnGXyQjSlgRmuAAr/BlP5fvhuZrUxGRVp2ZoXoRXo=
=QW/o
-----END PGP SIGNATURE-----



More information about the OpenStack-dev mailing list