Mysql

SQLyog Job Agent for easy MySQL Replication and Synchronization

SQLyog Job Agent promises to make MySQL Replication and Synchronization and easy job…

Quote:

SQLyog Job Agent v2.0 (SJA) is a high-performance, multithreaded, multi platform application to automate and schedule Synchronization of Data between two MySQL hosts and send personalized mails with results returned from a query. On Windows, it is included with SQLyog 3.71 – the latest version of the award winning MySQL Client.

Features:

  • efficient algorithm for change checksums : those rows that have been inserted, updated or deleted since the last sync are transferred between the hosts.
  • configure SJA for One Way or Two Way synchronization
  • 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 it 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.

This schema is described here

Average rating
(0 votes)

Similar entries