init_config:

instances:
  - server: <host>
    user: <USER>
    pass: <SECRET>
    # port: 3306             # Optional
    # sock: /path/to/sock    # Connect via Unix Socket
    # defaults_file: my.cnf  # Alternate configuration mechanism
    # connect_timeout: None  # Optional integer seconds
    # tags:                  # Optional
    #   - optional_tag1
    #   - optional_tag2
    options:
       replication: false
    #   replication_non_blocking_status: false  # grab slave count in non-blocking manner (req. performance_schema)
    #   galera_cluster: false
       extra_status_metrics: true
       extra_innodb_metrics: true
       extra_performance_metrics: true
    #   schema_size_metrics: false
    #   disable_innodb_metrics: false
  - server: <host>
    user: wp_qa
    pass: <USER>
    options:
       replication: false
       extra_status_metrics: true
       extra_innodb_metrics: true
       extra_performance_metrics: true
    #
    #     NOTE: disable_innodb_metrics should only be used by users with older (unsupported) versions of
    #           MySQL who do not run/have innodb engine support and may experiment issue otherwise.
    #           Should this flag be enabled you will only receive a small subset of metrics.
    #
    #     NOTE: extra_performance_metrics will only be reported if `performance_schema` is enabled
    #           in the MySQL instance and if the version for that instance is >= 5.6.0
    #
    #           extra_performance_metrics and schema_size_metrics will run two heavier queries
    #           against your DB to compute the relevant metrics for all your existing schemas.
    #           Due to the nature of these calls, if you have a high number of tables and/or schemas,
    #           you may be subject to some negative impact in the performance of your DB.
    #           Please bear that in mind when enabling them.
    #           Metrics provided by the options:
    #                     - mysql.info.schema.size (per schame)
    #                     - mysql.performance.query_run_time.avg (per schema)
    #                     - mysql.performance.digest_95th_percentile.avg_us
    #
    #           With the addition of new metrics to the MySQL catalog starting with agent >=5.7.0, because
    #           we query additional schemas to get this full set of metrics. Some of these require the user
    #           defined for the instance to have PROCESS and SELECT privileges. Please take a look at the
    #           MySQL integration tile in the Datadog WebUI for further instructions.
    #
    # ssl:               # Optional
    #   key: /path/to/my/key.file
    #   cert: /path/to/my/cert.file
    #   ca: /path/to/my/ca.file

    # queries:               # Optional
    #  - # Sample Custom metric
    #    query: SELECT TIMESTAMPDIFF(second,MAX(create_time),NOW()) as last_accessed FROM requests
    #    metric: app.seconds_since_last_request
    #    tags:               # Optional - only applied to this custom metric query, will not affect default mysql metrics
    #        - custom_tag1
    #        - custom_tag2
    #    type: gauge
    #    field: last_accessed
    #  - # Sample Custom metric
    #    query: SELECT TIMESTAMPDIFF(second,MAX(create_time),NOW()) as last_user FROM users
    #    metric: app.seconds_since_new_user
    #    tags:               # Optional - only applied to this custom metric query, will not affect default mysql metrics
    #        - custom_tag1
    #        - custom_tag2
    #    type: gauge
    #    field: last_user