php.activerecord

Subject: Using activerecord with multiple DB shards/partitions

Hi Everyone,

I am looking to re-purpose my existing active record to connect to different DB shards. I was thinking that I could use set_connections where each key maps onto a seperate DB shard connection.

I am willing to accept the risk of poor performance right now by sequentially accessing. The important thing is to get this working and optimizing it later (async queries, etc). I will probably be using memcache to lookup shards, however I need a basic scan first (User Id will be a UUID so I can guarantee it is unique)

I was wondering how I could do something like:

$cfg = ActiveRecord\Config::instance();
 $cfg->set_model_directory(BASEPATH . '/Persistence/models');
 $cfg->set_connections(
   array('user_shard_1' => 'mysql://user:[email protected]/user_schema_!',
              'user_shard_2' => 'mysql://user:[email protected]/user_schema_2' )
);

Then be able to loop over all connections and fetching results one at a time:

// Use the PHP ActiveRecord models to access data, however execute it against each connection
// sequentially.
foreach (User::connections() as $conn) {
$conn->find_by_user_id($id);
}

Thank you,