Does anyone know about the which Database or Management Database System suitable to store OpenStack Ceilometer monitoring information for future processing?
Can you describe the data set from the cellometer? Oracle and Sybase provide good database management systems (DBMS) but you may not want to pay for all the features of a DBMS. If you intend to use the data collected in an analysis program, you may want to write them directly to text files with appropriate delimiters, such as commas. Then your analysis program can input the text file and read the attributes directly. What kinds of queries and analyses do you plan to do with your data? These will help to determine whether it is worth the money to invest in a commercial DBMS.
Thank you so much for your help. Actually I'm planning to collect cloud monitoring data using different monitoring platform (Ceilometer form OpenStack, DCIM form Intel, and Nagios) and try to make a common database for future use. So I'm confuse to use Datameer, Tableau, ...etc.
We are a research team planing to use this data (collected form a real data centre) to study energy usage, temperature, storage, bandwidth, optimal virtual machine placement, ... etc. in the data centre.
Hi, we are currently following the approach to use a zabbix to collect monitoring information coming from ceilometer and other sources. Depending on the scale of your infrastructure this could be a good approach since zabbix already allows to collect infrastructure related metrics in an easy way (via agent based approach or SNMP and many others) using its own templates and it is easily extendable to get information from ceilometer as well.
Alternatively you could converge all the information from your sources into elasticsearch (directly or using logstash) and use kibana for the analysis.