Login   Register  
PHP Classes
elePHPant
Icontem

Synchronize DB

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us

  Author  
Picture of Cristian Vrinceanu
Name: Cristian Vrinceanu <e-mail contact>
Packages: 1 Browse all classes by Cristian Vrinceanu Browse all classes by
Country: Romania Romania - PHP jobs in Romania
Age: 35
All time rank: 83618 in Romania Romania
Week rank: 542 Up12 in Romania Romania Up
Innovation award
Innovation award
Nominee: 1x


  Detailed description   Download .zip .tar.gz  
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.

  Classes of Cristian Vrinceanu  >  Synchronize DB  >  Download .zip .tar.gz  >  Support forum Support forum (4)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: Synchronize DB
Base name: db_sync
Description: Synchronize two MySQL databases
Version: -
PHP version: 4.0
License: GNU General Public License (GPL)
All time users: 3253 users
All time rank: 947
Week users: 5 users
Week rank: 510 Up
 
  Groups   Screenshots Screenshots   Rate classes User ratings  
  Trackback   Applications   Files Files  

  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

  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 (88.9%)
Good (80.6%)
-
Good (88.9%)
-
-
Sufficient (61.4%)
749
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...

  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.