89 results found

1. Support for JSON data type in Aiven for ClickHouse

   As a ClickHouse user,
   I want to use the new experimental (as of November 2024) JSON data type in Aiven for ClickHouse.
   Official docs reference:https://clickhouse.com/docs/en/sql-reference/data-types/newjson

   2 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   Gathering Interest  ·  0 comments  ·  Aiven for ClickHouse®  ·  Delete…  ·  Admin →
   How important is this to you?

   Nice to have You must login first! Should have You must login first! Must have You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

2. Opensearch backpressure mechanisms

   As an Opensearch administrator, I want to be able to limit the impact of heavy requests on my cluster.
   So that when some client applications make these requests, I can mitigate impacts for other client applications.

   An example would be to be able to use backpressure mechanism
   https://opensearch.org/docs/latest/tuning-your-cluster/availability-and-recovery/search-backpressure/

   13 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   Roadmapped  ·  0 comments  ·  Aiven for OpenSearch®  ·  Delete…  ·  Admin →
   How important is this to you?

   Nice to have You must login first! Should have You must login first! Must have You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

3. make shard_indexing_pressure configurable

   Dear Aiven Community,

   As a DevOps Engineer,
   I want to be able to configure the shardindexingpressure settings directly within the Aiven platform and through the Aiven Terraform provider,
   so that I can better manage indexing loads on Opensearch clusters, optimize performance during high data throughput, and prevent potential bottlenecks.

   In addition, this configuration capability is essential for dynamically adjusting indexing pressure based on real-time data demands. Currently, trying to enable or modify shardindexingpressure settings results in a 403 error, indicating that the feature is not supported in Aiven's current Opensearch offerings. Enabling this feature would allow users to set parameters like softlimit, minlimit, and maxoutstandingrequests to improve operational efficiency and resource utilization.

   This idea is important to me because it supports critical DevOps principles such as infrastructure as code and automation, which are essential for scalable, efficient deployment and management of large-scale search environments. By allowing users to configure these settings, Aiven can enhance its service offerings, making it a more attractive option for enterprises requiring robust, adaptable search infrastructure.

   The benefits of enabling shardindexingpressure in Aiven Opensearch include:

   Improved Performance Management: Users gain the ability to finely tune their cluster's response to varying indexing loads, enhancing overall system responsiveness and stability.
   Greater Flexibility and Control: Configurability via both the Aiven console and Terraform promotes a more tailored approach to resource management, which is especially beneficial in environments with fluctuating data loads.
   Enhanced Resource Efficiency: Proper management of shard indexing pressure prevents overutilization of shard resources, facilitating better distribution and utilization of resources across the cluster.
   I urge the community to support this feature request, as it will significantly enhance the utility and manageability of Aiven's Opensearch service for all users facing similar challenges.

   Thank you for considering this enhancement.

   Best regards,

   Dear Aiven Community,

   As a DevOps Engineer,
   I want to be able to configure the shardindexingpressure settings directly within the Aiven platform and through the Aiven Terraform provider,
   so that I can better manage indexing loads on Opensearch clusters, optimize performance during high data throughput, and prevent potential bottlenecks.

   In addition, this configuration capability is essential for dynamically adjusting indexing pressure based on real-time data demands. Currently, trying to enable or modify shardindexingpressure settings results in a 403 error, indicating that the feature is not supported in Aiven's current Opensearch offerings. Enabling this feature would allow users to set parameters… more

   • 

   8 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   Roadmapped  ·  0 comments  ·  Aiven for OpenSearch®  ·  Delete…  ·  Admin →
   How important is this to you?

   Nice to have You must login first! Should have You must login first! Must have You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

4. Integration: ClickHouse logs to Grafana Loki / Grafana Cloud

   As an Aiven for ClickHouse user,
   I want to be able to set up a log integration from my Aiven for ClickHouse to Grafana Cloud easily from the console or the CLI

   2 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   Gathering Interest  ·  0 comments  ·  Aiven for ClickHouse®  ·  Delete…  ·  Admin →
   How important is this to you?

   Nice to have You must login first! Should have You must login first! Must have You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

5. Enable index rollup settings

   There is a reported issue where incomplete results are returned when querying rollup indexes in OpenSearch. The issue was created upstream and found here:

   https://github.com/opensearch-project/index-management/issues/903#issuecomment-2146610171

   The solution suggested is to enable the plugin "plugins.rollup.search.searchalljobs" and local testing confirms that enabling this resolves the bug report, but access to the /_cluster/settings are currently not supported.

   3 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   Roadmapped  ·  1 comment  ·  Aiven for OpenSearch®  ·  Delete…  ·  Admin →
   How important is this to you?

   Nice to have You must login first! Should have You must login first! Must have You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

6. Aiven for ClickHouse on Oracle Cloud

   As an Aiven user and Aiven for ClickHouse user,
   I want to be able to use Aiven for ClickHouse on Oracle Cloud with all the Aiven capabilities available on the other cloud providers, seamlessly.

   4 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   Pending Review  ·  0 comments  ·  Aiven for ClickHouse®  ·  Delete…  ·  Admin →
   How important is this to you?

   Nice to have You must login first! Should have You must login first! Must have You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

7. Promote Follower Cluster to Leader Cluster for OpenSearch

   As a developer or devops engineers
   I want to auto-promote follower OpenSearch Cluster to leader OpenSearch Cluster after I set up OS CrossClusterReplication in case of outage
   so that I can make sure that there will not be any disruption
   In addition, auto-resume would be beneficial once the Leader Cluster is stable

   40 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   Roadmapped  ·  0 comments  ·  Aiven for OpenSearch®  ·  Delete…  ·  Admin →
   How important is this to you?

   Nice to have You must login first! Should have You must login first! Must have You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

8. Allow customer to stick with one minor OpenSearch version for an extended period

   As a DB admin
   I want to stick w a minor OS version until I have done all my testing with the new minor versions to make sure it does not break anything
   so that I can confidently upgrade my OS.

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   Pending Review  ·  0 comments  ·  Aiven for OpenSearch®  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Nice to have You must login first! Should have You must login first! Must have You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

9. Implement OpenSearch dedicated node role

   As an OpenSearch admin/developer,
   I want to assign certain dedicated role to each the node in my OpenSearch clusters
   In order to optimise the performance of my OS clusters

   26 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   Roadmapped  ·  2 comments  ·  Aiven for OpenSearch®  ·  Delete…  ·  Admin →
   How important is this to you?

   Nice to have You must login first! Should have You must login first! Must have You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

10. Support and/or adopt PGSync to help users maintain real-time sync between Postgres and Opensearch

    As an OpenSearch and Postgres user
    I want to easily keep these databases in sync
    so that I can provide low latency, high throughput full text search that doesn't impact my transactional database.

    Ever since search engines were invented, developers have struggled with keeping their system of records (typically relational databases like Oracle, Postgres, MySQL, etc) in sync with the search engine. Batch oriented processes are often not real-time enough resulting in poor user experiences where the search results don't return the same information as what's represented in the system of record. Event-oriented solutions such as writing updates from the app layer to Kafka which are then consumed by multiple databases can result in consistency issues and data stores becoming wildly out of sync, requiring a full re-index.

    PGSync could be a helpful tool to address this common challenge: https://pgsync.com/

    As an OpenSearch and Postgres user
    I want to easily keep these databases in sync
    so that I can provide low latency, high throughput full text search that doesn't impact my transactional database.

    Ever since search engines were invented, developers have struggled with keeping their system of records (typically relational databases like Oracle, Postgres, MySQL, etc) in sync with the search engine. Batch oriented processes are often not real-time enough resulting in poor user experiences where the search results don't return the same information as what's represented in the system of record. Event-oriented solutions such as writing updates from the… more

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    Pending Review  ·  0 comments  ·  Aiven for OpenSearch®  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Nice to have You must login first! Should have You must login first! Must have You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

11. DDS support for Aiven for Clickhouse

    As DevOps
    I want to see Dynamic disk sizing (DDS) as available option for Aiven for ClickHouse

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    Pending Review  ·  0 comments  ·  Aiven for ClickHouse®  ·  Delete…  ·  Admin →
    How important is this to you?

    Nice to have You must login first! Should have You must login first! Must have You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

12. Let users schedule Aiven for ClickHouse backups

    As an Aiven for ClickHouse users,
    I want to decide what time (hours and minute) the Aiven backup service will run and save a backup of my data in order to schedule my workloads accordingly (ex. data ingestion, power off)

    2 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    Gathering Interest  ·  1 comment  ·  Aiven for ClickHouse®  ·  Delete…  ·  Admin →
    How important is this to you?

    Nice to have You must login first! Should have You must login first! Must have You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

13. Support protobuf as format for ClickHouse <> Kafka integration

    As a user sending Kafka messages to Aiven for ClickHouse,
    I want to be able to send those messages using the protobuf format

    5 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    Gathering Interest  ·  0 comments  ·  Aiven for ClickHouse®  ·  Delete…  ·  Admin →
    How important is this to you?

    Nice to have You must login first! Should have You must login first! Must have You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

14. Opensearch Backup to another Region

    Provide a capability to backup opensearch to a secondary region in the even of hyperscaller regional outage allowing for customers to develop DR strategies meeting their RTO/RPO.

    2 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    Roadmapped  ·  0 comments  ·  Aiven for OpenSearch®  ·  Delete…  ·  Admin →
    How important is this to you?

    Nice to have You must login first! Should have You must login first! Must have You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

15. Make index snapshots possible for faster data restoration

    As a SRE or operations engineer
    I want to be able to create index snapshots manually or with a policy
    so that I can easily and quickly restore partial data after an unintentional index corruption.
    In addition, I understand this would require a shared storage between cluster nodes which means additional storage so it would make sense to make it a paid feature and/or include it in the tiered storage project.

    4 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    1 comment  ·  Aiven for OpenSearch®  ·  Delete…  ·  Admin →
    How important is this to you?

    Nice to have You must login first! Should have You must login first! Must have You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    Gathering Interest  ·  AdminHoang Minh Vo (Product Manager, Aiven.io) responded

    Thanks for posting the idea, the idea is reasonable. I will update the status once we know more about plan with this idea

16. Restore from external snapshot

    As a database administrator
    I want to restore from external snapshot that isnt hosted on Aiven
    so that I can migrate data from certain OpenSearch and Elasticsearch cluster (Aiven and Non-Aiven) to Aiven for OpenSearch

    3 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    Roadmapped  ·  0 comments  ·  Aiven for OpenSearch®  ·  Delete…  ·  Admin →
    How important is this to you?

    Nice to have You must login first! Should have You must login first! Must have You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

17. Tiered storage for OpenSearch

    As a developer or database administrator,
    I would like to utilise object storage in my Aiven for OpenSearch instance,
    so that I can store larger amounts of data at a lower cost than attached SSD or HDD.

    37 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    1 comment  ·  Aiven for OpenSearch®  ·  Delete…  ·  Admin →
    How important is this to you?

    Nice to have You must login first! Should have You must login first! Must have You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    Roadmapped  ·  AdminJohn Joseph Kennedy (Head of Databases, Aiven.io) responded

    This is being planned into the roadmap for later in the year. 

18. Providing a Idea on Real-time Resource Optimization Assistant!

    One helpful idea for improving user experience on cloud platforms like Aiven is to implement a "Real-time Resource Optimization Assistant": This feature would automatically analyze a user’s resource usage (e.g., CPU, memory, storage) and provide real--time recommendations on scaling resources up or down based on current needs: It could also suggest more cost-effective configurations or alternative services if it detects underutilized resources: For example,, if a database instance is consistently operating well below its capacity,, the assistant would recommend reducing resources to save on costs: Conversely, if there’s a spike in demand, it would suggest scaling up to prevent performance issues.

    This assistant would function as a background service, unobtrusive but accessible, offering recommendations through the dashboard and optional alerts via email or chat tools: By integrating machine learning,, it could continuously improve its predictions and suggestions based on historical usage patterns:

    This idea can help users better manage their cloud resources, minimize costs, and avoid downtime,, all while reducing the manual effort involved in monitoring and adjusting configurations: It empowers users to focus on their core tasks while ensuring their infrastructure runs optimally:

    With Regards,
    JamesDocker

    One helpful idea for improving user experience on cloud platforms like Aiven is to implement a "Real-time Resource Optimization Assistant": This feature would automatically analyze a user’s resource usage (e.g., CPU, memory, storage) and provide real--time recommendations on scaling resources up or down based on current needs: It could also suggest more cost-effective configurations or alternative services if it detects underutilized resources: For example,, if a database instance is consistently operating well below its capacity,, the assistant would recommend reducing resources to save on costs: Conversely, if there’s a spike in demand, it would suggest scaling up to prevent performance… more

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    Pending Review  ·  0 comments  ·  Aiven for ClickHouse®  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Nice to have You must login first! Should have You must login first! Must have You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

19. Pick a backup to restore from when forking and restoring my Aiven for ClickHouse service

    As an Aiven for ClickHouse user,
    I want to be able to choose the backup to fork and restore from, and not only use the last backup available.

    2 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    Gathering Interest  ·  0 comments  ·  Aiven for ClickHouse®  ·  Delete…  ·  Admin →
    How important is this to you?

    Nice to have You must login first! Should have You must login first! Must have You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

20. Support AzureBlobStorage engine for Clickhouse

    I need to read and write Parquet format files to/from Azure Blob Storage.

    3 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    Gathering Interest  ·  0 comments  ·  Aiven for ClickHouse®  ·  Delete…  ·  Admin →
    How important is this to you?

    Nice to have You must login first! Should have You must login first! Must have You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close