When running a Replicate task with MySQL source endpoint and getting the following error in the task log:
[SOURCE_CAPTURE ]E: Error 1040 (Too many connections) connecting to MySQL server ‘xxx.yyy.zzz'
Cause
This error can be caused due to unsupported version of MySQL ODBC driver
Environment
- Replicate with MySQL source endpoint
Resolution
For every Replicate version, the supported ODBC driver versions are listed in the Replicate Users Guide under:
Adding and managing source endpoints --> Using a MySQL-based database as a source --> Prerequisites --> Client prerequisites
For example the ODBC driver version supported in Replicate 2021 November release are:
MySQL ODBC 64-bit client 5.3.11 or above. However, Drivers 8.0 to 8.0.22 are not supported.
