launchpad-dev team mailing list archive
-
launchpad-dev team
-
Mailing list archive
-
Message #07657
Re: Please read: new DB schema patch rules
On Sat, Jul 16, 2011 at 1:14 AM, Jeroen Vermeulen <jtv@xxxxxxxxxxxxx> wrote:
> Thank you so much for pushing this through!
My pleasure!
> There _is_ an immediate payoff: your db patch gets deployed much faster.
> We've been aching for this kind of flexibility.
Thats the promised payoff; its not immediate *yet* because Stuart and
I haven't gotten the all the deployment bits together :).
> We'll learn how to write incremental patches. Meeting the 15s goal on a
> cold database will be hard though, since we can't easily reproduce results
> or try out tweaks. It might help if we could break a slave out of
> replication to time a DB patch against a realistic cache.
I should clarify then - what I mean by cold is more of a 'no cheating'
- no running it twice on qastaging within a transaction and then
taking the best time. Run it once, take the time. This is to get as
close as we can approximate to actual-behaviour on prod (though we
should expect prod to be consistently faster :)).
-Rob
Follow ups
References