On May 22, 2008, at 1:14 PM, Perrin Harkins wrote:
The module I'm presenting at YAPC::NA and OSCON this year,
DBIx::Router, will make it easier to add this kind of partitioning
after the fact. It lets you set up rules to choose which database to
send a query to. When I have a public prototype on CPAN, I'll
announce it on this list and ask for testing help.
Awesome!
Have you looked into what youtube have been presenting on, or the
skype partitioning tools ?
Both are python, but useful - as they're massively internet scale
If you haven't seen the skype stuff:
https://developer.skype.com/SkypeGarage/DbProjects/
The whitepaper is pretty good
The stuff on parition hashing is in PL/Proxy
https://developer.skype.com/SkypeGarage/DbProjects/PlProxy