asked on

Could you give me an strategie on how to mantain a centralized DB Server receiving data from decentrilized servers from time to time?

Hi Experts

Could you give me an overall strategie on how to mantain a centralized DB Server with its correspondnt databases receiving data from other decentrilized servers and databases from time to time?

The actualization between the decentrilized server and the centrilized server wouldn't need to be automatic, a D-1 actualization would be good (running when the resources comsumption is low).

The objective is to use Big Data analysis on the centralized DB.

Thanks in advance!

ASKER CERTIFIED SOLUTION

hilltop

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

bbao

generally speaking you need find a way (policy) to let both centralised server and the decentralised servers trust each other.

commonly there are two approaches: network based or server based.

1. network based, as authorisation (i guess that's what you mean by "actualization") "wouldn't need to be automatic", you may set up a manual VPN between between the central server and downstream servers. once the VPN has been established, the servers can by reached and synced with each other, then disconnect the VPN once finished. this approach would be simple if the connection and sync doesn't is not needed often.

2. server based, which means both centralised server and the decentralised servers only connect to each other over encrypted connection based on privately issued certificates. this can make sure both central and downstream parties trusted with each other.

Eduardo Fuerte

ASKER

Hi

Thank you for your replies.
I'm still analysing it.

Eduardo Fuerte

ASKER

Thank you for the help!