We are currently running live MySQL. would need real-time MySQL synchronization to a backup server for data analysis and/or incase the main MySQL breaks down.
google suggest to initially take a MySQL dump, restore in slave server and than starts synchronization process.
With that, we could not afford to temporary shutdown process to create the dump as it is a live server.
synchronization of databases, tables , data (without MySQL dump) must start from day 1 and must be in real-time or near real time.
We will provide 2 test server, Master and Slave. Once completed, we will copy the script to our live server ourself. So, would need a how-do list for us to implement our self.
19 freelanceria on tarjonnut keskimäärin $180 tähän työhön
I can write an application/service which will synchronise (I hope this is only one way from master to slave which is less complecated) on given interval. ex: every 1min.
Hi It depends of the MYSQL versions, there are built in capabilities for replication. Seperate tables can be replicated and entire DB too. Without scheduled downtime this isn't possible to activate the replication.
Hello Sir, I did MySQL syncing previous and I am confident that I can do it again for you I am web developer having 7 years of experience looking forward from your end Thanks, Laxman Parmar
Hi There, thanks in advance. I've more than 5+ years of corporate work experience in Linux/Unix, also train people on Linux/Unix. Expert in designing software architecture & software deployment on cloud environment.