Add db.version and db.product as optional resource attributes

[cjksplunk]

Component(s)

receiver/mysql

Is your feature request related to a problem? Please describe.

The receiver will soon detect the database product (MySQL vs. MariaDB) and version at connect time but does not expose this information as resource attributes on emitted log records. Without these attributes, downstream consumers cannot distinguish between MySQL and MariaDB instances or filter by server version or validate that the receiver is interpreting the version and product as expected.

Describe the solution you'd like

Add db.version and db.product as optional resource attributes, disabled by default. When enabled, the values detected at connect time are stamped on all emitted log records. Both attributes will not be enabled by default so existing deployments are unaffected.

Describe alternatives you've considered

Emitting these as record-level attributes rather than resource attributes was considered, but resource attributes are the correct semantic location for properties that describe the origin of the data rather than the event itself.

Additional context

• Version and product detection is already implemented as part of MariaDB/MySQL multi-version support — this is purely a matter of surfacing the detected values.
• db.product would take values such as MySQL or MariaDB.
• db.version would reflect the server version string (e.g. 8.0.34, 10.11.7-MariaDB).

Tip

_{React with 👍 to help prioritize this issue. Please use comments to provide useful context, avoiding +1 or me too, to help us triage it. Learn more here.}

[github-actions]

Pinging code owners:

• receiver/mysql: @antonblock @ishleenk17

See Adding Labels via Comments if you do not have permissions to add labels yourself.

[tharunn0]

Hi! I'd love to work on this issue if it's available.

[cjksplunk]

Hi! I'd love to work on this issue if it's available.

Fork the repo, create a branch, implement. Read the docs on contributing. push an MR and cite this issue. You dont need anyones permission to give it a go, it just needs to be approved before it's merged. Either way it's a learning opportunity.

[singhvibhanshu]

@tharunn0,
Are you working on this?
If not, can I pick this up?

[tharunn0]

Sure, go on. @singhvibhanshu

[cjksplunk]

@tharunn0, Are you working on this? If not, can I pick this up?

An MR for multi-version support will hopefully be open next week that will have the product and version detection logic already. You can pick this up, but it might be easier to wait until that's out.

sneak peak -> https://github.com/cjksplunk/opentelemetry-collector-contrib/tree/mysql-multi-version-support/receiver/mysqlreceiver

[singhvibhanshu]

An MR for multi-version support will hopefully be open next week that will have the product and version detection logic already. You can pick this up, but it might be easier to wait until that's out.

Sure, I'll wait till your PR came up.
Thanks for informing!

[singhvibhanshu]

@cjksplunk,
Kindly let me know once your PR is up!

[cjksplunk]

@cjksplunk, Kindly let me know once your PR is up!

#47815

[singhvibhanshu]

Thanks man for informing!
Will proceed to solve this issue soon.