MYSQL database heterogeneous log based replication

A method that uses log based replication to transfer data between a MySQL database or system that uses binary log files, and a second database or system, comprising the steps of:

• providing one or more libraries for use in accessing a first database or system that uses binary log files,
• providing a vendor access module (VAM) including a plurality of binary log classes that wrap around the libraries,
• a plurality of event classes, and
• a plurality of reader and processor classes,
• recognizing event data as recorded in a binary log file by the first database or system,
• converting the event data into data records by using the plurality of event classes,
• reading and processing the data records with the reader and processor classes, and sending the data records to a record queue, and
• communicating with an extract process to process the data records and to generate a trail file containing the processed data,
• wherein the processed data is set up to be applied to the second database or system.

A non-transitory computer readable medium, including instructions stored thereon, wherein the instructions, when read and executed by a computer, cause the computer to perform the steps comprising:

• providing one or more libraries for use in accessing a first database or system that uses binary log files,
• providing a vendor access module (VAM) including
• a plurality of binary log classes that wrap around the libraries,
• a plurality of event classes, and
• a plurality of reader and processor classes,
• recognizing event data as recorded in a binary log file by the first database or system,
• converting the event data into data records by using the plurality of event classes,
• reading and processing the data records with the reader and processor classes, and sending the data records to a record queue, and
• communicating with an extract process to process the data records and to
• generate a trail file containing the processed data;
• wherein the processed data is set up to be applied to a second database or system.