I'm using Hibernate 3 along with MySQL. I have a local search database application written using Hibernate / MySQL and Struts.

This database is growing quickly and I already have 250,000 businesses loaded. I want this solution to scale well ... any suggestions as to how I can break this architecture up in terms of Hibernate / MySQL as to avoid problems in the future?

I want this solution to be as transparent as possible to the Java data / services layer.