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 diskqueries 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.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
