Login   Register  
PHP Classes
elePHPant
Icontem

Synchronize DB: Synchronize two MySQL databases

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

  Author Author  
Picture of Cristian Vrinceanu
Name: Cristian Vrinceanu <contact>
Classes: 1 package by
Country: Romania Romania
Age: 37
All time rank: 76115 in Romania Romania
Week rank: 225 Up6 in Romania Romania Up
Innovation award
Innovation award
Nominee: 1x


  Detailed description   Download Download .zip .tar.gz   Install with Composer Install with Composer  
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 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: 1.0.0
PHP version: 4.0
License: GNU General Public License (GPL)
All time users: 3754 users
All time rank: 802
Week users: 8 users
Week rank: 166 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  
result2.jpg
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  
RatingsUtility Consistency Documentation Examples Tests Videos Overall Rank
All time: Good (88%) Good (80%) - Good (88%) - - Sufficient (61%) 788
Month: Not yet rated by the users

  Pages that reference this package  
Synchronization of two MySQL tables
An interesting class found at phpclasses.org: Synchronize DB...

Latest pages that reference packages Latest pages that reference packages


  Applications that use this package  
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

Install with Composer Install with Composer - Download 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.