How to implement OpenSearch stack monitoring similar to elastic stack monitoring

OpenSearch Dashboards
1

Hi Team,

I am looking for the procedure to implement open search stack monitoring, is there any way to implement like the stack monitoring available in kibana.

Regards
LG Reddy

2

Hey @Reddy

I assume you seen this?

3
  1. I started opensearch-performance-analyzer as per documentation and I am gettting only partial response for the query as shown below.
    (OpSh3)[root@worker ~]# curl -X GET http://192.168.56.110:9600/_plugins/_performanceanalyzer/rca?name=HighHeapUsageClusterRca
    {“HighHeapUsageClusterRca”:[{“rca_name”:“HighHeapUsageClusterRca”,“timestamp”:1701489113347,“state”:“healthy”}]}(OpSh3)[root@worker ~]#

2.I am getting error in logs related to sqlite
2023-12-02 04:54:46.167 [PA:Reader] [ipLWDOfkQmaRDejHSG4VSw-task-0-] ERROR org.opensearch.performanceanalyzer.rca.store.metric.AggregateMetric - RCA: Caught an exception while getting the DB SQL [select IndexName, ShardID, sum(max) from Shard_Size_In_Bytes where ShardID is not null group by IndexName, ShardID order by sum(max) desc]; [SQLITE_ERROR] SQL error or missing database (no such table: Shard_Size_In_Bytes)
2023-12-02 04:54:46.167 [PA:Reader] [ipLWDOfkQmaRDejHSG4VSw-task-0-] ERROR org.opensearch.performanceanalyzer.rca.store.metric.AggregateMetric - RCA: Caught an exception while getting the DB SQL [select sum(max) SUM_of_max from Shard_Size_In_Bytes]; [SQLITE_ERROR] SQL error or missing database (no such table: Shard_Size_In_Bytes)
2023-12-02 04:54:46.168 [PA:Reader] [ipLWDOfkQmaRDejHSG4VSw-task-1-] ERROR org.opensearch.performanceanalyzer.rca.store.metric.AggregateMetric - RCA: Caught an exception while getting the DB SQL [select avg(sum_max) shard_avg from (select IndexName, ShardID, sum(max) sum_max from Shard_Size_In_Bytes where ShardID is not null group by IndexName, ShardID order by sum_max desc) alias_97600446]; [SQLITE_ERROR] SQL error or missing database (no such table: Shard_Size_In_Bytes)