MySQL RAID Storage for large text
I have a nice big RAID. I want to know if anyone can point me in the right direction for a good way of programming php/mysql to search and store a large amount of text.
Should it be compressed and word indexed? I'm very good with sql and good with php. But I've not dealt with super huge databases with mysql and php, only mssql server.
Is an J2EE application server better to deal with something like this? If anyone knows of any good online examples of same apps with source that might get me started setting up a bench marking test, I would appreciate it!