Mysqld Exporter should point to each controller database

Bug #1863041 reported by Danni Setiawan
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
kolla-ansible
Fix Released
Medium
Radosław Piliszek
Rocky
Fix Released
Medium
Unassigned
Stein
Fix Released
Medium
Unassigned
Train
Fix Released
Medium
Radosław Piliszek
Ussuri
Fix Released
Medium
Radosław Piliszek

Bug Description

**Bug Report**

When using Kolla Ansible Mariadb Galera, Mariadb will be installed in each controller. The Mysqld Exporter in each controller should be point to Mariadb in itself, instead pointing to VIP. With these scenario, we can gather metric from each Mariadb independently.

Revision history for this message
Radosław Piliszek (yoctozepto) wrote :

You mean Prometheus exporter?

Changed in kolla-ansible:
status: New → Incomplete
Revision history for this message
Danni Setiawan (danninov) wrote :

Nope, it is part of Prometheus, but what I mean is Mysqld Exporter. In Kolla Ansible it's called as prometheus-mysqld-exporter.

Here is the related files:

https://github.com/openstack/kolla-ansible/blob/master/ansible/roles/prometheus/templates/my.cnf.j2

Revision history for this message
Radosław Piliszek (yoctozepto) wrote :

Yeah, I meant whether you had meant Prometheus mysqld exporter.

Changed in kolla-ansible:
status: Incomplete → Triaged
importance: Undecided → Medium
assignee: nobody → Radosław Piliszek (yoctozepto)
milestone: none → 10.0.0
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to kolla-ansible (master)

Fix proposed to branch: master
Review: https://review.opendev.org/707582

Changed in kolla-ansible:
status: Triaged → In Progress
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to kolla-ansible (master)

Reviewed: https://review.opendev.org/707582
Committed: https://git.openstack.org/cgit/openstack/kolla-ansible/commit/?id=410fcc6363ca91e715472ab69c6a4383bdaefa77
Submitter: Zuul
Branch: master

commit 410fcc6363ca91e715472ab69c6a4383bdaefa77
Author: Radosław Piliszek <email address hidden>
Date: Thu Feb 13 09:28:43 2020 +0100

    Fix Prometheus mysqld exporter pointing to VIP address

    Change-Id: I4f553bd0888e200ddf744604c5029e67a95ee2cd
    Closes-bug: #1863041

Changed in kolla-ansible:
status: In Progress → Fix Released
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to kolla-ansible (stable/train)

Fix proposed to branch: stable/train
Review: https://review.opendev.org/710646

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to kolla-ansible (stable/train)

Reviewed: https://review.opendev.org/710646
Committed: https://git.openstack.org/cgit/openstack/kolla-ansible/commit/?id=aea4b7cc0b328d40847df8af3584e6224c4e5c66
Submitter: Zuul
Branch: stable/train

commit aea4b7cc0b328d40847df8af3584e6224c4e5c66
Author: Radosław Piliszek <email address hidden>
Date: Thu Feb 13 09:28:43 2020 +0100

    Fix Prometheus mysqld exporter pointing to VIP address

    Change-Id: I4f553bd0888e200ddf744604c5029e67a95ee2cd
    Closes-bug: #1863041
    (cherry picked from commit 410fcc6363ca91e715472ab69c6a4383bdaefa77)

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to kolla-ansible (stable/stein)

Fix proposed to branch: stable/stein
Review: https://review.opendev.org/711659

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to kolla-ansible (stable/rocky)

Fix proposed to branch: stable/rocky
Review: https://review.opendev.org/711661

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to kolla-ansible (stable/stein)

Reviewed: https://review.opendev.org/711659
Committed: https://git.openstack.org/cgit/openstack/kolla-ansible/commit/?id=ccbba57dfc59539f377c83c20372f78dfd39ec92
Submitter: Zuul
Branch: stable/stein

commit ccbba57dfc59539f377c83c20372f78dfd39ec92
Author: Radosław Piliszek <email address hidden>
Date: Thu Feb 13 09:28:43 2020 +0100

    Fix Prometheus mysqld exporter pointing to VIP address

    Change-Id: I4f553bd0888e200ddf744604c5029e67a95ee2cd
    Closes-bug: #1863041
    (cherry picked from commit 410fcc6363ca91e715472ab69c6a4383bdaefa77)
    (cherry picked from commit aea4b7cc0b328d40847df8af3584e6224c4e5c66)

tags: added: in-stable-stein
tags: added: in-stable-rocky
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to kolla-ansible (stable/rocky)

Reviewed: https://review.opendev.org/711661
Committed: https://git.openstack.org/cgit/openstack/kolla-ansible/commit/?id=dd52e155d819b8ce3f30758966e8de8e092d8873
Submitter: Zuul
Branch: stable/rocky

commit dd52e155d819b8ce3f30758966e8de8e092d8873
Author: Radosław Piliszek <email address hidden>
Date: Thu Feb 13 09:28:43 2020 +0100

    Fix Prometheus mysqld exporter pointing to VIP address

    Change-Id: I4f553bd0888e200ddf744604c5029e67a95ee2cd
    Closes-bug: #1863041
    (cherry picked from commit 410fcc6363ca91e715472ab69c6a4383bdaefa77)
    (cherry picked from commit aea4b7cc0b328d40847df8af3584e6224c4e5c66)

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix included in openstack/kolla-ansible 7.2.1

This issue was fixed in the openstack/kolla-ansible 7.2.1 release.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.