hi im looking for a point in the right direction. i would like to setup 1 mysql db server for user account data with pointers to X other db mysql servers with data split into 1TB dbs. the reason for this is that all logged in users will access all data depending on share permissions. i was looking at partitioning in mysql with hibernate shards, but this seems far to complicated. it would seem that there should be some simple way to specify pointers to other dbs from within the login db. we are currently using tomcat/struts2/spring/hibernate/mysql. where do i need to start researching to accomplish this?