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/ _______________________________________________ List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class Wiki: http://dbix-class.shadowcatsystems.co.uk/ IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/ Searchable Archive: http://www.mail-archive.com/[email protected]/
