Re: [gnome-db] libgda: mysql provider compression

[Diego Zuccato <diego otello alma unibo it>]

Bruno A. Castro ha scritto:

> I have been googling for a few trying to find any way to activate MySQL
> compression (my clients are connected through HSDPA/3G mobile
> connection)
IMVHO the best way to do it is using a compressed SSH tunnel that 
forwards ports.
Just run :
ssh -L ${LP}:${DBSERVER}:${SP} ${USER} ${SSHSERVER}
before running your program. Then you'll connect the client to 
localhost:${LP} instead of ${DBSERVER}:{$SP} .

This way, not only the connection is compressed, but it's secure too... 
Better be prepared for users that put sensitive data in the db.
And you haven't to add too many firewall rules (exposing a server, 
expecially a db server, is always a security risk). The machine that 
receives SSH connection can be a DIFFERENT one than the db server (and 
it's better if it is, from a security POV, since it should have an 
account for every user).

Obviously it's better if server and client use certificates for 
authentication. You can setup compression in ssh config file.

BYtE,
 Diego.