This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC 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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "multiple db servers for one app" Watch "multiple db servers for one app" New topic
Author

multiple db servers for one app

Anthony Vierra
Greenhorn

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
internet detective
Marshal

Joined: May 26, 2003
Posts: 30068
    
149

Anthony,
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.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: multiple db servers for one app
 
Similar Threads
Hibernate & Date
mySQL via EJB in reference implementation
MySql synchronisation
GuestBook Servlet
Hibernate Shards for multi DB servers?