File storage method: MySQL, NoSql or something else?

Question

MySQL

Hello.

I think over the system and the following tasks arose. It is necessary to:
1. Store about a million html files
2. The same number of text files
3. zip, pdf files
4. Need to search in text and html files

If it matters, then I have some experience using the mysql + sphinx bundle.
Scalability is needed up to about 10 million html and the same number of text files.

What solutions can you recommend?
1. Where and how best to store html and txt files?
2. Where and how best to store archives and pdf?
3. How are data stored, for example, by search engines? Where to read?

Answer 1

Offhand mogilefs (old, tested but in my experience - very buggy in conjunction with nginx) and gridfs (devil-pipe, our choice).