4 * Pick a database that has pending jobs
7 $options = array( 'type' );
9 require_once( 'commandLine.inc' );
11 $type = isset($options['type'])
15 $mckey = $type === false
17 : "jobqueue:dbs:$type";
19 $pendingDBs = $wgMemc->get( $mckey );
21 $pendingDBs = array();
22 # Cross-reference DBs by master DB server
23 $dbsByMaster = array();
24 $defaultMaster = $wgAlternateMaster['DEFAULT'];
25 foreach ( $wgLocalDatabases as $db ) {
26 if ( isset( $wgAlternateMaster[$db] ) ) {
27 $dbsByMaster[$wgAlternateMaster[$db]][] = $db;
29 $dbsByMaster[$defaultMaster][] = $db;
33 foreach ( $dbsByMaster as $master => $dbs ) {
34 $dbConn = new Database( $master, $wgDBuser, $wgDBpassword );
35 $stype = $dbConn->addQuotes($type);
37 # Padding row for MySQL bug
38 $sql = "(SELECT '-------------------------------------------')";
39 foreach ( $dbs as $dbName ) {
44 $sql .= "(SELECT '$dbName' FROM `$dbName`.job LIMIT 1)";
46 $sql .= "(SELECT '$dbName' FROM `$dbName`.job WHERE job_cmd=$stype LIMIT 1)";
48 $res = $dbConn->query( $sql, 'nextJobDB.php' );
49 $row = $dbConn->fetchRow( $res ); // discard padding row
50 while ( $row = $dbConn->fetchRow( $res ) ) {
51 $pendingDBs[] = $row[0];
55 $wgMemc->set( $mckey, $pendingDBs, 300 );
59 echo $pendingDBs[mt_rand(0, count( $pendingDBs ) - 1)];