Synchronize DB: Synchronize two MySQL databases

Recommend this page to a friend!
  Info   Screenshots Screenshots   View files View files (2)   DownloadInstall with Composer Download .zip   Reputation   Support forum (4)   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStar 56%Total: 4,437 This week: 2All time: 636 This week: 127Up
Version License PHP version Categories
db_sync 1.0.0GNU General Publi...4.0Databases, Systems administration
Description Author

This class can be used to synchronize two MySQL databases.

It connects to a given master and slave databases and analyzes what changed in the master database.

The database table changed rows in the master and updated on the slave database.

Innovation Award
PHP Programming Innovation award nominee
September 2008
Number 2
Sometimes it is necessary access a database in a remote site but the connection to that site may not be always available.

A common solution for that problem is to keep a local slave database with a copy of the information in the remote master database. Then when the connectivity with the remote site becomes available again, the master and slave databases are synchronized.

This class implements a solution that can perform such kind of synchronization between a master and a slave MySQL database.

Manuel Lemos
Picture of Cristian Vrinceanu
Name: Cristian Vrinceanu <contact>
Classes: 1 package by
Country: Romania Romania
Age: 43
All time rank: 67013 in Romania Romania
Week rank: 132 Up2 in Romania Romania Up
Innovation award
Innovation award
Nominee: 1x

Screenshots  
  • result2.jpg
  Files folder image Files  
File Role Description
Plain text file exemple.php Example The example script file.
Plain text file sync.php Class The class source file

 Version Control Unique User Downloads Download Rankings  
 0%
Total:4,437
This week:2
All time:636
This week:127Up
User Ratings User Comments (3)
 All time
Utility:82%StarStarStarStarStar
Consistency:72%StarStarStarStar
Documentation:-
Examples:80%StarStarStarStarStar
Tests:-
Videos:-
Overall:56%StarStarStar
Rank:1718
  

For more information send a message to info at phpclasses dot org.