You are browsing a version that is no longer maintained.
Maintained
2.10 (upcoming) 2.9.1 (current)
Unmaintained
2.8 2.7 2.6 2.5 2.4 2.3 2.2 2.1 2.0 1.3 1.2 1.1 1.0

Slave Okay Queries

Documents

You can configure an entire document to send all reads to the slaves by using the slaveOkay flag:

1<?php

/** @Document(slaveOkay=true) */
class User
{
    /** @Id */
    private $id;
}


2


3


4


5


6


7


8

Now all reads involving the User document will be sent to a slave.

Queries

If you want to instruct individual queries to read from a slave you can use the slaveOkay() method on the query builder.

1<?php

$qb = $dm->createQueryBuilder('User')
    ->slaveOkay(true);
$query = $qb->getQuery();
$users = $query->execute();


2


3


4


5


6

The data in the query above will be read from a slave. Even if you have a @ReferenceOne or @ReferenceMany resulting from the query above it will be initialized and loaded from a slave.

1<?php

/** @Document */
class User
{
    /** @ReferenceMany(targetDocument="Account") */
    private $accounts;
}


2


3


4


5


6


7


8

Now when you query and iterate over the accounts, they will be loaded from a slave:

1<?php

$qb = $dm->createQueryBuilder('User')
    ->slaveOkay(true);
$query = $qb->getQuery();
$users = $query->execute();

foreach ($users as $user) {
    foreach ($user->getAccounts() as $account) {
        echo $account->getName();
    }
}


2


3


4


5


6


7


8


9


10


11


12