Vagrant-based deployment?

Hi, folks,

I know that tizzo and others use vagrant, and I'm starting to drink the kool-aid. Anyone have a tutorial about how to manage multiple tiers? For example, when I work on a project locally, I want to point at my local database, but if I'm doing an update to an existing production site, I want to push out a new AWS EC2 (or whatever) that points to the production database. I presume I do this with puppet somehow, but if anyone has some best practices or tutorials, I'd be very grateful. Cheers,

-Larry