Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 37394 - sja-bin-1.1.ebuild (New Package for SQLyog Job Agent)
Summary: sja-bin-1.1.ebuild (New Package for SQLyog Job Agent)
Status: RESOLVED WONTFIX
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: New packages (show other bugs)
Hardware: x86 Linux
: High enhancement (vote)
Assignee: Default Assignee for New Packages
URL:
Whiteboard:
Keywords: EBUILD
Depends on:
Blocks:
 
Reported: 2004-01-06 08:46 UTC by Ben Thomas
Modified: 2007-09-14 15:21 UTC (History)
0 users

See Also:
Package list:
Runtime testing required: ---


Attachments
sja-bin-1.1.ebuild (sja-bin-1.1.ebuild,1.19 KB, text/plain)
2004-01-06 08:49 UTC, Ben Thomas
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Ben Thomas 2004-01-06 08:46:45 UTC
Ebuild for SQLyog Job Agent 1.1 binary application.

From http://www.webyog.com/sqlyog/sja.html :
SQLyog Job Agent v1.1 ( SJA ) is a high-performance, multithreaded, multi platform application to automate and schedule Synchronization of Data between two MySQL hosts.

SJA does not require any installation at hosts running the MySQL server. You can use any host to run the SJA. For example 
Comment 1 Ben Thomas 2004-01-06 08:46:45 UTC
Ebuild for SQLyog Job Agent 1.1 binary application.

From http://www.webyog.com/sqlyog/sja.html :
SQLyog Job Agent v1.1 ( SJA ) is a high-performance, multithreaded, multi platform application to automate and schedule Synchronization of Data between two MySQL hosts.

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 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 dont need to have any knowledge about XML or the Job Definition schema.

Reproducible: Always
Steps to Reproduce:
Comment 2 Ben Thomas 2004-01-06 08:49:54 UTC
Created attachment 23240 [details]
sja-bin-1.1.ebuild

Needs env.d file located in sja-bin/1.1/90sja to set path.
90sja:
PATH=/opt/sja/bin
Comment 3 Jakub Moc (RETIRED) gentoo-dev 2007-09-14 15:21:55 UTC
Not adding binary-only trialware, sorry.