MySQL db synchronization

[santos007]

We have developped an application for Real Estate management for a client. Everything runs fine, however, the client wants, now, before to pay us the balance due, that the application could run locally and be synchronized automatically. We have developped the application using PHP and MySQL to be run in Internet. We are planning to use locally PHPTRIAD, it works fine, however, we are experiencing problems with synchronization.
Could anyone offers us a suggestion?

[ronniethedodger]

You said it works fine, but you are experiencing problems. What problems?

Also see this topic. The discussion deals with a lot of the questions you are asking.

[santos007]

It works fine on Internet, however, my client wants to work locally and then to have both DB synchronized, the one in Internet and the local one and we are having difficulties in this synchronization.

[ronniethedodger]

Try SQLyog a free MySQL database synchronizer. It is described in detail here in an article.

[cyanide]

Originally Posted by ronniethedodger

Try SQLyog a free MySQL database synchronizer. It is described in detail here in an article.

Awesome post there ronnie.

I always have 2 copies of a script/database (local and live). It's a pain in the arse making sure they're the same... export, save as... if it's big lots of waiting, then ofcourse uploading ugg!

2 - thumbs up

Have you actually used it ?

[mushroom]

Originally Posted by ronniethedodger

Try SQLyog a free MySQL database synchronizer. It is described in detail here in an article.

Not Free ( 30 trial )

1-9 licenses
$49/license
10-49 licenses
$39/license
Site License **
$695

Site License **
( Educational / Non Profit Organizations )

$395

[cyanide]

haha yes, that's true mushroom.

just found that out

[ronniethedodger]

I was going off of the article which is dated. The article was dated Feb-14-2003. Obviously there have been some changes. =(

No Cynanide ... I have not tried it. But it appears to be well recieved.

Try this instead SQLyog Job Agent v2.0 which is a free according to their FAQ.

New! Q. I want to bring data of two database located in different hosts in Sync with each other. How can I do it in SQLyog ?

A. SQLyog Job Agent ( SJA ) is a high-performance, multithreaded, multi platform application to automate and schedule Synchronization of Data between two MySQL hosts. On Windows, it is included with SQLyog 3.63 - the latest version of the award winning MySQL Client. The Linux version of SJA is FREE and can be downloaded from http://www.webyog.com/sqlyog/downsja.html. In SQLyog, it can be accessed through Tools->Database Synchronization Wizard.

SJA does not require any installation at hosts running the MySQL server. You can use any host to run the SJA. For example – you can use SJA to keep your production databases ( probably hosted with an ISP ) in complete sync with your test database located in your PC or LAN.

SJA uses an efficient algorithm to generate checksums to find out the changes. Therefore, only those rows that have been inserted, updated or deleted since the last sync are transferred between the hosts.

Additionally, you can configure SJA to detect changes only for specific rows and columns. For example – you can exclude blob columns or include only those rows that fulfill a WHERE clause. This makes is an ideal tool to sync data even if there is limited bandwidth.

SJA is a command line tool that accepts a Job Definition file encoded in XML as one of the parameters. You can either create the Job Definition file manually or use one of the wizards included with SQLyog. If you use SQLyog to create your job files, you don’t need to have any knowledge about XML or the Job Definition schema.

On Windows platforms, SQLyog uses the Task Scheduler services to schedule your jobs. On other platforms you can use the respective OS scheduling services, e.g.– on Linux, you can use cron to schedule jobs.

Sounds pretty complicated to set up ... but worth a shot. The $49 price tag though is not too steep considering what it will do for you.