CODEWITHSUNDEEP
mariadbproxysql
Xosofox
Xosofox

Reputation: 890

What is Mysql/Maria "appication info" or "client identification" - and how not to send it with mysqldump?

There is a mariadb behind a ProxySQL that I am trying to connect to.

When using "debugging tools" like IntelliJ's Database plugin or DBeaver, it only works when we disable "sending application information".

In IntelliJ it is this setting:

enter image description here

On DBeaver (disable Client-Identification):

enter image description here

If we do not disable this identification, we get an error reagarding hostgroups:

ProxySQL Error: connection is locked to hostgroup 10 but trying to reach hostgroup 20

I'd like to know what this app/client id actually is - and how we disable the same setting when using mysqldump to that machine (as it results in the same error)

Upvotes: 0

Views: 176

Answers (1)

danblack
danblack

Reputation: 14646

Looking at the dbbeaver code that added the disable functionality, there application information is appears to be connection attributes.

These options appear to be added to mysqldump 9 years ago so I'm assuming this isn't a regression. There also isn't an option to disable it and I'm finding it hard to believe none of these client utilities haven't been tested with ProxySQL before

This partially look like ProxySQL issue #2522, but no mention of attributes here. Might be worthy of a new issue.

Upvotes: 1

Related Questions