Building a high-load database on Java + MySQL -

Building a high-load database on Java + MySQL -

i trying build application, uses mysql @ database level. main table in right 10 mbytes. however, client specified application should able store billion of records table per year. extrapolating current size turns out table should able store 750 gbytes per year.

the question - how tune database level , upper levels requirement? more specifically:

we have database level on mysql. we have glassfish server runs app. we have application uses jsp pages , jdbc connections database. the operations need provide paging list (watch part of records), add together new records, update them , remove.

so can @ each level in order improve performance?

mysql high-load