[Dbix-class] Splitting Database Handle for Different Purposes

[Frank Speiser]

Thanks, Matt.

Maybe we can contribute to it and get it back in. This kind of thing is 
nearly impossible in PHP (with Creole + Propel).

Thanks for all the help so far. It's very much appreciated.

-Frank

Matt S Trout wrote:
> 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.
>
>   


-- 
Frank Speiser
CTO
TAKKLE, Inc. 
212.792.5854 (work)
212.792.5859 (fax)
frank at takkle.com