Replikwando

From ISoft Wiki
Jump to navigationJump to search

Information

Replikwando is ISoft's database replication program. While active, all changes on your ITrack table will change our locally hosted data. This allows us to make changes to HeavyTruckParts.net as you make changes on site.

Installation

For installation, please see Replikwando installation.

Technical Support

Replikwando is a service program meant to be run full-time. If the external internet connection goes down but your clients can still make changes to your local database, Replikwando will just wait for the connection to go back up before sending changes. No data is lost from a disconnect.

All normal operations on the database will be transmitted without error. This includes any changes you make through the ITrack Pro and Enterprise clients. However, editing the database using a different client (such as SQLyog) may result in errors if incorrect or external tables are referenced.

If your Replikwando starts showing errors on its diagnostic screen, or if your HeavyTruckParts.net account seems out-of-date, please call us so we can get you back up to speed as soon as possible!

Currently, installation procedure limits the binary log duration to ten days. If any Replikwando installation happens to go out of sync for a longer time than ten days, a complete push will need to be done.

Known Issues

Currently, Replikwando will not run as a service on Windows Vista or Windows Server 2008. This is a known limitation of our current service infrastructure, and will be fixed in a later update. For the time being, Vista/Server 2008 have excellent task schedulers that allow you to run replikwando on startup.

Any database that reads a local sql file using the LOAD DATA INFILE command is not handled correctly, and will cause an error.

Any calls to a database that are not the replicated one will most likely fail (ie: INSERT INTO `my_db`.`table` SELECT * FROM `not_my_db`.`table`)

Other additional errors may be found here.