Selecting nearby points from the database?

Question

Database

Hello. An idea for the project was born, but for its implementation, work with coordinates is needed. The data with coordinates is stored in the database and it is necessary, roughly speaking, to obtain records within a radius of 100 km for certain coordinates. Since I am 0 in this topic, there are questions:
1) Is it possible to implement this at all?
2) MySQl is suitable for these purposes
3) What database would be best for such purposes
4) How will the server behave when fetching 2 million records
4) Share links to materials on the topic
Thank you in advance

Answer 1

1) Yes.
2) Yes.
3) Any.
4) Normal.
5) Count how many of your 100km are translated into coordinates and make a selection , mathematics and elementary conditions.

Answer 2

I would try Redis . It has functions for working with GEO coordinates and other good things. Calculating the distance by geo coordinates is not such a simple formula, because the planet Earth is not a ball, and I think it will be problematic to push the formula into an SQL query, but if you need an approximate value and plus / minus a kilometer do not play a role, then yes, it will do MySQL