X-Git-Url: https://git.cyclocoop.org/?a=blobdiff_plain;f=includes%2FExternalStoreDB.php;h=f9046f74c9a58b22806fa59e7b90045e2058d2ae;hb=1e7e73444a9357be1c58301e8707c029f31f5ef7;hp=96237783501d7cff4cd06e18b6232312d40a6481;hpb=af47b8260c824f241919cad43dbf37b215586a30;p=lhc%2Fweb%2Fwiklou.git diff --git a/includes/ExternalStoreDB.php b/includes/ExternalStoreDB.php index 9623778350..f9046f74c9 100644 --- a/includes/ExternalStoreDB.php +++ b/includes/ExternalStoreDB.php @@ -1,15 +1,12 @@ allowLagged(true); return $wgExternalLoadBalancers[$cluster]; } - + + /** @todo Document.*/ function &getSlave( $cluster ) { $lb =& $this->getLoadBalancer( $cluster ); return $lb->getConnection( DB_SLAVE ); } + /** @todo Document.*/ function &getMaster( $cluster ) { $lb =& $this->getLoadBalancer( $cluster ); return $lb->getConnection( DB_MASTER ); - } + } + /** @todo Document.*/ function getTable( &$db ) { $table = $db->getLBInfo( 'blobs table' ); if ( is_null( $table ) ) { @@ -62,12 +60,12 @@ class ExternalStoreDB { } return $table; } - + + /** + * Fetch data from given URL + * @param string $url An url of the form DB://cluster/id or DB://cluster/id/itemid for concatened storage. + */ function fetchFromURL($url) { - global $wgExternalServers; - # - # URLs have the form DB://cluster/id or DB://cluster/id/itemid for concatenated storage - # $path = explode( '/', $url ); $cluster = $path[2]; $id = $path[3]; @@ -79,18 +77,21 @@ class ExternalStoreDB { $ret =& $this->fetchBlob( $cluster, $id, $itemID ); - if ( $itemID !== false ) { + if ( $itemID !== false && $ret !== false ) { return $ret->getItem( $itemID ); } return $ret; } - + /** * Fetch a blob item out of the database; a cache of the last-loaded * blob will be kept so that multiple loads out of a multi-item blob * can avoid redundant database access and decompression. + * @param $cluster + * @param $id + * @param $itemID * @return mixed - * @access private + * @private */ function &fetchBlob( $cluster, $id, $itemID ) { global $wgExternalBlobCache; @@ -99,16 +100,25 @@ class ExternalStoreDB { wfDebug( "ExternalStoreDB::fetchBlob cache hit on $cacheID\n" ); return $wgExternalBlobCache[$cacheID]; } - + wfDebug( "ExternalStoreDB::fetchBlob cache miss on $cacheID\n" ); - + $dbr =& $this->getSlave( $cluster ); $ret = $dbr->selectField( $this->getTable( $dbr ), 'blob_text', array( 'blob_id' => $id ) ); - if( $itemID !== false ) { + if ( $ret === false ) { + wfDebugLog( 'ExternalStoreDB', "ExternalStoreDB::fetchBlob master fallback on $cacheID\n" ); + // Try the master + $dbw =& $this->getMaster( $cluster ); + $ret = $dbw->selectField( $this->getTable( $dbw ), 'blob_text', array( 'blob_id' => $id ) ); + if( $ret === false) { + wfDebugLog( 'ExternalStoreDB', "ExternalStoreDB::fetchBlob master failed to find $cacheID\n" ); + } + } + if( $itemID !== false && $ret !== false ) { // Unserialise object; caller extracts item $ret = unserialize( $ret ); } - + $wgExternalBlobCache = array( $cacheID => &$ret ); return $ret; } @@ -116,19 +126,22 @@ class ExternalStoreDB { /** * Insert a data item into a given cluster * - * @param string $cluster The cluster name - * @param string $data The data item + * @param $cluster String: the cluster name + * @param $data String: the data item * @return string URL */ function store( $cluster, $data ) { - global $wgExternalServers; $fname = 'ExternalStoreDB::store'; $dbw =& $this->getMaster( $cluster ); $id = $dbw->nextSequenceValue( 'blob_blob_id_seq' ); $dbw->insert( $this->getTable( $dbw ), array( 'blob_id' => $id, 'blob_text' => $data ), $fname ); - return "DB://$cluster/" . $dbw->insertId(); + $id = $dbw->insertId(); + if ( $dbw->getFlag( DBO_TRX ) ) { + $dbw->immediateCommit(); + } + return "DB://$cluster/$id"; } } -?> +