incubator-cloudstack-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alex Huang <Alex.Hu...@citrix.com>
Subject RE: schema maintenance
Date Tue, 14 Aug 2012 01:34:10 GMT


> -----Original Message-----
> From: Darren Shepherd [mailto:darren@godaddy.com]
> Sent: Monday, August 13, 2012 5:07 PM
> To: cloudstack-dev@incubator.apache.org
> Subject: schema maintenance
> 
> Has there been any talk about not maintaining a monolithic
> create_schema.sql and doing a more DB migrate style?  From a supportability
> perspective its way easier if your SQL is just always deltas from the last.  For
> example, you ship version 1 and create schema1.sql.  Version 2 you add
> some stuff so you create a schema2.sql that adds what you need to the
> database (just delta).  So if somebody installs from scratch they run
> schema1.sql and schema2.sql.  If you already have version 1, you just run
> schema2.sql.
> 
> This is an extremely common approach and cuts down the need to test the
> DB from scratch and upgrade.

+1 I would love to do this.  The current cloudstack upgrade procedure is the precursor to
this.  However, we never got around to complete the actual work.

--Alex

Mime
View raw message