[FLOW3-general] What is MasterSlaveConnection?

[Alexander Berl]

Hi Robin,

The MasterSlaveConnection class is used for a Master-Slave replication setup in your database layer.
You can read more on that by googling, but a short summary is this:

You have multiple database servers of which one is the designated "Master" and all others are "Slave". Those servers are synced by "replication".
The Master is responsible for all queries that change the database (ie. Update, insert, etc.), while all read-only queries are split on the slaves (up to the point where the first write query happens,
from where only the Master will be used to avoid replication-lag issues).

So at the end, this is only an option to increase scalability of a database layer, but not to have different databases connected in one application.


_________________________________________________________________________________________________________________________
Alexander Berl
Senior Developer

We're hiring!<http://www.eol.de/jobs>

EOL Group GmbH
Siemensstraße 3
35463 Fernwald-Annerod
Germany

Tel.:     +49 (0) 641 46092 - 0
Mobil:   +49 (0) 172 6376384
Fax:      +49 (0) 641 46092 - 199

E-Mail:  a.berl at eol.de<mailto:a.berl at eol.de>
Web:    www.eol.de<http://www.eol.de/>