Synchronizing MySQL database using master slave approach - Laravel 4

I am using a specific API to fetch data from the server and store it in my DB. Since the size of the data is very large, I do it this way as it takes a long time to fetch in real time. The point is that the main DB can be updated: records are updated, created, or even deleted from the DB. To update the database, one way is to resample the data and check each record if any changes have occurred to it. This method is ineffective.

Is there any other way to keep the DBs in sync between them while ensuring my DB is up to date ?!

+3
php mysql laravel-4 sync


source to share


No one has answered this question yet

Check out similar questions:

2568
Should I be using the datetime or timestamp datatype in MySQL?
1762
How to import SQL file using command line in MySQL?
1290
How do I get a list of user accounts using the command line in MySQL?
1112
What MySQL data type is used to store boolean values
1105
How to reset AUTO_INCREMENT in MySQL?
1086
How do I connect to a MySQL database in Python?
1066
How do I display the results of MySQL queries in CSV format?
770
How to "insert if doesn't exist" in MySQL?
697
Finding duplicate values ​​in MySQL
276
How to sync core core data with web server and then push to other devices?



All Articles
Loading...
X
Show
Funny
Dev
Pics