Agiles Arbeiten mit Scrum, Kanban usw. bildet seit Jahren meinen beruflichen Schwerpunkt. In diesem kurzen Blogpost können Sie mehr darüber erfahren.

Die übrigen Inhalte dienen als Museum (leider ohne die frühere schicke Optik).

Doctrine Master Slave Setup for Symfony 2.1

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.html

Here’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!


Beitrag veröffentlicht

in

,

von

Schlagwörter: