Automatic updates between two Linux servers

[shallett]

Greetings, I have two LInux servers and I want one to be the offline (near) backup, can I update a remote database say every 5 minutes via CRON?

Basically, can webyog do this automatically? perhaps every coule of minutes?

Also. I dont use X windows, all would have to be done via a command line / script / cron…

Thanks for your time….

[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