symfony/symfony — Issue #2696: Master-slave database support
Author: pulzarraider
Created: 2011-11-22 22:40:54+00:00
State: open

Master-slave database architecture is used in a lot in bigger companies. MySQL and Postgress have support for master-slave replication. The main idea of this architecture is to send select querys to slave(s) and insert/update/delete querys to master. Slave is after some small time synchronized with master. This architecture can improve performance a lot.

Correct me if I'm wrong: Doctrine doesn't have master-slave support yet. There is (old) opened ticket for DBAL connection resolver with interesting comments and solutions, but there is no official solution, see http://www.doctrine-project.org/jira/browse/DBAL-20

We can put master-slave support (connection resolver) inside Doctrine bridge or somewhere else to get master-slave working if will be enabled in config files.

Because outside our small Symfony world it seems that Symfony (with Doctrine DBAL = prefered database choice) doesn't have master-slave support and everybody have to make some hacks and reinvent the wheel again and again to get this work.