Contact Gamma Soft

Real-Time4 MySQL, a real-time solution to integrate MySQL database on the data’distribution technology

Real-Time4 MySQL is the real-time solution to integrate MySQL data based on the data’distribution technology.

Real-Time4 MySQL reads the MySQL transactions log to integrate - in real time, with high data availability and in complete security My SQL database content or updates (CDC).

Real-time data exchanges between MySQL and any other database


Real-Time4 MySQL is a solution designed to easily and securely distribute MySQL database updates or content (via extraction): Microsoft SQL Server, MySQL, Oracle Database, IBM AS/400-iSeries-Power i, PostgreSQL, Sybase ASE, Progress OpenEdge, ODBC, XML, text files, applications, ERP, etc., whatever the operating system (Windows, OS/400, i5/OS, UNIX, etc.).

 

The capture of the MySQL database table updates is based on the MySQL transactions log via the CDC (Change Data Capture) technique. Once captured, Real-Time4 MySQL applies all the updates performed on the appropriate tables - either in real time or in deferred mode - on one or more targets (Oracle database, Microsoft SQL Server, IBM AS/400-iSeries-Power i, Sybase ASE, DB2, MySQL, PostgreSQL, ODBC, applications, ERP, etc.).

 

 

Real-Time4 MySQL retrieves data from the transactions log 


Real-Time4 MySQL retrieves data from the transactions log or with generated triggers and loads a specific data'distribution log structure (similar to a transactions log), allowing for highly precise recovery management and transaction traceability.

 

Given that the entire selection and transformation process is run on the source machine in PUSH mode, only the data you require is transferred - in the required format - to the target machine, which can also perform transformations on the fly.

The selection-transformation module can call all existing programs on the machine as well as the procedures stored on the database, thus enabling you to reuse existing management rules.

 

 

Real-Time4 MySQL is based on the data’distribution technology


The Real-Time4 MySQL architecture is based on the data'distribution technology. This offers the following main benefits:


  • Compliance with the MySQL architecture
  • Very low CPU consumption
  • Very high fault tolerance (network, system, etc.)
  • Targets fully slaved