[Metricbeat] Add TLS/SSL configuration options in the MySQL module

[romain-chanu]

Describe the enhancement: following-up this Discuss topic.

The MySQL module configuration for Metricbeat does not provide any configuration / parameters to specify the list of trusted root certificates or other TLS/SSL parameters (e.g. client certificate, client certificate key, etc.).

It could be confusing to users that Metricbeat provides TLS/SSL options/parameters for Elasticsearch, Kibana, or other modules (e.g http) but does not provide these to the MySQL module itself.

As shown in the Discuss topic, If users decide to connect to a MySQL database with SSL (i.e adding tls=true in the host DSN), they would need to download and add the root certificate in the host certificate store where Metricbeat runs. If the root certificate is not present, Metricbeat will thrown an error: x509: certificate signed by unknown authority.

Describe a specific use case for the enhancement or feature: Given a MySQL database configured with SSL, provide the ability to configure the MySQL module for Metricbeat with TLS/SSL options/parameters.

[botelastic]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.