What's the best solution for huge amount of data,fulltext search?

Question

I'm currently using MYSQL,

and it becomes the bottle neck of the whole system

Answer 1

Consider Solr (not to be confused with the Solar Framework for PHP). It is based on Lucene and designed to scale, if that is one of your concerns.

Other Solr-related links you might find helpful:

• Brief write-up at Wikipedia.
• Solr Tutorial
• Solr Wiki

Answer 2

Try Lucene indexing: lucene.apache.org. There is also a very good implementation in PHP as a part of Zend Framework.