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

94 results found

  1. 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

    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

    0 comments  ·  Aiven for MySQL  ·  Admin →
    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 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 time

    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)
  3. 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

    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)
  4. 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

    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)
  5. 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)
  6. 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

    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 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

    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 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

    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 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

    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)
  10. 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

    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. 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

    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 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.

    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)
  13. 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?

    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)
  14. 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…

    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)
  15. As a developer, I would like to enable the PGroonga extension for PostgreSQL so that I can harness the full-text search capability of PostgreSQL across all languages, including Japanese and Chinese, enhancing the versatility and inclusivity of my search functionality.

    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)
  16. 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.

    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)
    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.

  17. As [your role]
    I want to [describe what you need]
    so that I can [describe the benefit or a problem you want to solve]
    In addition, [share any additional context or why this idea is important to you]

    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)
  18. 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.

    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 database administrator or developer, I would like to have Tiered Storage for PostgreSQL and MySQL databases so that I can achieve cost-effectiveness for less frequently accessed data, ensure scalability, and efficiently manage data lifecycle.

    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)
  20. As a database operator, devOps engineer
    I want to be able to control the Redis major version that my Redis is running
    so that I can be more proactive when it comes to major version upgrade and prepare the necessary preparation for that

    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)
  • Don't see your idea?