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
MYSQL supports this natively as defined in this how-to article https://www.digitalocean.com/community/tutorials/how-to-set-up-master-slave-replication-in-mysql