94 results found
-
Make PostgreSQL Upgrade Logs Available Post Upgrade Failure
As a database administrator or developer,
I would like to access the service upgrade logs after a failed and reverted upgrade,
so that I would be able to troubleshoot the problem myself before retrying, and without requiring the assistance of the support team.3 votes -
Improve default configurations for Aiven for Cassandra
As a user of Aiven for Cassandra,
I want to use the most optimized default settings possible. Apache Cassandra's defaults settings may be outdated as use case evolve and time passes.
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.3 votes -
pgbouncer logging
As a database administrator or developer, I would like to see PgBouncer logging.
At minimal I should be able to see connection pool creation/deletion/changes and all outbound clients connected to which pool with source IPs.
1. pgbouncer logs should be available by "avn service logs" and aiven console.
2. pgbouncer logs should be available with rsyslog integration to 3rd parties.
3. ideally logging level can be controlled by pg service config parameter pg.logerrorverbosity
bonus: pgbouncer stats ingested into logging.3 votes -
Support Bingo as a PostgreSQL Extension
As a developer or chemical database administrator,
I would like to perform chemical substructure searches and similarity searches on molecules and reactions efficiently,
so that I can quickly retrieve relevant chemical data and improve the accuracy and speed of chemical searches within the PostgreSQL database.3 votes -
Utilizing Row Level Security (RLS) and the BYPASSRLS Attribute
As a security administrator or developer, I would like to utilize Row-Level Security (RLS) in PostgreSQL so that I can control data access at a granular level based on specific conditions, ensuring that users only see and modify the data they are authorized to access. Additionally, I want the ability to assign the BYPASSRLS attribute to trusted roles or users when necessary, allowing them to have unrestricted access to data while still maintaining overall security.
3 votes -
Approximate Nearest Neighbour (ANN) Vector search via Storage-Attached Indexes
As a developer or data scientist looking to carry out advanced analytics,
I want to leverage ANN Vector search across the data in my Cassandra instance,
so that I can develop machine learning applications and capabilities.In addition, the following up stream CEP is of interest to me : https://cwiki.apache.org/confluence/display/CASSANDRA/CEP-30%3A+Approximate+Nearest+Neighbor%28ANN%29+Vector+Search+via+Storage-Attached+Indexes
3 votes -
Point in time recovery
As an organisation running an Aiven for Cassandra instance,
I want to have the ability to revert an instance back to a specific point in time,
so that I can recover to a known safe state, to mitigate the impact of any data issues and to meet my organisation's disaster recovery policy.3 votes -
Migration mechanism for external clusters
As a potential customer looking to migrate to Aiven for Cassandra from an existing external Cassandra cluster,
I want to have a mechanism to replicate from my external cluster to a new Aiven for Cassandra service,
so that I can migrate large amounts of data easily.3 votes -
Expose the metric filecount_size_bytes
As backend and DevOps engineer / SRM, I want to be able to visualize in Grafana metrics related to WAL files buildup due to lagging or missing replication slots.
This will help us debug WAL bloat which might exhaust the disk space and better understand the cause.Mainly the metric
filecount_size_bytes
will be useful. Also any metric that would allow us to monitor per database service:
1. Total WAL size.
2. Size of WAL retained due to replication lag.
3. Rate in which we consume the WAL for the replication over time (connector consumption rate).
4. Rate in which we…2 votes -
Recreation of replication slot after power cycle
As a DBA or developer,
I want to be able to stop/start my services without losing replication slots
so that I can resume my logical replication flows even after a power cycle.Similar recreation is currently done during nodes failover: https://aiven.io/blog/aiven-for-pg-recreates-logical-replication-slots
2 votes -
Ability to Change the MySQL Optimizer Behavior
As a database administrator or developer,
I would like to be able to change the behavior of the MySQL Optimizer at the global level by changing the variable of the optimizerswitch with values such as "indexmergeintersection=off" or "preferordering_index=off",
so that I would be able to optimize my query performance.2 votes -
Logs in JSON format
As an Operations Engineer
I want to have logs in JSON format
so that I can process them in third-party log management and analytics systems without having to write custom parsing rules.Related PostgreSQL documentation: https://www.postgresql.org/docs/15/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-JSONLOG
2 votes -
Ability to change join_buffer_size
As a MySQL user
I want to tune my service parameters according to best practises (in this case parameter joinbuffersize)
so that I can make my application performance better as I cannot use indexes
In addition, it might be useful to be able some other parameters mentioned here (https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_join_buffer_size)2 votes -
Expose pg_stat_statements.track_planning Configuration Parameter
As a database administrator, platform engineer or developer
I want to be able to enable the pgstatstatements.track_planning configuration parameter.2 votes -
Serverless PostgreSQL and MySQL Databases
As a database administrator or developer, I would like to have serverless PostgreSQL and MySQL databases so that I can effortlessly scale my databases based on workload, ensure high availability, simplify deployment and integration, reduce operational overhead, and optimize costs.
2 votes -
Replicate the usage of Oracle Autonomous Transaction
As developer or DBA
I want to be able to reproduce the behavior of Oracle Autonomous Transaction inside Postgres.
so that I can create a different transaction that is not impacting the current one. Use case can be logging for example),
In addition, this can be achieved using DBLinks but it requires to put the password inside a plSQL function. To avoid that, Aiven could have a new parameter allowing local connections without password.2 votes -
pgbouncer metrics prometheus endpoint support
As a DBA or SRE, I want to be able to monitor more pgbouncer metrics. Please add support of pgbouncer input plugin for telegraf to expose prometheus endpoint
https://github.com/influxdata/telegraf/tree/master/plugins/inputs/pgbouncer2 votes -
CEP-28: Reading and Writing Cassandra Data with Spark Bulk Analytics
As developer using Cassandra for analytics workloads,
I want to be able to create a custom Spark application,
so that I can read and write large amounts of data from Cassandra.
The Cassandra current APIs aren't designed for large scale data egress/ingest.2 votes -
Advanced Keyspace management
As someone running production workloads against Aiven for Cassandra,
I want to have more control over management of the keyspaces in my database,
so that I can adapt more quickly to changing workloads and meet internal criteria relating to levels of control for adopting an external service.2 votes -
Control of nodetool cleanup and compact
As a database administrator of an Aiven for Cassandra instance,
I want to be able to have some control over when and where compactions and cleanups occur on my instances,
so that I can keep my discs optimised and at a time that fits my workload.2 votes
- Don't see your idea?