Marc-Aurele, you are totally right and people agree with you but no one seems 
to give this priority

daan.hoogl...@shapeblue.com 
www.shapeblue.com
53 Chandos Place, Covent Garden, Utrecht Utrecht 3531 VENetherlands
@shapeblue
  
 


-----Original Message-----
From: Marc-Aurèle Brothier [mailto:ma...@exoscale.ch] 
Sent: 21 February 2017 10:04
To: dev@cloudstack.apache.org
Subject: Re: Handling of DB migrations on forks

IMO the database changes should be idempotent as much as possible with "CREATE 
OR REPLACE VIEW..." "DROP IF EXISTS....". For other things like altering a 
table, it's more complicated to achieve that in pure SQL.
A good call would be to integrate http://www.liquibase.org/ to manage the 
schema and changes in a more descriptive way which allows branches/merges.

On Tue, Feb 21, 2017 at 9:46 AM, Daan Hoogland <daan.hoogl...@gmail.com>
wrote:

> Good strategy and I would make that not a warning but a fatal, as the 
> resulting ACS version will probably not work.
>
> On Tue, Feb 14, 2017 at 12:16 PM, Wei ZHOU <ustcweiz...@gmail.com> wrote:
> > Then you have to create your own branch forked from 4.10.0
> >
> > In our branch, I moved some table changes (eg ALTER TABLE, CREATE 
> > TABLE) from schema-****.sql to 
> > engine/schema/src/com/cloud/upgrade/dao/UpgradeXXXtoYYY.java.
> > If SQLException is throwed, then show a warning message instead 
> > upgrade interruption..
> > By this way, the database will not be broken in the upgrade or fresh 
> > installation.
> >
> > -Wei
> >
> >
> > 2017-02-14 11:52 GMT+01:00 Jeff Hair <j...@greenqloud.com>:
> >
> >> Hi all,
> >>
> >> Many people in the CS community maintain forks of CloudStack, and 
> >> might have implemented features or bug fixes long before they get 
> >> into
> mainline.
> >> I'm curious as to how people handle database migrations with their
> forks.
> >> To make a DB migration, the CS version must be updated. If a 
> >> developer
> adds
> >> a migration to their fork on say, version 4.8.5. Later, they decide 
> >> to upgrade to 4.10.0 which has their migration in the schema 
> >> upgrade to 4.10.0.
> >>
> >> How do people handle this? As far as I know, CS will crash on the 
> >> DB upgrade due to SQL errors. Do people just sanitize migrations 
> >> when they pull from downstream or somehting?
> >>
> >> Jeff
> >>
>
>
>
> --
> Daan
>

Reply via email to