Member Avatar for osoerland

Hi,

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?

Regards
Ottar.

  • 2 Contributors
  • 1 Reply
  • 116 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by griswolf
Member Avatar for 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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.