MySQL requirements

Versions supported by the TRIGGER LogReader are from 5.5.
The VM or physical machine must have 2 cores or more, 4GB RAM ore more, an OS >Windows 2008R2 (not necessarily the server type), and 32 or 64 bits.
The installation must be performed with an administrator profile.
The connection port to MySQL database must be open between Talend Change Data Capture source machine and MySQL database.
The ODBC 32-bit MySQL driver must be installed on Talend Change Data Capture source machine.
The driver installation may require to additionally install a Microsoft Visual C++ XXX Redistributable (x86) package. For example, for the MySQL ODBC 5.3 driver on a 2012 server, you must install Microsoft Visual C++ 2013 Redistribuable (x86) package.
To test the ODBC 32-bit MySQL driver, you may for example create a system data source.
To capture the source, the trigger-based mode requires to have a user profile with specific permissions on the source database:
- Right of connection for the Talend Change Data Capture remote server,
- Read permission on the database you want to capture,
- Right of trigger creation on the database you want to capture.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!