I've set up a secure connection between unixODBC driver manager / MySql ODBC driver on solaris (where we run informatica) and mySql on Windows. It works, but the problem is, that whereas getting informatica to pull data (select) from MySql is reasonably fast, uploading data (inserts) are painfully slow. In fact, inserts via the ssh tunnel are 100 times slower than 'unsecured' inserts (connecting without the tunnel). When we do download/selects we hardly see any difference between using the tunnel and not using the tunnel.
Anyone have any ideas?


7 Years
Discussion Span
Last Post by griswolf

It looks like you are using the 'port forwarding trick' (because you say 'tunnel') to get outbound SSH behavior. If true, then consider recompiling with direct ssh enabled. Don't know if that will be helpful or not. See here: http://www.networkcomputing.com/servers-storage/how-to-set-up-ssh-encrypted-mysql-replication.php which says, among other things

Although MySQL can be compiled with support for SSL, many binary distributions do not have this feature enabled. Open a SQL prompt and type "show variables like '%ssl%'. If 'have_ssl' or 'have_openssl' are set to 'No,' you're out of luck. Fortunately, there is an alternative to recompiling from source. Secure Shell (SSH) supports data-tunneling, which sets up a mini VPN-like environment offering transparent encryption.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.