gistfile1.rb

### recipe
# This file should be in .../cookbooks/database/recipes/default.rb

if ['solo', 'app_master', 'app', 'util'].include?(node[:instance_role])
  # for each application
  node[:engineyard][:environment][:apps].each do |app|

    # create new database.yml
    template "/data/#{app[:name]}/shared/config/database.yml" do
      source 'database.yml.erb'
      owner node[:users][0][:username]
      group node[:users][0][:username]
      mode 0644
      variables({
        :environment => node[:environment][:framework_env],
        :adapter => 'mysql2',
        :database => app[:database_name],
        :username => node[:users][0][:username],
        :password => node[:users][0][:password],
        :host => node[:db_host],

        :vd => {
          :adapter => 'mysql2',
          :database => x ,
          :username => xx,
          :password => xxx,
          :host => xxxx,
        },

        :ms => {
          :adapter => 123123123,
          :host => 123123123123,
          :database => 123123123,
          :username => 123123123,
          :password => 123123123,
          :port => 123123123,
          :pool => 123123123
        }
      })
    end
  end
end


### template
# This file should be in .../cookbooks/database/templates/default/database.yml.erb

<%= @environment %>:
  adapter:   <%= @adapter %>
  database:  <%= @database %>
  username:  <%= @username %>
  password:  <%= @password %>
  host:      <%= @host %>

vd_<%= @environment %>:
  adapter:   <%= @vd[:adapter] %>
  database:  <%= @vd[:database] %>
  username:  <%= @vd[:username] %>
  password:  <%= @vd[:password] %>
  host:      <%= @vd[:host] %>

ms_<%= @environment %>:
  adapter:  <%= @ms[:adapter] %>
  host:     <%= @ms[:host] %>
  database: <%= @ms[:database] %>
  username: <%= @ms[:username] %>
  password: <%= @ms[:password] %>
  port:     <%= @ms[:port] %>
  pool:     <%= @ms[:pool] %>