How to search by address in MySQL?

Question

MySQL

Friends, good afternoon!
There is a FIAS database imported into MySQL.
I made a separate column in the table with addresses, which stores the full address (from country to home).
For search I use fulltext index and match against. But even the use of indexes does not give the desired performance.
Please tell me which technologies are suitable for solving my problem.
Tried Lucene. Filled in 100.000 records there (2 fields: id from mysql, and full address). The search takes 3-4 seconds, and this is a lot.
I would also like to ask for materials in Russian on Lucene. Apparently I'm using it incorrectly.
Thank you!

Answer 1

Look towards ElasticSearch . It is also based on Lucene, but provides a much friendlier interface.