Skip to content

Operational Databases

Join our forum to discuss your ideas with Aiven community or check out our public roadmap.

Operational Databases

Categories

JUMP TO ANOTHER FORUM

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback

141 results found

  1. As a database administrator for a large enterprise,
    I want to be able to leverage an Aiven platform API,
    so that I can extract and archive, logical backups of my instances in order to meet and pass industry audit and compliance checks for data retention.
    These periods of retention could vary but be as long as 3 years. I would not expect to be able to restore these logical backups in the Aiven platform, and would be manage this myself should I need to.

    17 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  2. As a customer
    I want to change the values of innodb_buffer_pool_size, innodb_buffer_pool_instances, and innodb_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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  3. As a database administrator or developer,
    I would like to perform a cascade power off operation on a database service with read replicas when a power off operation is initiated,
    so that the service hierarchy is navigated, starting with powering off the replicas and ending with the master, all in a single uninterrupted transaction.
    This feature aims to prevent customers from having to set up automatic schedulers on their environments, reducing resource waste and ensuring a seamless and efficient power off process for the database service.

    13 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  4. As and Aiven for Valkey user with a large workload and infrastructure,
    I want to have a managed in memory database service, that scales taking the advantage of Valkey's new (version 8) cluster mode
    so that I can migrate my larger workloads to an Aiven managed service.

    13 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  5. 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/pgbouncer

    10 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  6. As a Valkey developer,
    I want to be able to run certain search queries (full text search for example) in my Valkey clusters
    In order to extract information from Valkey as quick as possible and use Valkey for various use cases

    9 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  7. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  8. 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.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  9. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  10. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  11. 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.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  12. As a database administrator or developer, I would like to query and analyze large volumes of data efficiently in PostgreSQL as a column-oriented database so that I can achieve fast and parallelized analytics without extensive code changes, reducing processing time from weeks to minutes.

    8 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  13. As a mysql administrator, I would like to be able to enable the slow query log on a read-only replica.

    Current state.
    The slow query log can have one of two output destinations. Log file, and the mysql.slowlog table on the server itself. Docs for reference
    https://dev.mysql.com/doc/refman/8.0/en/log-destinations.html
    Log Output:
    This currently cannot be configured for Aiven managed Mysql services. This is because customers do not have access to the underlying filesystem for service nodes.
    Table Output:
    This is the output destination used by Aiven hosted Mysql services, for the same reasoning above.
    This means that when an Aiven managed

    9 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  14. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Gathering Interest  ·  0 comments  ·  Other  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  15. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Gathering Interest  ·  0 comments  ·  Other  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  16. As a Valkey developer/admin,
    I want to schedule my back up to happen at a specific time
    In order to plan ahead and create a fork that has a latest data

    6 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  17. As a database administrator or developer, I would like to utilize the Orafce extension in PostgreSQL so that I can easily incorporate familiar database functions and packages from other systems, simplifying the migration process and ensuring compatibility with existing applications and data structures.

    5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  18. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  19. As a Cassandra user,
    I would like to reduce operational overhead (ex. Java) and reduce cost of my Cassandra (self-managed or on Aiven) service without code changes and while benefiting from all the advantages of Cassandra.

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  20. As a Database Reliability Engineer, I would like to be able to use commands such as ACL or Monitor when investigating some operational and performance issues and be able to check the documentation to find out which commands are available.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    Shelved  ·  Jonah Kowall responded

    These commands are blocked so that Aiven can control the service and keep it secure and available. We provide a subset of these commands to control ACLs. We also do not expose the monitor command since it will block the server completely due to the performance overhead. This is something we are improving in our documentation (which commands are specifically blocked). Look for a new documentation page to be published this month with additional details.

  • Don't see your idea?