94 results found
-
Enable ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS to enhance replication
As a user of an existing database not using MySQL GTIDs, I want to enable the feature in MySQL 8.0.23+ to assign anonymous transactions to a local GTID [or specific UUID] so that I can continuously replicate part of my database to Aiven.
The objective is to create a live read-only replica or replicas containing region-specific databases, plus shared search data. Initial data can be replicated from a MySQL 8 replica of the non-GTID database, but re-enabling replication from the upstream origin breaks Aiven replication, as anonymous transactions exist.
1 vote -
Show all connections in the connections tab of the web console.
As database administrator or developer,
I want to see both the primary and read-only connections in the connections tab of the web console
so that I can observe all of the connections at the same time1 vote -
Admin user should access to snapshot statuses
As DEV
I want my admin user to have access to snapshot statuses over GET snapshot/status API (https://opensearch.org/docs/latest/api-reference/snapshots/get-snapshot-status/)
so that I'll be able to monitor and prevent my applications to fail because a snapshot blocks index management.1 vote -
Allow admin to get OpenSearch snapshot statuses
As DEV
I want my admin user to have access to snapshot statuses over GET snapshot/status API (https://opensearch.org/docs/latest/api-reference/snapshots/get-snapshot-status/)
so that I can prevent my applications to fail because a snapshot blocks index management.1 vote -
Configurable random_page_cost parameter in PostgreSQL Settings
As a customer,
I want to be able to configurerandom_page_costand optionallyseq_page_costin Postgres advanced configurations in order to influence the query planner.4 votes -
Set PostgreSQL Client Connection Port Within the Public Ports Range
As a database administrator or developer,
I would like to be able to set the database client connection port within the allowed public ports range,
So that I would be able to set the same port for all of my services which will allow me to have unified persistent rule on my firewall for my databases, facilitating smooth database operation within the firewall parameters. Altering firewall configurations can prove arduous.1 vote -
Kerberos Authentication Support for PostgreSQL
As a database administrator or developer,
I would like to integrate Kerberos authentication with PostgreSQL,
So that user management becomes centralized through existing Kerberos services like ActiveDirectory, enhancing security, simplifying authentication, and eliminating the need for separate authentication methods.1 vote -
Release pg_partman Version 5.0.0 as a PostgreSQL Extension
As a database administrator, developer or PO for Cloud Operations,
I would like the pg_partman extension to be updated to version 5.0.0,
so that I can keep my infrastructure compatible.7 votes -
Support PLV8 on versions of Postgres greater than 10
As Software Developer
I want to use PLV8 on Postgres 16
so that I can use Javascript as a procedural language on my PG 16 service.1 vote -
Display the service startup/shutdown time in the GET service endpoint
As a devops
I want to have the service startup time in the GET service endpoint
so that I can know I a service has been UP or STOPPED since more than 7 days for example. For now I have to fetch the activity logs of the project, then look up for the service, then look for the right event (if the status of the service is UP then I'm looking for the "servicepoweron" event else the "servicepoweroff") but sometimes the service is UP for more than 1 year so I can't find the startup date of the…5 votes -
Support slow query logging in Aiven for Cassandra
As an Aiven for Cassandra user,
I want to be able view queries that are running slow on my Aiven for Cassandra service.
The definition of slow will be set by default, but can be updated by the user (in the cassandra.yaml)1 vote -
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_byteswill 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 -
Standalone single SQL query optimization [PostgreSQL & MySQL]
A fast way to optimize my PostgreSQL & MySQL queries automatically.
As a software engineer, I would like to submit my query and receive a newly rewritten version of the query, optimized to run 10 times faster. These optimizations could potentially save my team an average of 50 weekly hours, which are currently spent manually optimizing these queries.
I would like to perform these optimizations directly from Aiven's console, even if my Database is not hosted on Aiven yet.Additionally, It is critical that the optimization process be 100% non-intrusive and not require access to my databases' sensitive data.
6 votes -
Proactive Performance Alerts, AI-based [PostgreSQL/MySQL]
A fast way to Identify PostgreSQL & MySQL performance issues.
As a DevOps/DBA, I would like to get proactive alerts so that my customers will not encounter performance issues and I will be able to identify and fix them quickly without calling a database specialist.
Additionally, It is critical that the AI-based Performance Alerts be 100% non-intrusive and not require access to my databases' sensitive data
0 votes -
DB optimization, using query rewrites suggestions [PostgreSQL/MySQL]
A fast way to optimize my PostgreSQL & MySQL databases automatically.
As a software engineer/DevOps, I would like to see my slowest queries and receive recommendations along with a newly rewritten version of the query, optimized to run 10 times faster. These optimizations could potentially save my team an average of 50 weekly hours, which are currently spent manually optimizing these queries.
I would like to perform these optimizations directly from Aiven's console.Additionally, It is critical that the optimization process be 100% non-intrusive and not require access to my databases' sensitive data.
0 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 -
Large Language Models (LLMs) hosted to build AI capabilities
As a developer with data stored in one of the operational databases,
I want to host and train Large Language Models, (LLMs) (open source) on Aiven
so that I can leverage the power of LLMs to improve the experience of my application.
In addition, I'd like to host a knowledge graph to act as a filter to reduce hallucinations and have built in RAG capabilities hosted on Aiven.1 vote -
innodb_buffer_pool_size
As a customer
I want to change the values ofinnodb_buffer_pool_size,innodb_buffer_pool_instances, andinnodb_buffer_pool_chunk_size
so that I can tune the DB config to better suit my workload
In addition, I understand that any changes should be within sensible limits, as taking too much memory away from the OS can cause OOM errors.3 votes -
Support pg_profile as a PostgreSQL Extension
As a database administrator or developer,
I would like to utilize the pg_profile extension in PostgreSQL,
so that I would be able to identify the most resource intensive activities in my databases.1 vote -
Support pg_stat_kcache as a PostgreSQL Extension
As a database administrator or developer,
I would like to utilize the pgstatkcache extension in PostgreSQL,
so that I would be able to gather statistics on system metrics such as CPU usage and physical disk access, and see how much resource each query, user and/or database is consuming.1 vote
- Don't see your idea?