Question & Answer
Question
Mysql connection can be made using mysql network traffic compression option. Does Guardium support monitoring these connections? Is there any known mysql client that uses compression? What behavior will I see if I try and monitor these connections?
Cause
Mysql --compress option is used to set this. From the mysql manual:
Compress all information sent between the client and the server if both support compression
Answer
Guardium does not support monitoring mysql client to server connection using compression.
At the time of writing the only known client that uses compression by default is 'SQLyog'. The compression option can be turned off in SQLyog by deselecting "use compressed protocol" on the connection screen.
The exact behavior can vary in different cases. For example you might find:
- Missing SQL statements.
- Missing user names.
- SGATE termination does not work, even in closed mode.
- Other policy actions are not triggering as expected.
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21996804