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

122 results found

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

  2. As a DBA
    I want to be able to click a button or call an API to initiate a primary -> secondary failover
    so that I can recover from an issue that Aiven isn't detecting, or so I can exercise my own availability tests.
    This should be available for all DB engines.

    Thank you

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

    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 a DBA or developer, I want to be warned if I am updating a parameter that will trigger a restart of my instance so that I can understand the consequences and avoid issues/mistakes.

    Example of parameters: sharedbufferspercentage, autovacuumfreezemax_age

    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)
  5. As Database Administrator or Engineer,
    I want to be able to edit the PgBouncer maxpreparedstatements configuration parameter, as it has a direct impact in the latency of the consumers of the database through the pool.

    Also, the default setting of 100 max prepared statements that Aiven has in the system is incorrect and will cause issues with ORM users when they upgrade the pgbouncer version in Aiven.

    https://github.com/prisma/prisma/issues/21531#issuecomment-1794539086

    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)
  6. As an devops engineers
    I want to store extensive amount of data on Redis but only need part of them to be on memory
    so that I can still utilize the low-latency nature of Redis but also be able to retain as much data as I can without pay the cost for unnecessary memory.
    In addition, i also want to be able to move data around different tiers

    12 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 [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)
  8. As a database administrator, platform engineer or developer
    I want to be able to enable the pgstatstatements.track_planning configuration parameter.

    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 enable 'active-active replication' in PostgreSQL so that I can ensure high availability for my database, minimize downtime during node failures, and efficiently distribute read and write workloads for effective load balancing.

    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)
  10. As a database administrator or developer, I would like to use PL/Rust as a trusted procedural language in PostgreSQL so that I can write natively-compiled functions in Rust for maximum performance, leverage Rust's extensive development ecosystem, and benefit from its compile-time safety guarantees, while seamlessly integrating with Postgres' Server Programming Interface and data types.

    0 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. As a database administrator or developer, I would like to have Trusted Language Extensions for PostgreSQL (pg_tle) so that I can seamlessly extend and manage PostgreSQL functionality without needing filesystem access, addressing the challenge of adding extensions in restricted environments and enhancing security by allowing unprivileged users to install and use trusted extensions.

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

    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 database administrator or developer, I would like multi-region standby capability for my PostgreSQL and MySQL databases so that I can ensure high-availability and business continuity by maintaining standbys across different regions, enabling automatic promotion in the event of a region-wide outage.

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

    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)
  15. 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)
  16. 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)
  17. As a user of Aiven for Cassandra,
    I want to be able to leverage my Aiven for Kafka service to synchronize records from my Aiven for Kafka topics with table rows in my Aiven for Cassandra.

    I am also interested in the reverse workflow: enabling Change Data Capture on my cluster to stream data out of my Aiven for Cassandra service to Aiven for Kafka.

    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)
  18. As an Aiven for Cassandra user,
    I want to be able to have as much auditing informations about my services' and databases activities as possible. (example: what data changed, when, by who etc.)
    This information can be captured in a log file or table.

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

    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 user of Aiven for Cassandra,
    I need to be able to scale horizontally (up and down) my service as dynamically and simply as possible, in order to serve my business or my app's needs.

    I need to be able to flexibly add and remove nodes from my Aiven for Cassandra service in as little clicks as possible in the Aiven console (or in as few API calls as possible).

    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?