MediaWiki REL1_37
|
An interface for generating database load balancers. More...
Public Member Functions | |
__construct (array $conf) | |
Construct a manager of ILoadBalancer instances. | |
appendShutdownCPIndexAsQuery ( $url, $index) | |
Append ?cpPosIndex parameter to a URL for ChronologyProtector purposes if needed. | |
beginMasterChanges ( $fname=__METHOD__) | |
beginPrimaryChanges ( $fname=__METHOD__) | |
Flush any primary transaction snapshots and set DBO_TRX (if DBO_DEFAULT is set) | |
closeAll () | |
Close all connections on instantiated tracked load balancer instances. | |
commitAll ( $fname=__METHOD__, array $options=[]) | |
Commit open transactions on all connections. | |
commitAndWaitForReplication ( $fname, $ticket, array $opts=[]) | |
Call commitPrimaryChanges() and waitForReplication() if $ticket indicates it is safe. | |
commitMasterChanges ( $fname=__METHOD__, array $options=[]) | |
commitPrimaryChanges ( $fname=__METHOD__, array $options=[]) | |
Commit changes and clear view snapshots on all primary connections. | |
destroy () | |
Close all connections and make further attempts to open connections result in DBAccessError. | |
disableChronologyProtection () | |
Disable the ChronologyProtector on all instantiated tracked load balancer instances. | |
flushReplicaSnapshots ( $fname=__METHOD__) | |
Commit all replica DB transactions so as to flush any REPEATABLE-READ or SSI snapshot. | |
forEachLB ( $callback, array $params=[]) | |
Execute a function for each instantiated tracked load balancer instance. | |
getAllExternalLBs () | |
Get the tracked load balancer instances for all external clusters. | |
getAllMainLBs () | |
Get the tracked load balancer instances for all main clusters. | |
getChronologyProtectorClientId () | |
Get the client ID of the ChronologyProtector instance. | |
getChronologyProtectorTouched ( $domain=false) | |
Get the UNIX timestamp when the client last touched the DB, if they did so recently. | |
getEmptyTransactionTicket ( $fname) | |
Get a token asserting that no transaction writes are active on tracked load balancers. | |
getExternalLB ( $cluster) | |
Get the tracked load balancer instance for an external cluster. | |
getLocalDomainID () | |
Get the local (and default) database domain ID of connection handles. | |
getMainLB ( $domain=false) | |
Get the tracked load balancer instance for a main cluster. | |
getTransactionProfiler () | |
Get the TransactionProfiler used by this instance. | |
hasMasterChanges () | |
hasOrMadeRecentMasterChanges ( $age=null) | |
hasOrMadeRecentPrimaryChanges ( $age=null) | |
Determine if any primary connection has pending/written changes from this request. | |
hasPrimaryChanges () | |
Determine if any primary connection has pending changes. | |
hasTransactionRound () | |
Check if an explicit transaction round is active. | |
isReadyForRoundOperations () | |
Check if transaction rounds can be started, committed, or rolled back right now. | |
laggedReplicaUsed () | |
Detemine if any lagged replica DB connection was used. | |
newExternalLB ( $cluster, $owner=null) | |
Create a new load balancer instance for an external cluster. | |
newMainLB ( $domain=false, $owner=null) | |
Create a new load balancer instance for a main cluster. | |
redefineLocalDomain ( $domain) | |
Close all connections and redefine the local domain for testing or schema creation. | |
resolveDomainID ( $domain) | |
rollbackMasterChanges ( $fname=__METHOD__) | |
rollbackPrimaryChanges ( $fname=__METHOD__) | |
Rollback changes on all primary connections. | |
setAgentName ( $agent) | |
setDefaultReplicationWaitTimeout ( $seconds) | |
Set the default timeout for replication wait checks. | |
setDomainAliases (array $aliases) | |
Convert certain database domains to alternative ones. | |
setIndexAliases (array $aliases) | |
Convert certain index names to alternative names before querying the DB. | |
setLocalDomainPrefix ( $prefix) | |
Set a new table prefix for the existing local domain ID for testing. | |
setRequestInfo (array $info) | |
Inject HTTP request header/cookie information during setup of this instance. | |
setTableAliases (array $aliases) | |
Make certain table names use their own database, schema, and table prefix when passed into SQL queries pre-escaped and without a qualified database name. | |
setWaitForReplicationListener ( $name, callable $callback=null) | |
Add a callback to be run in every call to waitForReplication() before waiting. | |
shutdown ( $flags=self::SHUTDOWN_NORMAL, callable $workCallback=null, &$cpIndex=null, &$cpClientId=null) | |
Prepare all instantiated tracked load balancer instances for shutdown. | |
waitForReplication (array $opts=[]) | |
Waits for the replica DBs to catch up to the current primary position. | |
Public Attributes | |
const | SHUTDOWN_NO_CHRONPROT = 1 |
Do not save "session consistency" DB replication positions. | |
const | SHUTDOWN_NORMAL = 0 |
Idion for "no special shutdown flags". | |
An interface for generating database load balancers.
Definition at line 33 of file ILBFactory.php.
Wikimedia\Rdbms\ILBFactory::__construct | ( | array | $conf | ) |
Construct a manager of ILoadBalancer instances.
Sub-classes will extend the required keys in $conf with additional parameters
array | $conf | Array with keys:
|
InvalidArgumentException |
Implemented in Wikimedia\Rdbms\LBFactory, Wikimedia\Rdbms\LBFactoryMulti, Wikimedia\Rdbms\LBFactorySimple, and Wikimedia\Rdbms\LBFactorySingle.
Wikimedia\Rdbms\ILBFactory::appendShutdownCPIndexAsQuery | ( | $url, | |
$index | |||
) |
Append ?cpPosIndex parameter to a URL for ChronologyProtector purposes if needed.
Note that unlike cookies, this works across domains.
string | $url | |
int | $index | Write counter index |
Implemented in Wikimedia\Rdbms\LBFactory.
Wikimedia\Rdbms\ILBFactory::beginMasterChanges | ( | $fname = __METHOD__ | ) |
string | $fname |
DBTransactionError |
Implemented in Wikimedia\Rdbms\LBFactory.
Wikimedia\Rdbms\ILBFactory::beginPrimaryChanges | ( | $fname = __METHOD__ | ) |
Flush any primary transaction snapshots and set DBO_TRX (if DBO_DEFAULT is set)
The DBO_TRX setting will be reverted to the default in each of these methods:
This only applies to the tracked load balancer instances.
This allows for custom transaction rounds from any outer transaction scope.
string | $fname |
DBTransactionError |
Implemented in Wikimedia\Rdbms\LBFactory.
Referenced by DeferredUpdates\attemptUpdate().
Wikimedia\Rdbms\ILBFactory::closeAll | ( | ) |
Close all connections on instantiated tracked load balancer instances.
Implemented in Wikimedia\Rdbms\LBFactory.
Wikimedia\Rdbms\ILBFactory::commitAll | ( | $fname = __METHOD__ , |
|
array | $options = [] |
||
) |
Commit open transactions on all connections.
This only applies to the instantiated tracked load balancer instances.
This is useful for two main cases:
string | $fname | Caller name |
array | $options | Options map:
|
Implemented in Wikimedia\Rdbms\LBFactory.
Wikimedia\Rdbms\ILBFactory::commitAndWaitForReplication | ( | $fname, | |
$ticket, | |||
array | $opts = [] |
||
) |
Call commitPrimaryChanges() and waitForReplication() if $ticket indicates it is safe.
The ticket is used to check that the caller owns the transaction round or can act on behalf of the caller that owns the transaction round.
string | $fname | Caller name (e.g. METHOD) |
mixed | $ticket | Result of getEmptyTransactionTicket() |
array | $opts | Options to waitForReplication() |
Implemented in Wikimedia\Rdbms\LBFactory.
Wikimedia\Rdbms\ILBFactory::commitMasterChanges | ( | $fname = __METHOD__ , |
|
array | $options = [] |
||
) |
string | $fname | Caller name |
array | $options | Options map:
|
DBTransactionError |
Implemented in Wikimedia\Rdbms\LBFactory.
Wikimedia\Rdbms\ILBFactory::commitPrimaryChanges | ( | $fname = __METHOD__ , |
|
array | $options = [] |
||
) |
Commit changes and clear view snapshots on all primary connections.
This only applies to the instantiated tracked load balancer instances.
string | $fname | Caller name |
array | $options | Options map:
|
DBTransactionError |
Implemented in Wikimedia\Rdbms\LBFactory.
Referenced by DeferredUpdates\attemptUpdate().
Wikimedia\Rdbms\ILBFactory::destroy | ( | ) |
Close all connections and make further attempts to open connections result in DBAccessError.
This only applies to the tracked load balancer instances.
Implemented in Wikimedia\Rdbms\LBFactory.
Wikimedia\Rdbms\ILBFactory::disableChronologyProtection | ( | ) |
Disable the ChronologyProtector on all instantiated tracked load balancer instances.
This can be called at the start of special API entry points.
Implemented in Wikimedia\Rdbms\LBFactory.
Wikimedia\Rdbms\ILBFactory::flushReplicaSnapshots | ( | $fname = __METHOD__ | ) |
Commit all replica DB transactions so as to flush any REPEATABLE-READ or SSI snapshot.
This only applies to the instantiated tracked load balancer instances.
This is useful for getting rid of stale data from an implicit transaction round
string | $fname | Caller name |
Implemented in Wikimedia\Rdbms\LBFactory.
Wikimedia\Rdbms\ILBFactory::forEachLB | ( | $callback, | |
array | $params = [] |
||
) |
Execute a function for each instantiated tracked load balancer instance.
The callback is called with the load balancer as the first parameter, and $params passed as the subsequent parameters.
callable | $callback | |
array | $params |
Implemented in Wikimedia\Rdbms\LBFactoryMulti, Wikimedia\Rdbms\LBFactorySimple, and Wikimedia\Rdbms\LBFactorySingle.
Referenced by DeferredUpdates\areDatabaseTransactionsActive(), Wikimedia\Rdbms\LBFactory\commitPrimaryChanges(), Wikimedia\Rdbms\LBFactory\executePostTransactionCallbacks(), Wikimedia\Rdbms\LBFactory\forEachLBCallMethod(), Wikimedia\Rdbms\LBFactory\hasOrMadeRecentPrimaryChanges(), Wikimedia\Rdbms\LBFactory\hasPrimaryChanges(), Wikimedia\Rdbms\LBFactory\laggedReplicaUsed(), Wikimedia\Rdbms\LBFactory\logIfMultiDbTransaction(), Wikimedia\Rdbms\LBFactory\shutdownChronologyProtector(), and Wikimedia\Rdbms\LBFactory\waitForReplication().
Wikimedia\Rdbms\ILBFactory::getAllExternalLBs | ( | ) |
Get the tracked load balancer instances for all external clusters.
If no tracked instance exists for a cluster, then one will be instantiated
Implemented in Wikimedia\Rdbms\LBFactoryMulti, Wikimedia\Rdbms\LBFactorySimple, and Wikimedia\Rdbms\LBFactorySingle.
Wikimedia\Rdbms\ILBFactory::getAllMainLBs | ( | ) |
Get the tracked load balancer instances for all main clusters.
If no tracked instance exists for a cluster, then one will be instantiated
Note that default main cluster name is ILoadBalancer::CLUSTER_MAIN_DEFAULT
Implemented in Wikimedia\Rdbms\LBFactoryMulti, Wikimedia\Rdbms\LBFactorySimple, and Wikimedia\Rdbms\LBFactorySingle.
Wikimedia\Rdbms\ILBFactory::getChronologyProtectorClientId | ( | ) |
Get the client ID of the ChronologyProtector instance.
Implemented in Wikimedia\Rdbms\LBFactory.
Wikimedia\Rdbms\ILBFactory::getChronologyProtectorTouched | ( | $domain = false | ) |
Get the UNIX timestamp when the client last touched the DB, if they did so recently.
DatabaseDomain | string | bool | $domain | Domain ID, or false for the current domain |
Implemented in Wikimedia\Rdbms\LBFactory.
Wikimedia\Rdbms\ILBFactory::getEmptyTransactionTicket | ( | $fname | ) |
Get a token asserting that no transaction writes are active on tracked load balancers.
string | $fname | Caller name (e.g. METHOD) |
Implemented in Wikimedia\Rdbms\LBFactory.
Referenced by DeferredUpdates\attemptUpdate().
Wikimedia\Rdbms\ILBFactory::getExternalLB | ( | $cluster | ) |
Get the tracked load balancer instance for an external cluster.
If no tracked instances exists, then one will be instantiated
string | $cluster | External cluster name |
Implemented in Wikimedia\Rdbms\LBFactoryMulti, Wikimedia\Rdbms\LBFactorySimple, and Wikimedia\Rdbms\LBFactorySingle.
Referenced by Wikimedia\Rdbms\LBFactory\waitForReplication().
Wikimedia\Rdbms\ILBFactory::getLocalDomainID | ( | ) |
Get the local (and default) database domain ID of connection handles.
Implemented in Wikimedia\Rdbms\LBFactory.
Referenced by MWLBFactory\setDomainAliases().
Wikimedia\Rdbms\ILBFactory::getMainLB | ( | $domain = false | ) |
Get the tracked load balancer instance for a main cluster.
If no tracked instances exists, then one will be instantiated
bool | string | $domain | Domain ID, or false for the current domain |
Implemented in Wikimedia\Rdbms\LBFactoryMulti, Wikimedia\Rdbms\LBFactorySimple, and Wikimedia\Rdbms\LBFactorySingle.
Referenced by MediaWiki\Page\DeletePage\__construct(), MediaWiki\User\UserGroupManager\__construct(), WatchedItemStore\__construct(), Wikimedia\Rdbms\LBFactory\getChronologyProtectorTouched(), and Wikimedia\Rdbms\LBFactory\waitForReplication().
Wikimedia\Rdbms\ILBFactory::getTransactionProfiler | ( | ) |
Get the TransactionProfiler used by this instance.
Implemented in Wikimedia\Rdbms\LBFactory.
Wikimedia\Rdbms\ILBFactory::hasMasterChanges | ( | ) |
Implemented in Wikimedia\Rdbms\LBFactory.
Wikimedia\Rdbms\ILBFactory::hasOrMadeRecentMasterChanges | ( | $age = null | ) |
float | null | $age | How many seconds ago is "recent" [defaults to LB lag wait timeout] |
Implemented in Wikimedia\Rdbms\LBFactory.
Wikimedia\Rdbms\ILBFactory::hasOrMadeRecentPrimaryChanges | ( | $age = null | ) |
Determine if any primary connection has pending/written changes from this request.
This only applies to the instantiated tracked load balancer instances.
float | null | $age | How many seconds ago is "recent" [defaults to LB lag wait timeout] |
Implemented in Wikimedia\Rdbms\LBFactory.
Wikimedia\Rdbms\ILBFactory::hasPrimaryChanges | ( | ) |
Determine if any primary connection has pending changes.
This only applies to the instantiated tracked load balancer instances.
Implemented in Wikimedia\Rdbms\LBFactory.
Wikimedia\Rdbms\ILBFactory::hasTransactionRound | ( | ) |
Check if an explicit transaction round is active.
Implemented in Wikimedia\Rdbms\LBFactory.
Referenced by DeferredUpdates\areDatabaseTransactionsActive(), and DeferredUpdates\attemptUpdate().
Wikimedia\Rdbms\ILBFactory::isReadyForRoundOperations | ( | ) |
Check if transaction rounds can be started, committed, or rolled back right now.
This can be used as a recusion guard to avoid exceptions in transaction callbacks.
Implemented in Wikimedia\Rdbms\LBFactory.
Referenced by DeferredUpdates\areDatabaseTransactionsActive().
Wikimedia\Rdbms\ILBFactory::laggedReplicaUsed | ( | ) |
Detemine if any lagged replica DB connection was used.
This only applies to the instantiated tracked load balancer instances.
Implemented in Wikimedia\Rdbms\LBFactory.
Wikimedia\Rdbms\ILBFactory::newExternalLB | ( | $cluster, | |
$owner = null |
|||
) |
Create a new load balancer instance for an external cluster.
The resulting object will be untracked and the caller is responsible for cleaning it up. Database replication positions will not be saved by ChronologyProtector.
This method is for only advanced usage and callers should almost always use getExternalLB() instead. This method can be useful when a table is used as a key/value store. In that cases, one might want to query it in autocommit mode (DBO_TRX off) but still use DBO_TRX transaction rounds on other tables.
string | $cluster | External cluster name |
int | null | $owner | Owner ID of the new instance (e.g. this LBFactory ID) |
Implemented in Wikimedia\Rdbms\LBFactoryMulti, Wikimedia\Rdbms\LBFactorySimple, and Wikimedia\Rdbms\LBFactorySingle.
Wikimedia\Rdbms\ILBFactory::newMainLB | ( | $domain = false , |
|
$owner = null |
|||
) |
Create a new load balancer instance for a main cluster.
The resulting object will be untracked and the caller is responsible for cleaning it up. Database replication positions will not be saved by ChronologyProtector.
This method is for only advanced usage and callers should almost always use getMainLB() instead. This method can be useful when a table is used as a key/value store. In that cases, one might want to query it in autocommit mode (DBO_TRX off) but still use DBO_TRX transaction rounds on other tables.
bool | string | $domain | Domain ID, or false for the current domain |
int | null | $owner | Owner ID of the new instance (e.g. this LBFactory ID) |
Implemented in Wikimedia\Rdbms\LBFactoryMulti, Wikimedia\Rdbms\LBFactorySimple, and Wikimedia\Rdbms\LBFactorySingle.
Wikimedia\Rdbms\ILBFactory::redefineLocalDomain | ( | $domain | ) |
Close all connections and redefine the local domain for testing or schema creation.
This only applies to the tracked load balancer instances.
DatabaseDomain | string | $domain |
Implemented in Wikimedia\Rdbms\LBFactory.
Wikimedia\Rdbms\ILBFactory::resolveDomainID | ( | $domain | ) |
DatabaseDomain | string | bool | $domain | Database domain |
Implemented in Wikimedia\Rdbms\LBFactory.
Wikimedia\Rdbms\ILBFactory::rollbackMasterChanges | ( | $fname = __METHOD__ | ) |
string | $fname | Caller name |
Implemented in Wikimedia\Rdbms\LBFactory.
Wikimedia\Rdbms\ILBFactory::rollbackPrimaryChanges | ( | $fname = __METHOD__ | ) |
Rollback changes on all primary connections.
This only applies to the instantiated tracked load balancer instances.
string | $fname | Caller name |
Implemented in Wikimedia\Rdbms\LBFactory.
Wikimedia\Rdbms\ILBFactory::setAgentName | ( | $agent | ) |
string | $agent | Agent name for query profiling |
Implemented in Wikimedia\Rdbms\LBFactory.
Wikimedia\Rdbms\ILBFactory::setDefaultReplicationWaitTimeout | ( | $seconds | ) |
Set the default timeout for replication wait checks.
int | $seconds | Timeout, in seconds |
Implemented in Wikimedia\Rdbms\LBFactory.
Wikimedia\Rdbms\ILBFactory::setDomainAliases | ( | array | $aliases | ) |
Convert certain database domains to alternative ones.
This can be used for backwards compatibility logic.
DatabaseDomain[] | string[] | $aliases | Map of (domain alias => domain) |
Implemented in Wikimedia\Rdbms\LBFactory.
Referenced by MWLBFactory\setDomainAliases().
Wikimedia\Rdbms\ILBFactory::setIndexAliases | ( | array | $aliases | ) |
Convert certain index names to alternative names before querying the DB.
Note that this applies to indexes regardless of the table they belong to.
This can be employed when an index was renamed X => Y in code, but the new Y-named indexes were not yet built on all DBs. After all the Y-named ones are added by the DBA, the aliases can be removed, and then the old X-named indexes dropped.
string[] | $aliases | Map of (index alias => index name) |
Implemented in Wikimedia\Rdbms\LBFactory.
Wikimedia\Rdbms\ILBFactory::setLocalDomainPrefix | ( | $prefix | ) |
Set a new table prefix for the existing local domain ID for testing.
string | $prefix |
Implemented in Wikimedia\Rdbms\LBFactory.
Wikimedia\Rdbms\ILBFactory::setRequestInfo | ( | array | $info | ) |
Inject HTTP request header/cookie information during setup of this instance.
array | $info | Map of fields, including:
|
Implemented in Wikimedia\Rdbms\LBFactory.
Wikimedia\Rdbms\ILBFactory::setTableAliases | ( | array | $aliases | ) |
Make certain table names use their own database, schema, and table prefix when passed into SQL queries pre-escaped and without a qualified database name.
For example, "user" can be converted to "myschema.mydbname.user" for convenience. Appearances like user
, somedb.user, somedb.someschema.user will used literally.
Calling this twice will completely clear any old table aliases. Also, note that callers are responsible for making sure the schemas and databases actually exist.
array[] | $aliases | Map of (table => (dbname, schema, prefix) map) |
Implemented in Wikimedia\Rdbms\LBFactory.
Wikimedia\Rdbms\ILBFactory::setWaitForReplicationListener | ( | $name, | |
callable | $callback = null |
||
) |
Add a callback to be run in every call to waitForReplication() before waiting.
Callbacks must clear any transactions that they start.
string | $name | Callback name |
callable | null | $callback | Use null to unset a callback |
Implemented in Wikimedia\Rdbms\LBFactory.
Wikimedia\Rdbms\ILBFactory::shutdown | ( | $flags = self::SHUTDOWN_NORMAL , |
|
callable | $workCallback = null , |
||
& | $cpIndex = null , |
||
& | $cpClientId = null |
||
) |
Prepare all instantiated tracked load balancer instances for shutdown.
int | $flags | Bit field of ILBFactory::SHUTDOWN_* constants |
callable | null | $workCallback | Work to mask ChronologyProtector writes |
int | null | &$cpIndex | Position key write counter for ChronologyProtector [returned] |
string | null | &$cpClientId | Client ID hash for ChronologyProtector [returned] |
Implemented in Wikimedia\Rdbms\LBFactory.
Wikimedia\Rdbms\ILBFactory::waitForReplication | ( | array | $opts = [] | ) |
Waits for the replica DBs to catch up to the current primary position.
Use this when updating very large numbers of rows, as in maintenance scripts, to avoid causing too much lag. Of course, this is a no-op if there are no replica DBs.
By default this waits on all DB clusters actually used in this request. This makes sense when lag being waiting on is caused by the code that does this check. In that case, setting "ifWritesSince" can avoid the overhead of waiting for clusters that were not changed since the last wait check. To forcefully wait on a specific cluster for a given domain, use the 'domain' parameter. To forcefully wait on an "external" cluster, use the "cluster" parameter.
Never call this function after a large DB write that is still in a transaction. It only makes sense to call this after the possible lag inducing changes were committed.
This only applies to the instantiated tracked load balancer instances.
array | $opts | Optional fields that include:
|
Implemented in Wikimedia\Rdbms\LBFactory.
Referenced by RebuildRecentchanges\rebuildRecentChangesTablePass1(), RebuildRecentchanges\rebuildRecentChangesTablePass2(), RebuildRecentchanges\rebuildRecentChangesTablePass3(), RebuildRecentchanges\rebuildRecentChangesTablePass4(), and RebuildRecentchanges\rebuildRecentChangesTablePass5().
const Wikimedia\Rdbms\ILBFactory::SHUTDOWN_NO_CHRONPROT = 1 |
Do not save "session consistency" DB replication positions.
Definition at line 37 of file ILBFactory.php.
const Wikimedia\Rdbms\ILBFactory::SHUTDOWN_NORMAL = 0 |
Idion for "no special shutdown flags".
Definition at line 35 of file ILBFactory.php.