What is Drupal 7 How to configure database settings for different environments?

Question

I'm already used to testing $ _SEVER ['HTTP_HOST'], and then I select a different set of settings, for example:

 switch ($_SERVER['HTTP_HOST']) {
      case 'prod.myserver.com':
           $database = "settings for prod";
           break;
      case 'stage.myserver.com':
           $database = "settings for staging";
           break;
      case 'dev.myserver.com':
           $database = "settings for dev";
           break;
}

The new setting in settings.php makes it look like a more complicated way. There is?

Answer 1

sites.php looks like what you are looking for

$sites = array(
  'prod.myserver.com' => 'prod',
  'stage.myserver.com' => 'stage',
  'dev.myserver.com' => 'dev'
);

then you can create

/sites/prod/settings.php
/sites/stage/settings.php
/sites/dev/settings.php

See http://api.drupal.org/api/drupal/sites--example.sites.php/7