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?