How to implement a quick search for key phrases?

Question

MySQL

At this stage, there is: mysql with a database of 500 million keywords (search queries) 20GB, in the future the number of keywords will grow and most likely will be 1 billion. Now I am doing search queries through LIKE%%, slow of course. In the future, it will be necessary to do grouping and sorting, but I think that I will already do this in php after a portioned search selection. What is the best way to organize the search so that it works faster? Maybe you should abandon mysql and use a non-relational database? Point to the true path.

Answer 1

Look towards sphinxsearch.com

Answer 2

Or towards elasticsearch IMHO it is more interesting than the sphinx.