What would be a recommended setup for a HA ceilometer's database?

asked 2014-12-22 14:10:52 -0500

jpmethot gravatar image

We are currently creating a fairly big openstack setup and our goal is to have everything in high-availability. However, when it comes to Ceilometer and it's database, I have a few questions.

Here's a quick overview of the setup : we have two controller nodes and I would like each of these controller nodes to run a ceilometer instance. Then, I would like to have each of these ceilometer to have a replicated database.

I understand that Mongodb is recommended for ceilometer (or at least that's what is used in the installation instructions). However, sharding it for production requires what seems to be a fairly complex setup with 3 configuration servers and a certain number of replicated datasets. Obviously, that would take more than 2 controllers to meet the "production level" recommendations.

Has anybody experimented with such a setup for ceilometer? What would be your recommendations? Would you suggest going with a very small mongodb setup with the config instances split between the two nodes?

edit retag flag offensive close merge delete

2 answers

Sort by ยป oldest newest most voted
1

answered 2014-12-23 09:16:54 -0500

bishoy gravatar image

I guess you can use mysql and do replication as following, This is an example of my.cnf

[mysqld]
 server-id=1
 log-bin=mysql-bin sync_binlog=1
 innodb_flush_log_at_trx_commit=1
 binlog-do-db=cinder
 replicate-do-db=cinder  ....... do it
 for Celiometer ...etc
 relay-log=/var/lib/mysql/mysqld-relay-bin
 relay-log-index=/var/lib/mysql/mysqld-relay-bin.index
 master-info-file=/var/lib/mysql/master.info relay-log-info-file=/var/lib/mysql/relay-log.info
 slave-skip-errors=1062
 skip-slave-start
edit flag offensive delete link more

Comments

Sure, mysql would be an option. My only issue with this solution is that MongoDB is specifically recommended for Ceilometer because of efficient read/write processing. Apparently, it's also the only backend that has been tested in production for Ceilometer. Has anybody tried using Mysql for Ceilo?

jpmethot gravatar imagejpmethot ( 2014-12-23 09:50:26 -0500 )edit

yes, I used it but this was nearly more that a year ago when ceil was first released on Grizzly

bishoy gravatar imagebishoy ( 2014-12-23 10:46:36 -0500 )edit
0

answered 2014-12-23 18:20:39 -0500

Darkinvader gravatar image

I have just used it in the lab for POC with Icehouse. Ceilometer does not even work well with MySQL for small installation (up to 10 computes) due to its bug with ceilometer-expirer process that was crashing rabbitmq and entire server due to memory leak and process sacrifice.

Juno release has this bug fixed and is more efficient. I have not tested it with Juno. Let us know if you do. It worked with no problems with Mongo for such a small POC.

edit flag offensive delete link more

Comments

I'm currently using Juno + Ceilometer HA w/ Percona XtraDB Cluster. I have some alarms thought. Works fine so far with less than 10 compute servers.

MentheAlow gravatar imageMentheAlow ( 2015-04-03 15:57:10 -0500 )edit

Get to know Ask OpenStack

Resources for moderators

Question Tools

2 followers

Stats

Asked: 2014-12-22 14:10:52 -0500

Seen: 401 times

Last updated: Dec 23 '14