74 results found
-
Improve default JOIN Engine for Aiven for ClickHouse
As a user of Aiven for ClickHouse,
I want to use the most optimized default settings possible. From the start I want to have the default JOIN set as the most performant possible and not the ClickHouse default one. This comes without me, the user, having to change any settings. However, I should be able to tweak those settings if needed in specific cases.
See https://clickhouse.com/docs/en/engines/table-engines/special/join2 votes -
Better error messages when using the built-in query editor in console for Aiven for ClickHouse
As a user,
I want to have a better idea why queries I run in the built-in query editor in the Aiven console do not work.
Clearer error messages are a way to let users know what went wrong and modify their queries accordingly.2 votes -
Iceberg Table Engine
As developer ina. company with a large amount of data stored in Iceberg,
I want to have the ClickHouse Iceberg Table engine,
so that I can effectively analyse the large amounts of data stored in iceberg, via Aiven for Clickhouse.2 votes -
Serverless experience
As developer,
I want to load data and run some queries against that data using ClickHouse,
so that I can start a new project, or learn the value of ClickHouse as a technology,
without having to worry about the size shape or cost of a hosted VM running that instance or cluster.
It would be good to have a running total of the cost per query.2 votes -
Cancel Queries for ClickHouse regardless of where I ran the query (including the query editor in the Aiven console)
As ClickHouse User
I want to be able to cancel distributed ClickHouse queries without contacting support
so that I can resolve accidental query executions by myself in a self service manner. This reduces RTT and allows for me to move faster.
I want to be able to do so regardless of the tool I use to run and cancel the query - this includes the query editor in the Aiven console2 votes -
MySQL Table engine
As someone drunning analytics queries with Clickhouse against multiple data sources,
I want to have the MySQL table engine enabled so that I can create tables in Clickhouse that span data in external MySQL instances,
so that I can bring the value of external data sources into my analysis.2 votes -
Opensearch Large Shard Warning
As an operator of Opensearch,
I want to be alerted when my shards are outside of recommend best practices of 10-50GB / shard,
so that I can avoid having overly large shard size cause performance problems for ingestion and query.In addition, please tell me how within the alert to split my shards if they do get too large.
1 voteThanks Jason. We can roadmap this. WIll update the idea when we have more concrete timeline
-
Enable all cross cluster replication APIs
As an OpenSearch operator
I want to be able to pause, stop, and start cross cluster replication
so that I can use this feature to support failover in a disaster recovery scenario.Typically in Elasticsearch or Opensearch, CCR can be used to support a DR deployment by placing two clusters (a leader and follower) in separate regions. When the leader cluster becomes unavailable, applications/clients can failover to the follower cluster by stopping replication on the following cluster which makes it a regular index.
https://opensearch.org/docs/latest/tuning-your-cluster/replication-plugin/api/
1 voteCurrently we are controlling this process of start/pause etc so we can control replication process during the entire cluster's lifecycle (through all the node recycling, upgrading etc.) to ensure the stability of our services.
I put this to Gather interest, I am also aware of the failover capability mentioned in the ideas as well (we have different ideas ticket for that), this is something we can have a look and see if we need to expose all APIs if the main usecase is failover
-
OpenSearch compute-optimized and storage-optimized clusters
As an architect
I want to create right-sized clusters for my use case
so that I can get the most value.Currently, all the OpenSearch clusters have a 1:4 CPU:RAM ratio. High throughput application search use cases often have small data sets and can benefit from more relative CPU than RAM or disk (e.g. 1:2 CPU:RAM ratio). Logging use cases with large volumes of data may benefit from storage optimized instances with 1:8 CPU:RAM ratio with more disk.
1 vote -
Support two-zone OpenSearch clusters
As an OpenSearch architect
I want to provision the minimum amount of hardware I need to meet my requirements
so that I can optimize costs.Currently, OpenSearch on Aiven only supports 3 AZ deployments for production-grade plans. OpenSearch clusters with data nodes deployed across 2 AZs can be considered production-grade as long as you have master nodes across 3 AZs.
1 vote -
Set BASE_URL for Opensearch dashboards
As Opensearch Administrator
I want to be able to set custom Base_URLs for my OpenSearch clusters
so that I can simplify usage for my customers when they have multiple OS services per group/client/customer.1 vote -
Connecting Clickhouse to a PostgreSQL read replica
At this moment there are only the primary Postgres instances available for a clickhouse connect. Wouldn't it make sense to have the capability connection Clickhouse to a read replica to prevent performance impacts on the primary?
1 vote -
The ability to Reduce logs in OpenSearch
As a security analyst,
I want to 'reduce' the logs searched to reduce the data to common patterns, allowing me to easily see meaningful events.
1 vote -
Add the ability to remove 'count' column in Table visualisations in OpenSearch
As a security analyst,
I want to remove the 'count' column in Table visualisation, so that the data irrelevant to what we need is not displayed.
1 voteI will raise an upstream ticket on this
-
Save comments in OpenSearch searches
As a security analyst,
I want to add comments into my searches within Discover, so that we have a shared history and understanding of what the intention of a search or part thereof is for.
1 vote -
Professional or Customer Support for OpenSearch Use
As a security analyst or operator,
I want to have support in using OpenSearch effectively for my use-case, so that I can have success in using this (complex, confusing, disparate) system as a SIEM without expending countless hours in trying to troubleshoot or effectively utilise the tool.
1 vote -
filter by backend cluster setting
As an application developer
I want to add an advanced configuration for cluster setting 'plugins.alerting.filterbybackend_roles'
so that I can prevent users from different tenants from seeing each other's monitorsCurrently unable to implement the following due to the current limitation: https://opensearch.org/docs/latest/observing-your-data/alerting/security/
1 voteThis is currently an advanced configuration for Security Plugin on OpenSearch upstream, we are evaluating this idea will comeback to this later on this quarter. This idea is valid and put it in Gathering Interest state now in a meantime
-
Option for ClickHouse Tiered Storage to use my OCI object storage
As a user of Aiven for ClickHouse,
I want to be able to choose between Aiven's object storage (the default) and my own Oracle - OCI object storage.1 vote -
Allow changing of OpenSearch configurable limits
As a customer
I want to change the configurable limits in OpenSearch
so that I can change things like https://opensearch.org/docs/latest/install-and-configure/configuring-opensearch/circuit-breaker/ when doing one-off large operations like deleting a bulk amount of data1 vote -
Better zookeeper insights in Aiven for ClickHouse
As a user of Aiven for ClickHouse,
I want to be able to know more about Zookeeper, its current state and what it is doing at any given time (in the console or in Grafana).1 vote
- Don't see your idea?