124 results found
-
Higher frequency backups for Cassandra
As an administrator
I want to have high frequency backups of my Cassandra data
so that I can restore with less data loss if there's a data corruption issue or outage2 votes -
Almost zero downtime major release upgrades with logical replication
Based on a similar mechanism with aivendbmigrate I would like to have major release upgrade mechanism based on logical replication.
Steps:
- create an empty target instance with new major release
- create a full logical replication setup (like aivendbmigrate does) 2.1. inform users about limitations (lobs, schema changes during that period etc.) 2.2. inform users about testing and rollback capabilities
- perform the usual migrate thing with transferring everything and switch to a CDC state until next steps are defined
- provide specific cutover scenarios 4.1. DNS switch if possible? 4.2. some pgbouncer magic to prevent forced reconnections of…
2 votes -
Monospace Font in Aiven Console for the Optimize Query Screen
As a database administrator or developer,
I want to easily copy and compare SQL statements which would be easier to do with a monospace type font. It is visually difficult to compare SQL with variable width font.
Please convert the optimize query page to use a monospace font for the queries.
2 votes -
PGBouncer: Multiple processes
As a DBA I want to activate "so_reuseport" option so that PGBouncer can use multiple CPUs.
In the context of a very high concurrent database using PGBouncer, the single process can reach 100% CPU usage. Having multiple PGBouncer processes in the same instance would distribute the load between several processes.2 votes -
Ability to Terminate a MySQL Query
As a database admin or a developer,
I would like to be able to terminate running queries in my database as admin,
so that I would be able to unlock any long-running queries as part of my operations.2 votes -
Issue RECONNECT command to pgbouncer
As a developer/DBA
I want to be able to issue the RECONNECT command to pgbouncer
so that I can ensure all connections reset and have access to up-to-date schema information during migrations.2 votes -
Support postgres extension ip4r
As developer,
I want to use the ip4r extension as the built-in IP address types in Postgres work okay for many applications, but are lacking when it comes to applications that heavily work with IPs, like ours. ip4r adds several IP types with expanded functionalities that enable us to perform far more efficient "IP in range" type lookups, as well as tracking IP ranges that don't fall neatly in CIDR boundaries, plus general performance improvements. Very useful for our malicious IP threat feed service, abuseipdb.com, as you can imagine.2 votes -
Caching: Add Password (ACL command)
With Redis, it is generally possible to add a new password for a user without immediately invaliding the old one.
This makes it much easier to manage password rotation without incurring downtime.
Aiven for Caching blocks access to the ACL commands, and the UI, API, CLI only allow for resetting the current password.
The admin interfaces for Caching should allow to
Add PasswordandRemove Password2 votes -
Ability to adjust the lower_case_table_names setting for MySQL
As a database administrator, I want the option to be able to set the lowercasetablenames MySQL parameter in the event of migration requiring the lowercasetablenames is different than 0
2 votes -
Support pgvectorscale as a PostgreSQL Extension
As a developer,
I want to be able to perform efficient vector similarity and embeddings techniques directly in PostgreSQL, so that I can enable efficient handling of high-dimensional vector data within the PostgreSQL database for tasks like similarity search and machine learning.Pgvectorscale is an open-source PostgreSQL extension that builds on pgvector, enabling greater performance and scalability.
https://www.timescale.com/blog/pgvector-is-now-as-fast-as-pinecone-at-75-less-cost/
https://github.com/timescale/pgvectorscale2 votes -
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 time2 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_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 -
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 -
Support pg_wait_sampling as a PostgreSQL Extension
As a database administrator or developer,
I would like to utilize the pgwaitsampling extension in PostgreSQL,
so that I would be able to gather sampling-based statistics on wait events for troubleshooting dependencies for queries that take longer than expected.2 votes -
Change the default SSL Mode
Make it possible to change the default SSL mode.
This way, by setting this value to "verify-full", we can make it so that anyone trying to connect to the database MUST have the CA certificate.Because currently, what's the point of the CA certificate if it is not mandatory?
2 votes -
PostgreSQL logging JSON format with OpenSearch integration
As DBA I want to have better logging using the PostgreSQL v15 logging feature to save the logs in JSON format so that I can integrate these logs in OpenSearch and provide better readability of these logs.
This will provide 2 things:
1 - Parse of the fields of the log entries -> give more capabilities searching the logs - easily filter some field like user/database/application name
2 - Multi line queries in one log entry -> right now, multi line queries saves each line in a different log entry, which is very hard to filter a full query since…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 -
Support h3-pg as a PostgreSQL Extension
As a database administrator or developer, I would like to have H3 Hexagonal Hierarchical Geospatial Indexing System in PostgreSQL via h3-pg extension so that I can efficiently index and analyze geospatial data, including creating heatmaps and performing various spatial analyses, enhancing location-based decision-making for applications and services.
2 votes
- Don't see your idea?