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

60 results found

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

    44 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 Database administrator, with a large footprint of applications being served,
    I want to have a read only replica cluster in another region, that is sized appropriately, with it's own read replica nodes provisioned,
    so that I can fail over and that read replica can quickly handle the production workload in the scenario of a disaster in one region/cloud vendor, to minimise any disruption to service.

    39 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 developer,
    I want to connect to my Aiven for Postgres services without providing credentials and use only certificate authentication as offered by Postgres https://www.postgresql.org/docs/current/auth-cert.html
    so that I can be compliant with my internal security policies

    16 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 database administrator or developer, I would like to receive holistic analysis of my database performance, including optimization recommendations. This will ensure that my customers do not encounter performance issues, and I will be able to quickly identify and fix them without having to call a database specialist.

    Additionally, it is critical that the AI Performance insights be 100% non-intrusive and do not require access to my databases' sensitive data.

    53 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 database administrator or developer, I would like to have audit logging capability in the system so that I can track and monitor user activities, maintain data security, and ensure compliance with regulatory requirements.

    37 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 developer or database administrator,
    I want to scale and distribute my PostgreSQL databases,
    so that I can handle large-scale data processing and analytics workloads efficiently.

    The Citus extension offers the benefits of scalability, improved performance, fault tolerance, high availability, efficient data distribution, and seamless integration with PostgreSQL, enables the users to effectively manage and process large-scale data workloads.

    50 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 developer looking for an open-source alternative to MongoDB,
    I want to use FerretDB to translate MongoDB wire protocol queries to SQL,
    so that I can stop using proprietary MongoDB instances.

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

    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 customer,
    I want to be able to configure random_page_cost and optionally seq_page_cost in Postgres advanced configurations in order to influence the query planner.

    4 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. As a data privacy officer, database administrator, data analyst/researcher, or compliance officer, I would like the ability to anonymize sensitive data in the database by masking or replacing personally identifiable information (PII) or commercially sensitive data so that I can protect individuals' privacy and ensure compliance with data protection regulations such as HIPAA and GDPR.

    15 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 site reliability engineer,
    I want to be able to create a highly available read-replica service,
    so that I can use it in the critical path of my application without availability being affected by loss of a single node.
    In addition, this can currently be achieved via at least two separate read-replica services (currently plans are limited to those with only one node) and appropriate client configuration, but Aiven should be able to do this for me instead.

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

    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 database administrator or developer,
    I would like to integrate LDAP authentication with PostgreSQL,
    So that user management becomes centralized through existing LDAP services like ActiveDirectory, enhancing security, simplifying authentication, and eliminating the need for separate authentication methods.

    15 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 perform in-place major upgrades on standby nodes and read-replicas for PostgreSQL so that the whole upgrade window is considerably shorter, resulting in increased high-availability for standbys and improved availability for read replicas. This feature will also alleviate any bottlenecks caused by the quorum sync replication, enhancing the overall database system's efficiency and resilience.

    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)
  15. As a database administrator or developer, I would like to integrate PostgreSQL with Oracle databases using the oracle_fdw extension so that I can seamlessly access data in Oracle databases from within PostgreSQL using standard SQL queries. This feature simplifies data integration and allows for efficient cross-database operations without the need for complex data migration processes.

    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 dba
    I want to add the PGOUTPUT extension
    so that we can use this type of logical replication
    In addition, it is important as our system integration requires it to work, and it is generally better performing over test_decoding

    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. Allowing WAL compression could be beneficial for several reasons: reduction of disk space usage, IO efficiency, faster replication, generally improving performance.

    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 Software Engineer or DBA, I want to be able to enforce schemas on JSON/JSONB fields in a convenient manner, so that I can ensure bad data doesn't getting written to my database. https://github.com/supabase/pg_jsonschema seems to be the most popular extension for doing this.

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

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

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