php-schulung.de

Doctrine Master Slave Setup for Symfony 2.1

By am 21.01.2013 in Blog, Symfony

In his talk at Symfony Live in Berlin, Benjamin Eberlei mentioned that Doctrine now supports connecting to a Master DB + multiple Slaves.How do I configure this behaviour in Symfony2?I searched the web, found some related info but no solution 😐Via the Symfony Users Mailinglist symfony2 @ googlegroups.com (see thread Re: Doctrine Master Slave Connection in Symfony 2?) I quickly received an answer from Benjamin himself that seemed obvious afterwards 😎
If you use „app/console config:dump-reference DoctrineBundle“ you can see how to configure this.
If you read this where you do not have Symfony 2 and Doctrine at hand, you cann also find it here: http://symfony.com/doc/current/reference/configuration/doctrine.htmlHere’s an extract of just the relevant part:
doctrine:
    dbal:
        default_connection:   default
        connections:
            default:
                dbname:               ~
                host:                 192.168.23.42
                port:                 ~
                user:                 icanwrite
                password:             ~
                slaves:
                    slave1:
                        dbname:               ~
                        host:                 192.168.23.43
                        port:                 ~
                        user:                 icanread
                        password:             ~
                    slave2:
                        dbname:               ~
                        host:                 192.168.23.44
                        port:                 ~
                        user:                 icanread
                        password:             ~
            staging:
                dbname:               ~
                host:                 localhost
                port:                 ~
                user:                 root
                password:             ~
Life can be so easy!Enjoy full performance!

Kommentieren

Kommentare bitte per Twitter an @PHP_Schulung senden.