How to switch the undercloud backend for ceilometer and aodh from MySQL to mondogb or gnocchi in Red Hat OpenStack Platform 9 and 10
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.