DISTRIBUTE BY FUNCTION

Partition the database based on the service or functionality it needs to provide. This allows the application software for this functionality to be built round this new offshoot of the database. Similarly business level functionality should be split into separate application servers for high volume sites.