Automatic updates between two Linux servers

[Ritesh]

SJA is a perfect solution for you 😀

Being a command line tool it dosnt require X.

Using CRON you can schedule SJA to be executed every 5 minutes. Make sure you are providing a correct schema file to SJA. More information on the schema file can be found at:

http://www.webyog.com/sqlyog/sjaschema.html

[shallett]

Greetings and thanks for the reply,

So, is SQA (Agent) Free and separate from SQLyog?

Or should I purchase SQLyog?

How about performance?

I will be doing this over a hosted outbound connection with

limited transfer and will by syncing a DB thats pretty big and very often?

So does it resync the whole DB? Or just the updates?

Basically is it something I can run every couple of minutes?

Thanks for your time, take care…

---

Jagger (at) cyclelistings.com

– Free Motorcycle Classifieds

Hands down The best on the Net

http://www.cyclelistings.com

---

[Ritesh]

The Linux version of SJA is FREE. For Windows, you need to purchase SQLyog.

SJA generates checksums to find changes between the two databases. It only transfers the checksum values over the network.

Quote:

So does it resync the whole DB? Or just the updates

Just the updates. After checking the checksums it only transfers data that needs to be updated.

Quote:

Basically is it something I can run every couple of minutes?

Yes.

[Author]

Posts