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, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content