[Openstack-operators] [all] SQL Schema Downgrades: A Good Idea?
    Jonathan Proulx 
    jon at jonproulx.com
       
    Fri Jan 30 19:25:22 UTC 2015
    
    
  
I had the misfortune of doing an in production roll back,
grizzly->havana->grizzly I think, though thankfuly before anything new
had occurred after upgrade...
Restore from DB dump is what I did and what I'd do again. For all
reasons previously stated programatic reverse migration just doesn't
make sense.
On Fri, Jan 30, 2015 at 2:15 PM, Jay Pipes <jaypipes at gmail.com> wrote:
> Specifically for database migrations, I always recommend that running
> database schema migrations be:
>
>  * a forward-only process
>  * pre-tested against a copy of the production database
^ that right there is key ;)
>  * if anything at all goes wrong with the upgrade schema migrations, simply
> restore from a backup taken immediately before upgrades are done.
yup!
-Jon
    
    
More information about the OpenStack-operators
mailing list