Magento Two Databases Connection Install

Just in case your store has grown to the size that one single Database server cannot handle the load Magento has the ability to scale your database into Master-Slave figure. Below is how its done.
< config>
    < global>
        ...
        < resources>
            < db>
                < table_prefix>< ![CDATA[prefix_]]>< /table_prefix> < !-- database tables prefix, optional -->
            < /db>
            < default_setup> < !-- master connection -->
                < connection>
                    < host>< ![CDATA[127.0.0.1:3307]]>< /host>
                    < username>< ![CDATA[qa_setup]]>< /username>
                    < password>< ![CDATA[qa_setup]]>< /password>
                    < dbname>< ![CDATA[qa_magento_1_4_1_0]]>< /dbname>
                    < active>1< /active>
                < /connection>
            < /default_setup>
            < default_read> < !-- slave connection - to the "read-only" database -->
                < connection>
                    < host>< ![CDATA[192.168.0.14:3307]]>< /host>
                    < username>< ![CDATA[qa_read]]>< /username>
                    < password>< ![CDATA[qa_read]]>< /password>
                    < dbname>< ![CDATA[qa_magento_1_4_1_0]]>< /dbname>
                    < active>1< /active>
                    < model>mysql4< /model>
                    < initStatements>SET NAMES utf8< /initStatements>
                    < type>pdo_mysql< /type>
                    < use />
                < /connection>
            < /default_read>
        < /resources>
        ...
    < /global>
< /config>
Cheers!

We Love Our Customers

    Team of US based Certified Magento Engineers will work directly with you (no middle-men) to make sure MagePhobia provides best quality technical services. Some of our Magento Engineers are ex-Magento employees who built Magento for several years and know Magento inside-out.
    MagePhobia provides affordable
Magento Services with one of the best quality on the market.
    Our US based Technical Support is provided exclusively by our Certified Magento Developers and System Administrators, and is available 24/7 via ticketing, chat, and phone.
    MagePhobia offers short and long-term contracts as well as 'per job' basis contracts. We refund in case of unsatisfactory results which, we believe, will not occur ever.

We are all-in for customer satisfaction!