tMySQL component, MiriaDB as DB Version decrease performance.

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!
3 REPLIES
Twelve Stars

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

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.

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!
Twelve Stars

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

Welcome Smiley Happy
-----------