[Dbix-class] Splitting Database Handle for Different Purposes

[Matt S Trout]

On Mon, Jun 04, 2007 at 05:10:09PM -0400, Frank Speiser wrote:
> Hi All,
> 
> I am having a debate here with my friend, whom I'll call PHPGuy.
> 
> We're discussing scalability and using DBIC to handle multiple DBs. 
> Eventually we're going to want to do LJ-style user clusters using the 
> same idea here, but for now, I am saying that you can split the 
> read-write and read-only traffic (and that it'll work just fine). So, if 
> I was editing a profile, I'd use the read-write handle to get data, but 
> otherwise if I were browsing it, I'd use the read-only. The read-write 
> and read only would have different cache times for reads (as an example, 
> 0 seconds and 300 seconds). It'd be nice to do this within DBIC.

http://search.cpan.org/perldoc?DBIx::Class::Storage::DBI::Replication

Marked experimental because the authors didn't write tests and nobody's told
us if it works for them yet, but it'll be shipped in 08 :)

Partitioning and caching will hopefully turn up for 09.

-- 
      Matt S Trout       Need help with your Catalyst or DBIx::Class project?
   Technical Director    Want a managed development or deployment platform?
 Shadowcat Systems Ltd.  Contact mst (at) shadowcatsystems.co.uk for a quote
http://chainsawblues.vox.com/             http://www.shadowcatsystems.co.uk/