MediaWiki REL1_28
|
Database cluster connection, tracking, load balancing, and transaction manager interface. More...
Public Member Functions | |
__construct (array $params) | |
Construct a manager of IDatabase connection objects. | |
allowLagged ( $mode=null) | |
Disables/enables lag checks. | |
approveMasterChanges (array $options) | |
Perform all pre-commit checks for things like replication safety. | |
beginMasterChanges ( $fname=__METHOD__) | |
Flush any master transaction snapshots and set DBO_TRX (if DBO_DEFAULT is set) | |
closeAll () | |
Close all open connections. | |
closeConnection (IDatabase $conn) | |
Close a connection. | |
commitAll ( $fname=__METHOD__) | |
Commit transactions on all open connections. | |
commitMasterChanges ( $fname=__METHOD__) | |
Issue COMMIT on all master connections where writes where done. | |
disable () | |
Disable this load balancer. | |
finalizeMasterChanges () | |
Perform all pre-commit callbacks that remain part of the atomic transactions and disable any post-commit callbacks until runMasterPostTrxCallbacks() | |
flushReplicaSnapshots ( $fname=__METHOD__) | |
Commit all replica DB transactions so as to flush any REPEATABLE-READ or SSI snapshot. | |
forEachOpenConnection ( $callback, array $params=[]) | |
Call a function with each open connection object. | |
forEachOpenMasterConnection ( $callback, array $params=[]) | |
Call a function with each open connection object to a master. | |
forEachOpenReplicaConnection ( $callback, array $params=[]) | |
Call a function with each open replica DB connection object. | |
getAnyOpenConnection ( $i) | |
Get any open connection to a given server index, local or foreign Returns false if there is no connection open. | |
getConnection ( $i, $groups=[], $domain=false) | |
Get a connection by index This is the main entry point for this class. | |
getConnectionRef ( $db, $groups=[], $domain=false) | |
Get a database connection handle reference. | |
getLaggedReplicaMode ( $domain=false) | |
getLagTimes ( $domain=false) | |
Get an estimate of replication lag (in seconds) for each server. | |
getLazyConnectionRef ( $db, $groups=[], $domain=false) | |
Get a database connection handle reference without connecting yet. | |
getMasterPos () | |
Get the current master position for chronology control purposes. | |
getMaxLag ( $domain=false) | |
Get the hostname and lag time of the most-lagged replica DB. | |
getReaderIndex ( $group=false, $domain=false) | |
Get the index of the reader connection, which may be a replica DB This takes into account load ratios and lag times. | |
getReadOnlyReason ( $domain=false, IDatabase $conn=null) | |
getServerCount () | |
Get the number of defined servers (not the number of open connections) | |
getServerInfo ( $i) | |
Return the server info structure for a given index, or false if the index is invalid. | |
getServerName ( $i) | |
Get the host name or IP address of the server with the specified index Prefer a readable name if available. | |
getWriterIndex () | |
hasMasterChanges () | |
Determine if there are pending changes in a transaction by this thread. | |
hasMasterConnection () | |
hasOrMadeRecentMasterChanges ( $age=null) | |
Check if this load balancer object had any recent or still pending writes issued against it by this PHP thread. | |
haveIndex ( $i) | |
Returns true if the specified index is a valid server index. | |
isNonZeroLoad ( $i) | |
Returns true if the specified index is valid and has non-zero load. | |
laggedReplicaUsed () | |
lastMasterChangeTimestamp () | |
Get the timestamp of the latest write query done by this thread. | |
openConnection ( $i, $domain=false) | |
Open a connection to the server given by the specified index Index must be an actual index into the array. | |
pendingMasterChangeCallers () | |
Get the list of callers that have pending master changes. | |
pingAll () | |
reuseConnection ( $conn) | |
Mark a foreign connection as being available for reuse under a different DB name or prefix. | |
rollbackMasterChanges ( $fname=__METHOD__) | |
Issue ROLLBACK only on master, only if queries were done on connection. | |
runMasterPostTrxCallbacks ( $type) | |
Issue all pending post-COMMIT/ROLLBACK callbacks. | |
safeGetLag (IDatabase $conn) | |
Get the lag in seconds for a given connection, or zero if this load balancer does not have replication enabled. | |
safeWaitForMasterPos (IDatabase $conn, $pos=false, $timeout=null) | |
Wait for a replica DB to reach a specified master position. | |
setDomainPrefix ( $prefix) | |
Set a new table prefix for the existing local domain ID for testing. | |
setServerInfo ( $i, array $serverInfo) | |
Sets the server info structure for the given index. | |
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. | |
setTransactionListener ( $name, callable $callback=null) | |
Set a callback via IDatabase::setTransactionListener() on all current and future master connections of this load balancer. | |
suppressTransactionEndCallbacks () | |
Suppress all pending post-COMMIT/ROLLBACK callbacks. | |
waitFor ( $pos) | |
Set the master wait position If a DB_REPLICA connection has been opened already, waits Otherwise sets a variable telling it to wait if such a connection is opened. | |
waitForAll ( $pos, $timeout=null) | |
Set the master wait position and wait for ALL replica DBs to catch up to it. | |
waitForOne ( $pos, $timeout=null) | |
Set the master wait position and wait for a "generic" replica DB to catch up to it. | |
Database cluster connection, tracking, load balancing, and transaction manager interface.
A "cluster" is considered to be one master database and zero or more replica databases. Typically, the replica DBs replicate from the master asynchronously. The first node in the "servers" configuration array is always considered the "master". However, this class can still be used when all or some of the "replica" DBs are multi-master peers of the master or even when all the DBs are non-replicating clones of each other holding read-only data. Thus, the role of "master" is in some cases merely nominal.
By default, each DB server uses DBO_DEFAULT for its 'flags' setting, unless explicitly set otherwise in configuration. DBO_DEFAULT behavior depends on whether 'cliMode' is set:
The typical caller will use LoadBalancer::getConnection( DB_* ) to yield a live database connection handle. The choice of which DB server to use is based on pre-defined loads for weighted random selection, adjustments thereof by LoadMonitor, and the amount of replication lag on each DB server. Lag checks might cause problems in certain setups, so they should be tuned in the server configuration maps as follows:
If using a SQL proxy service, it would probably be best to have two proxy hosts for the load balancer to talk to. One would be the 'host' of the master server entry and another for the (logical) replica server entry. The proxy could map the load balancer's "replica" DB to any number of physical replica DBs.
Definition at line 75 of file ILoadBalancer.php.
ILoadBalancer::__construct | ( | array | $params | ) |
Construct a manager of IDatabase connection objects.
array | $params | Parameter map with keys:
|
InvalidArgumentException |
Implemented in LoadBalancer, and LoadBalancerSingle.
ILoadBalancer::allowLagged | ( | $mode = null | ) |
ILoadBalancer::approveMasterChanges | ( | array | $options | ) |
Perform all pre-commit checks for things like replication safety.
Use this only for mutli-database commits
array | $options | Includes:
|
DBTransactionError |
Implemented in LoadBalancer.
ILoadBalancer::beginMasterChanges | ( | $fname = __METHOD__ | ) |
Flush any master 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:
string | $fname |
DBExpectedError |
Implemented in LoadBalancer.
Referenced by LBFactory\initLoadBalancer().
ILoadBalancer::closeAll | ( | ) |
Close all open connections.
Implemented in LoadBalancer.
ILoadBalancer::closeConnection | ( | IDatabase | $conn | ) |
Close a connection.
Using this function makes sure the LoadBalancer knows the connection is closed. If you use $conn->close() directly, the load balancer won't update its state.
IDatabase | $conn |
Implemented in LoadBalancer.
ILoadBalancer::commitAll | ( | $fname = __METHOD__ | ) |
Commit transactions on all open connections.
string | $fname | Caller name |
DBExpectedError |
Implemented in LoadBalancer.
ILoadBalancer::commitMasterChanges | ( | $fname = __METHOD__ | ) |
Issue COMMIT on all master connections where writes where done.
string | $fname | Caller name |
DBExpectedError |
Implemented in LoadBalancer.
ILoadBalancer::disable | ( | ) |
Disable this load balancer.
All connections are closed, and any attempt to open a new connection will result in a DBAccessError.
Implemented in LoadBalancer.
ILoadBalancer::finalizeMasterChanges | ( | ) |
Perform all pre-commit callbacks that remain part of the atomic transactions and disable any post-commit callbacks until runMasterPostTrxCallbacks()
Use this only for mutli-database commits
Implemented in LoadBalancer.
ILoadBalancer::flushReplicaSnapshots | ( | $fname = __METHOD__ | ) |
Commit all replica DB transactions so as to flush any REPEATABLE-READ or SSI snapshot.
string | $fname | Caller name |
Implemented in LoadBalancer.
ILoadBalancer::forEachOpenConnection | ( | $callback, | |
array | $params = [] |
||
) |
Call a function with each open connection object.
callable | $callback | |
array | $params |
Implemented in LoadBalancer.
ILoadBalancer::forEachOpenMasterConnection | ( | $callback, | |
array | $params = [] |
||
) |
Call a function with each open connection object to a master.
callable | $callback | |
array | $params |
Implemented in LoadBalancer.
ILoadBalancer::forEachOpenReplicaConnection | ( | $callback, | |
array | $params = [] |
||
) |
Call a function with each open replica DB connection object.
callable | $callback | |
array | $params |
Implemented in LoadBalancer.
ILoadBalancer::getAnyOpenConnection | ( | $i | ) |
Get any open connection to a given server index, local or foreign Returns false if there is no connection open.
int | $i | Server index |
Implemented in LoadBalancer.
ILoadBalancer::getConnection | ( | $i, | |
$groups = [] , |
|||
$domain = false |
|||
) |
Get a connection by index This is the main entry point for this class.
int | $i | Server index |
array | string | bool | $groups | Query group(s), or false for the generic reader |
string | bool | $domain | Domain ID, or false for the current domain |
DBError |
Implemented in LoadBalancer.
ILoadBalancer::getConnectionRef | ( | $db, | |
$groups = [] , |
|||
$domain = false |
|||
) |
Get a database connection handle reference.
The handle's methods wrap simply wrap those of a IDatabase handle
int | $db | |
array | string | bool | $groups | Query group(s), or false for the generic reader |
string | bool | $domain | Domain ID, or false for the current domain |
Implemented in LoadBalancer.
ILoadBalancer::getLaggedReplicaMode | ( | $domain = false | ) |
string | bool | $domain | Domain ID, or false for the current domain |
Implemented in LoadBalancer.
ILoadBalancer::getLagTimes | ( | $domain = false | ) |
Get an estimate of replication lag (in seconds) for each server.
Results are cached for a short time in memcached/process cache
Values may be "false" if replication is too broken to estimate
string | bool | $domain |
Implemented in LoadBalancer.
ILoadBalancer::getLazyConnectionRef | ( | $db, | |
$groups = [] , |
|||
$domain = false |
|||
) |
Get a database connection handle reference without connecting yet.
The handle's methods wrap simply wrap those of a IDatabase handle
int | $db | |
array | string | bool | $groups | Query group(s), or false for the generic reader |
string | bool | $domain | Domain ID, or false for the current domain |
Implemented in LoadBalancer.
ILoadBalancer::getMasterPos | ( | ) |
Get the current master position for chronology control purposes.
Implemented in LoadBalancer.
Referenced by ChronologyProtector\shutdownLB().
ILoadBalancer::getMaxLag | ( | $domain = false | ) |
Get the hostname and lag time of the most-lagged replica DB.
This is useful for maintenance scripts that need to throttle their updates. May attempt to open connections to replica DBs on the default DB. If there is no lag, the maximum lag will be reported as -1.
bool | string | $domain | Domain ID, or false for the default database |
Implemented in LoadBalancer.
ILoadBalancer::getReaderIndex | ( | $group = false , |
|
$domain = false |
|||
) |
Get the index of the reader connection, which may be a replica DB This takes into account load ratios and lag times.
It should always return a consistent index during a given invocation
Side effect: opens connections to databases
string | bool | $group | Query group, or false for the generic reader |
string | bool | $domain | Domain ID, or false for the current domain |
DBError |
Implemented in LoadBalancer.
ILoadBalancer::getReadOnlyReason | ( | $domain = false , |
|
IDatabase | $conn = null |
||
) |
string | bool | $domain | Domain ID, or false for the current domain |
IDatabase|null | DB master connection; used to avoid loops [optional] |
Implemented in LoadBalancer.
ILoadBalancer::getServerCount | ( | ) |
Get the number of defined servers (not the number of open connections)
Implemented in LoadBalancer.
Referenced by LBFactory\appendPreShutdownTimeAsQuery(), ChronologyProtector\initLB(), and ChronologyProtector\shutdownLB().
ILoadBalancer::getServerInfo | ( | $i | ) |
Return the server info structure for a given index, or false if the index is invalid.
int | $i |
Implemented in LoadBalancer.
ILoadBalancer::getServerName | ( | $i | ) |
Get the host name or IP address of the server with the specified index Prefer a readable name if available.
string | $i |
Implemented in LoadBalancer.
Referenced by ChronologyProtector\initLB(), LBFactory\logIfMultiDbTransaction(), LBFactory\shutdownChronologyProtector(), and ChronologyProtector\shutdownLB().
ILoadBalancer::getWriterIndex | ( | ) |
Implemented in LoadBalancer.
Referenced by ChronologyProtector\initLB(), LBFactory\logIfMultiDbTransaction(), LBFactory\shutdownChronologyProtector(), and ChronologyProtector\shutdownLB().
ILoadBalancer::hasMasterChanges | ( | ) |
Determine if there are pending changes in a transaction by this thread.
Implemented in LoadBalancer.
Referenced by LBFactory\hasMasterChanges().
ILoadBalancer::hasMasterConnection | ( | ) |
Implemented in LoadBalancer.
ILoadBalancer::hasOrMadeRecentMasterChanges | ( | $age = null | ) |
Check if this load balancer object had any recent or still pending writes issued against it by this PHP thread.
float | $age | How many seconds ago is "recent" [defaults to mWaitTimeout] |
Implemented in LoadBalancer.
Referenced by LBFactory\hasOrMadeRecentMasterChanges(), and ChronologyProtector\shutdownLB().
ILoadBalancer::haveIndex | ( | $i | ) |
Returns true if the specified index is a valid server index.
string | $i |
Implemented in LoadBalancer.
ILoadBalancer::isNonZeroLoad | ( | $i | ) |
Returns true if the specified index is valid and has non-zero load.
string | $i |
Implemented in LoadBalancer.
ILoadBalancer::laggedReplicaUsed | ( | ) |
Implemented in LoadBalancer.
Referenced by LBFactory\laggedReplicaUsed().
ILoadBalancer::lastMasterChangeTimestamp | ( | ) |
Get the timestamp of the latest write query done by this thread.
Implemented in LoadBalancer.
ILoadBalancer::openConnection | ( | $i, | |
$domain = false |
|||
) |
Open a connection to the server given by the specified index Index must be an actual index into the array.
If the server is already open, returns it.
On error, returns false, and the connection which caused the error will be available via $this->mErrorConnection.
int | $i | Server index |
string | bool | $domain | Domain ID, or false for the current domain |
DBAccessError |
Implemented in LoadBalancer.
ILoadBalancer::pendingMasterChangeCallers | ( | ) |
Get the list of callers that have pending master changes.
Implemented in LoadBalancer.
Referenced by LBFactory\logIfMultiDbTransaction().
ILoadBalancer::pingAll | ( | ) |
Implemented in LoadBalancer.
ILoadBalancer::reuseConnection | ( | $conn | ) |
Mark a foreign connection as being available for reuse under a different DB name or prefix.
This mechanism is reference-counted, and must be called the same number of times as getConnection() to work.
IDatabase | $conn |
InvalidArgumentException |
Implemented in LoadBalancer.
ILoadBalancer::rollbackMasterChanges | ( | $fname = __METHOD__ | ) |
Issue ROLLBACK only on master, only if queries were done on connection.
string | $fname | Caller name |
DBExpectedError |
Implemented in LoadBalancer.
ILoadBalancer::runMasterPostTrxCallbacks | ( | $type | ) |
Issue all pending post-COMMIT/ROLLBACK callbacks.
Use this only for mutli-database commits
integer | $type | IDatabase::TRIGGER_* constant |
Implemented in LoadBalancer.
Referenced by LBFactory\commitMasterChanges(), and LBFactory\rollbackMasterChanges().
ILoadBalancer::safeGetLag | ( | IDatabase | $conn | ) |
Get the lag in seconds for a given connection, or zero if this load balancer does not have replication enabled.
This should be used in preference to Database::getLag() in cases where replication may not be in use, since there is no way to determine if replication is in use at the connection level without running potentially restricted queries such as SHOW SLAVE STATUS. Using this function instead of Database::getLag() avoids a fatal error in this case on many installations.
IDatabase | $conn |
Implemented in LoadBalancer.
ILoadBalancer::safeWaitForMasterPos | ( | IDatabase | $conn, |
$pos = false , |
|||
$timeout = null |
|||
) |
Wait for a replica DB to reach a specified master position.
This will connect to the master to get an accurate position if $pos is not given
IDatabase | $conn | Replica DB |
DBMasterPos | bool | $pos | Master position; default: current position |
integer | null | $timeout | Timeout in seconds [optional] |
Implemented in LoadBalancer.
ILoadBalancer::setDomainPrefix | ( | $prefix | ) |
Set a new table prefix for the existing local domain ID for testing.
string | $prefix |
Implemented in LoadBalancer.
Referenced by LBFactory\setDomainPrefix().
ILoadBalancer::setServerInfo | ( | $i, | |
array | $serverInfo | ||
) |
Sets the server info structure for the given index.
Entry at index $i is created if it doesn't exist
int | $i | |
array | $serverInfo |
Implemented in LoadBalancer.
ILoadBalancer::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 LoadBalancer.
ILoadBalancer::setTransactionListener | ( | $name, | |
callable | $callback = null |
||
) |
Set a callback via IDatabase::setTransactionListener() on all current and future master connections of this load balancer.
string | $name | Callback name |
callable | null | $callback |
Implemented in LoadBalancer.
ILoadBalancer::suppressTransactionEndCallbacks | ( | ) |
Suppress all pending post-COMMIT/ROLLBACK callbacks.
Use this only for mutli-database commits
Implemented in LoadBalancer.
ILoadBalancer::waitFor | ( | $pos | ) |
Set the master wait position If a DB_REPLICA connection has been opened already, waits Otherwise sets a variable telling it to wait if such a connection is opened.
DBMasterPos | $pos |
Implemented in LoadBalancer.
Referenced by ChronologyProtector\initLB().
ILoadBalancer::waitForAll | ( | $pos, | |
$timeout = null |
|||
) |
Set the master wait position and wait for ALL replica DBs to catch up to it.
DBMasterPos | $pos | |
int | $timeout | Max seconds to wait; default is mWaitTimeout |
Implemented in LoadBalancer.
Referenced by LBFactory\shutdownChronologyProtector().
ILoadBalancer::waitForOne | ( | $pos, | |
$timeout = null |
|||
) |
Set the master wait position and wait for a "generic" replica DB to catch up to it.
This can be used a faster proxy for waitForAll()
DBMasterPos | $pos | |
int | $timeout | Max seconds to wait; default is mWaitTimeout |
Implemented in LoadBalancer.