Login   Register  
PHP Classes
elePHPant
Icontem

Class: Synchronize DB

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Cristian Vrinceanu  >  Synchronize DB  >  Download .tar.gz .zip  >  Support forum Support forum (4)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: Synchronize DB
Support forum Support forum
Base name: db_sync
Description: Synchronize two MySQL databases
Related classes: , , , , , , ,
Version: -
PHP version: 4.0
License: GNU General Public License (GPL)
All time users: 2668 users
All time rank: 1165
Week users: 14 users
Week rank: 204
Picture of Cristian Vrinceanu
Author: Cristian Vrinceanu <e-mail contact>
Packages: 1 Browse this author's classes Browse this author's classes
Country: Romania Romania - PHP jobs in Romania
Age: 34
All time rank: 92819 in Romania Romania
Week rank: 267 Up7 Up in Romania Romania
Innovation award
Innovation award
Nominee: 1x


  Detailed description  
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.

 

  Groups  
Group folder image Databases Database management, accessing and searching View top rated classes
Group folder image Systems administration System configuration and management View top rated classes

  Screenshots Screenshots   Rate classes User ratings   Trackback   Applications   Files Files  
  Files folder image Screenshots  
The output of an example class usage.
File Role Description
Accessible without login Image file result2.jpg Screen The output of an example class usage.


  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

  User ratings  
Ratings
Utility
Consistency
Documentation
Examples
Tests
Videos
Overall
Rank
All time:
Good (85.7%)
Sufficient (75.0%)
-
Good (85.7%)
-
-
Not sure (58.9%)
889
Month:
Not yet rated by the users

  Trackback links  
Link Description
Synchronization of two MySQL tables An interesting class found at phpclasses.org: Synchronize DB...
Latest blog trackback links Latest blog trackback links

  Applications that use this class  
Link Description
dbsync An example of class usage.
Add link image If you know an application of this package, send a message to the author to add a link here.
  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

Download all files: db_sync.tar.gz db_sync.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.