How to switch the undercloud backend for ceilometer and aodh from MySQL to mondogb or gnocchi in Red Hat OpenStack Platform 9 and 10

Solution In Progress - Updated -

Issue

Load and response time for ceilometer with the MySQL backend are very high when polling with CloudForms.

This can have multiple consequences:

  • timeouts when CloudForms polls the undercloud's ceilometer and thus loss of data

  • very high loadon the undercloud, where the issue seems to be mysqld being overloaded by ceilometer Copying tmp do disk queries that keep piling up:

[root@undercloud ~]# mysqladmin processlist|grep disk
| 78  | ceilometer | 192.168.4.1:37358 | ceilometer | Query   | 1008 | Copying to tmp table on disk | SELECT sample.meter_id AS sample_meter_id, meter.name AS meter_name, meter.type AS meter_type, meter | 0.000    |
| 79  | ceilometer | 192.168.4.1:37372 | ceilometer | Query   | 1008 | Copying to tmp table on disk | SELECT sample.meter_id AS sample_meter_id, meter.name AS meter_name, meter.type AS meter_type, meter | 0.000    |
| 138 | ceilometer | 192.168.4.1:39326 | ceilometer | Query   | 946  | Copying to tmp table on disk | SELECT sample.meter_id AS sample_meter_id, meter.name AS meter_name, meter.type AS meter_type, meter | 0.000    |
| 139 | ceilometer | 192.168.4.1:39336 | ceilometer | Query   | 946  | Copying to tmp table on disk | SELECT sample.meter_id AS sample_meter_id, meter.name AS meter_name, meter.type AS meter_type, meter | 0.000    |
| 160 | ceilometer | 192.168.4.1:41170 | ceilometer | Query   | 885  | Copying to tmp table on disk | SELECT sample.meter_id AS sample_meter_id, meter.name AS meter_name, meter.type AS meter_type, meter | 0.000    |
| 161 | ceilometer | 192.168.4.1:41180 | ceilometer | Query   | 885  | Copying to tmp table on disk | SELECT sample.meter_id AS sample_meter_id, meter.name AS meter_name, meter.type AS meter_type, meter | 0.000    |
| 617 | ceilometer | 192.168.4.1:57200 | ceilometer | Query   | 306  | Copying to tmp table on disk | SELECT sample.meter_id AS sample_meter_id, meter.name AS meter_name, meter.type AS meter_type, meter | 0.000    |
| 618 | ceilometer | 192.168.4.1:57206 | ceilometer | Query   | 306  | Copying to tmp table on disk | SELECT sample.meter_id AS sample_meter_id, meter.name AS meter_name, meter.type AS meter_type, meter | 0.000    |
| 665 | ceilometer | 192.168.4.1:34374 | ceilometer | Query   | 108  | Copying to tmp table on disk | SELECT sample.meter_id AS sample_meter_id, meter.name AS meter_name, meter.type AS meter_type, meter | 0.000    |
| 710 | ceilometer | 192.168.4.1:38170 | ceilometer | Query   | 24   | Copying to tmp table on disk | SELECT sample.meter_id AS sample_meter_id, meter.name AS meter_name, meter.type AS meter_type, meter | 0.000    |

How can one switch to MongoDB to improve ceilometer performance on the undercloud?

Environment

Red Hat OpenStack Platform 9
Red Hat OpenStack Platform 10

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In