How to transfer data between servers?

Question

Node.js

I have mysql with central nodejs server on one pc. The second node.js server is also located remotely. What is the best way to transfer data from the server center to the remote one: net, websocket, ajax? The request from the remote server will be about once an hour, approximately 10 thousand rows from mysql need to be transferred.

Answer 1

Since this is not some kind of sqllite3, it may make sense to simply create a separate user on this database with read-only rights and already pull directly from that server? The strange intermediary turns out.