MySQL database for genome expression studies

I work in a research lab and for most of the applications we use the LAMP framework. Our current project involves developing a web-based system for gene expression studies which typically include whole genomes. This application would require designing a database with several large tables containing several million records.

We will be dealing with such huge number of records for the first time. I was looking at optimizing MySQL for handling such large amounts of data and came upon this web site.
Any resources/pointers will be helpful.
Also, are there any advanced MySQL trainings that deal with the entire spectrum of design and tuning parameters for large databases?

Thanks

I know there is decent amount of users using MySQL to store genome data, typically as a BLOBs

I’m not however aware of any focused trainings in the area.