Skip to main content

What’s New

Qrvey 8.7
Version 8.7 of the Qrvey platform is now available to customers! This version includes new features including area charts, the ability to pivot and export data, as well as numerous bug fixes and performance improvements.
Learn More
Qrvey 8.6
Version 8.6 of the Qrvey platform is now available to customers. This version includes several new feature enhancements and performance improvements.
Learn More
Required Update for 8.5.1
Attention 8.5.1 customers: for any 8.5.1 instance deployed prior to 08/05/2024, an update is required to ensure you are running the latest images.
Learn More
Qrvey 8.5
Version 8.5 (LTS) of the Qrvey platform is now available to customers. This version includes several new features and performance improvements.
Learn More
End-of-life Schedule
We've added a new article that lists the features and endpoints that have been scheduled for deprecation. All features and endpoints will be supported for (1) year after the release date of the LTS version that contains the alternative.
Learn More
Version: 8.7

Managing AWS Elasticsearch Cluster

The Qrvey platform uses AWS Elasticsearch service to store all Analytics data and runs queries on this cluster to show Charts and Metrics in UI. This document explains how to monitor and Resize an AWS Elasticsearch cluster based on your needs and requirements.

Architecture​

Inside the Qrvey platform, data is stored in Elasticsearch as documents in an index. Each index is equivalent to a Table or data set. There are 2 sets of indexes that store data:

  1. A global single index by the name of ‘_qrveyanswers’ or ‘_datapowerhouse’ is used to save all answers from Web Forms (Survey/Quiz/Forms and CSV files).
  2. One index per data set created in the Analytics UI for Relational databases like MySQL/SQL Server/Oracle etc or by using DataRouter (Elasticsearch Live).

By default, each index consists of 1 shard with 1 replica with data type mappings defined for each column.

AWS has recommendations about sizing an Elasticsearch cluster here. We recommend having at least 2-3 nodes per cluster with enough storage based on your usage. Please keep in mind that data is stored as JSON documents and is replicated as per the configuration (1 replica by default). Qrvey currently uses Elasticsearch v7.10 with default values.

For a dev/staging environment (light use case) we recommend a 2 node cluster with ‘t2.medium’ server types and this configuration is good enough to handle 100 indexes with a total of 5-10M rows of standard data size.

For production environments, we recommend having the cluster with at least 2-3 nodes of m4 or r6g server type. Also, it is recommended to have Master instances in at least 2 Availability zones.

To save on cost, Elasticsearch instances can be reserved by paying in advance for 1-3 years. We highly recommend using the reserved pricing once you know the type and number of instances you would need for the long term.

Monitoring​

There are 2 ways of monitoring your Elasticsearch cluster:

  1. You can use Qrvey’s Admin app under DataRouter > Health Dashboard. This dashboard shows you information about the number of records added and basic information about the Elasticsearch cluster index like space used, server type, and overall health of the cluster.

managing-aws-cluster

  1. AWS Elasticsearch service console: AWS console shows a lot of information about the cluster under Cluster Health and Instance health tabs. A few important metrics to monitor here are:
    • Cluster Status - This should be green
    • Total Nodes and Total Free space.
    • Maximum CPU and Memory utilization - This should be around or below 50-80%.
    • JVMPressure - This should stay below 80%.
    • Minimum free storage space - This is the minimum free storage space across all nodes, depending on the size it should have enough space (at least 20% free).

managing-aws-cluster

Resizing a Cluster​

Changing the cluster in AWS Elasticsearch service requires zero downtime as it uses blue/green deployment. AWS will make the changes by adding new servers to the domain, then it will transfer all the data to the new servers and remove the old servers once the new servers are ready. To make any changes to the Elasticsearch cluster:

  1. Log into the console for your AWS Account.
  2. Select AWS Elasticsearch service from the list of services.
  3. Select the Elasticsearch domain you would like to monitor or change.
  4. Click on the Configure Cluster button.
  5. From the Configure domain page you can change any settings by picking appropriate values.
    • Availability Zones
      • For a dev/staging environment (light use case) we recommend a 2 node cluster with ‘t2.medium’ server types. This configuration is good enough to handle 100 indexes with a total of 5-10M rows of standard data size.
      • For production environments, we recommend having the cluster with at least 2-3 nodes of m4 or r6g server type. Also, it is recommended to have Master instances in at least 2 Availability zones.
    • Instance Type - Pick the server type that would best fit your use case. We recommend t2.medium for dev/test workloads and m4 or i3 server type family for production or high workloads.
    • Number of Instances - We recommend at least 2 (preferably 3 or more) depending on your workload or use case.
    • Dedicated master instances - We recommend using master instances for high availability and heavy workloads in Production systems.
    • Storage Configuration - Pick a size per node based on your data. This size is per node, so if you have 3 servers at 10GB per node then the total storage for your cluster will be 30GB).
    • Encryption - If needed, based on use case.
    • Snapshot Configuration - AWS Elasticsearch service takes automatic snapshots of the domain once every day (now they do every hour as well as a new feature). Pick a time when the cluster is not going to have a lot of loading to be done. Something like midnight or early mornings.

managing-aws-cluster

Once you click on Submit, all changes are applied without any downtime and you can monitor the progress by looking at the Total Nodes chart in the Cluster Health tab.