OneFreeVoice

December 20, 2008

Continuous Integration is Not New!

Filed under: MySQL — Gregory Haase @ 1:57 am

There is no news flash: Continuous Integration is not new. It will, however, get a significant amount of attention during my upcoming tutorial session at the MySQL User Conference in April, where I am very pleased to be presenting Build and Release Management for Database Engineers

I’m going to be talking about change management for databases. I’m going to talk about grouping sets of database changes together in unified releases. I’m going to talk about how these coordinate with changes in the applications that utilize your databases. I’m going to talk about how to fit your DDL, DML, views, triggers, routines and events into source control. Even more importantly, I’m going to talk about how to test these things. I’m going to talk about methods for creating multiple database instances to support application development staff without breaking the backs of your DBAs. I’m going to talk about automation. And then I’m going to talk about migrating your database changes logically through development to QA and then finally to production.

The bottom line: New tools such as MySQL Sandbox and Bazaar give us a chance to revisit release management, allowing us to come up with innovative ways to revise, automate, and streamline our processes.  The result should be reduced hassle and increased confidence each time you have to release changes into your application’s production database.

Over the next few months, I’m going to be finalizing my presentation materials, and I’ll be posting my thoughts here. I’m sure there are a lot of people out there that have good experience in the subject matter. I welcome your comments and contributions.

One last small bit of housekeeping: I recently changed employment, and I am no longer working at Lotame Solutions, Inc. Although I have updated my profile information with the conference site, several pages are still showing my old company and my old bio. I am now a Database Developer at Bill Me Later, Inc., an eBay company.

About these ads

3 Comments »

  1. Hi,

    I wish I could be at this conference but unfortunately I am from South Africa and won’t be able to attend. We have an extremely complicated database structure as multiple versions of the same database are being developed in parallel and not necessarily released sequentially. I am particulary interested in your section about “can simplify life by allowing one to easily manage multiple databases for each ongoing branch of database development on a single server.” Please could you share some more information with regards to creating and managing multiple database instances and the automation there of?

    Thanks
    Debbie

    Comment by Debbie — January 6, 2009 @ 9:47 am

  2. I will be blogging more about this in the near future, and I will have my whole presentation and some supporting scripts online – if not before the conference – immediately after.

    The short answer is – you can either use mysqld_multi or mysql_sandbox to run multiple instances on a single server. Things to remember – you will need adequate memory and disk to support all your concurrent databases, and unless you have lots of spindles of very fast disks, you are going to have slow performance if lots of people are running lots of queries on the lots of databases on the same server.

    Comment by Gregory Haase — January 6, 2009 @ 3:15 pm

  3. Debbie/Gregory.
    Coming soon??

    L8tr.

    Comment by Tukam Dixon — January 24, 2009 @ 10:27 pm


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

The Silver is the New Black Theme Blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: