One Star

[resolved] --compress option for mysql (RDS) connection?

So I'm having to run job on a server that connects to remote db server (AWS RDS).
This is excruciatingly slow as I don't believe that --compress is enabled for default mysql connections in talend?
For example running mysql -u*** -p*** db*** < dbfile***.sql --compress vs mysql -u*** -p*** db*** < dbfile***.sql. The difference between a normal test load (30 min) and a load with --compress (5min) is night and day.
I was wondering if it possible to setup and mysql connection with --compress, maybe in the  "Additional Paremters"?
I have also just notice the AmazonRDS->MySQL components would these perform better?
Cheers Andy
1 ACCEPTED SOLUTION

Accepted Solutions
One Star

Re: [resolved] --compress option for mysql (RDS) connection?

Just answering my own question again Smiley Tongue
Useful page here, just use "useCompression".

I'll report back with performance gains.
1 REPLY
One Star

Re: [resolved] --compress option for mysql (RDS) connection?

Just answering my own question again Smiley Tongue
Useful page here, just use "useCompression".

I'll report back with performance gains.