Opening Multiple DB Connections to MySQL via SSH Tunneling

[Jonathan_Cohn]

I'm connecting to a MySQL database through SSH.  Specifically I'm using PuTTY to establish a connection, and then tunnel the port through 3306.  Then I'm creating an ODBC Data source to my local 3306 port and using that datasource to open the connection in LabVIEW.

I'm looking to run queries in parallel, and to do that, I believe I need to open up multiple connections.  Has anyone tried this before? Is there anyother way to do this?

[Bogdan-B]

Hi Jonathan,

I wasn't able to find too many resources on using multiple connections to a MySQL through SSH.  

I was able to find this:

http://digital.ni.com/public.nsf/allkb/C49602A79827DDBE86256CE9005757D5

that might give you some more information.

I would try to open up multiple connections if the database supports it and try it that way.

If you have any troulbe with that route, feel free to let us know.

Sincerely,

Bogdan Buricea

Applications Engineering

National Instruments