How to properly organize caching and database on nodejs?

Question

MySQL

The goal is to create a mobile application and an admin panel for a delivery service. The application will send the coordinates of the courier every n seconds to the server and the ability to take orders for delivery by couriers. In the administrative panel there will be a map with orders and couriers, as well as managing orders and couriers. There will also be a map with couriers on the site. Order history is saved.
The server is written in nodejs. Mobile application on ionic + angularjs + ngcordova + socket.io.
I plan to use MySQL as a DBMS, but all data is cached by Redis.
Does it make sense to use socket.io to receive data for the frontend?
Should I use a DBMS or can I get by with just Redis?

Answer 1

> every 10 seconds there will be an update of all couriers
. This is yours and php can withstand the usual, nodejs I would take if all couriers were updated 5 thousand times per second ))