I have a site that runs on 4 different sites during its lifecycle, e.g. my local machine, dev (where its merged with other developer changes), staging (client review) and live. Usually in projects I would put a switch in the configuration on the domain name so that the correct configuration values are used on the right domain. Magento uses the local.xml file, is it possible to configure the magento local.xml file to have different configuration values depending on the domain name?
Current XML Config
<default_setup>
<connection>
<host><![CDATA[myhost]]></host>
<username><![CDATA[myuser]]></username>
<password><![CDATA[mypassword]]></password>
<dbname><![CDATA[mydatabase]]></dbname>
<active>1</active>
</connection>
</default_setup>