topic Re: tMySQL component, MiriaDB as DB Version decrease performance. in Talend Studio

tMySQL component, MiriaDB as DB Version decrease performance.

Anonymous — Fri, 25 Nov 2016 13:27:44 GMT

Hi all,
I am working on migration from AS400DB2 server to MariaDB with some lookups. I notice strange behavior of job performance.
If in Database Connection I select from dropdown Db Version “MariaDB” job runs two times longer than when selected “MySQL 5”.
Also I notice that for MariaDB connection Talend Open Studio for Data Integration use mariadb-java-client-1.1.7.jar driver. Now version 1.5.5 is available but I can’t find how to update it in Talend.
Any ideas about strange performance behavior?
Can somebody help to update MariaDB driver used in Talend?
Thanks!

Re: tMySQL component, MiriaDB as DB Version decrease performance.

vapukov — Sat, 26 Nov 2016 03:22:55 GMT

Hi Yuriy,
what version of studio? how You use MariaDB connection when measure performance? (write or read)
generally for change JDBC, You need found all XML files related to MySQL and edit them - change information for the new version
than - menu Windows -> View -> Talend -> Modules and update all of them

Re: tMySQL component, MiriaDB as DB Version decrease performance.

Anonymous — Mon, 28 Nov 2016 09:21:35 GMT

Hi Vladimir,
Thanks a lot for your help! It worked!
I updated driver to newer version (I used mariadb-java-client-1.5.4) as you described, and performance become even better than with MySQL 5.
Thank you!

Re: tMySQL component, MiriaDB as DB Version decrease performance.

vapukov — Mon, 28 Nov 2016 09:39:57 GMT

Welcome