如何在本地/中央MySQL服务器和多个远程MySQL服务器之间自动获取数据同步

We have a scenario where 100 or more remote MySQL local servers are deployed in different parts of the world, they are gathering different data from every place into the same local table and we need a master MySQL server which consolidates all these data and serves the data to the user. The synchronization need to be only uni-directional; only Master needs an update from the remote servers, not the other way around.

The best option will be to automatically synchronize the Master server with either pull or push mechanism whenever there is an update on any of the remote servers, however the synchronization also can be daily. One of the problems is that the local systems can be offline anytime and they are still able to gather data, finally they should upload the data once they got back online.

I'm not sure whether replication will help me here. I just wanted to know whether this requires a custom solution or is there anything that MySQL or any other software provides