File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes multiple db servers for one app Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "multiple db servers for one app" Watch "multiple db servers for one app" New topic

multiple db servers for one app

Anthony Vierra

Joined: Jan 13, 2009
Posts: 2
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?

Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33124

Welcome to JavaRanch!

I don't know the full answer for mySql, but I can point to research direction. I think database partitions are the way to go. (based on a different database) A partition means the database stores the data in a tablespace based on some criteria that you specify - this sounds like what you are trying to do. I imagine you could mount those tablespaces on different machines to accomplish the end goal.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
I agree. Here's the link:
subject: multiple db servers for one app
It's not a secret anymore!