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

11 results found

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

    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)
  2. It would be great to be able to see the end time of when a backup is completed.
    This way you can know how long the backup took. As well as monitor and see when the lock error will no longer occur.

    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)
  3. As a database administrator or developer,
    I would like to be able to access and read binary logs of the database service by using third-party utilities,
    so that I would be able to perform the tasks security auditing, replication monitoring and possibly data recovery on the database.

    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)
  4. Currently, MySQL slow query logs are stored in the mysql.slow_log table. Adding an option to redirect those logs into service logs would allow log integrations, like OpenSearch, to pick those up and give customers greater value and flexibility.

    It would implicitly solve the following:
    https://ideas.aiven.io/forums/951280-operational-databases/suggestions/46266829-allow-mysql-slow-query-log-on-read-only-replicas

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

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

    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 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)
  11. As the founder, we are interested in enabling multiple users to MySQL Database directly via the Aiven CLI, preferably utilizing Octopus Deploy. They have a community step template which can facilitate the creation of users if they don't already exist. In order to set up a connection to Aiven CLI within our CI/CD, the Aiven CLI needs to be installed within the octopusdeploy/worker-tools. Configuration instructions for this can be found on Github, specifically at https://github.com/OctopusDeploy/WorkerTools/tree/master/ubuntu.22.04 and https://github.com/OctopusDeploy/WorkerTools/blob/master/windows.ltsc2019/Dockerfile. Further information is available on Docker Hub at https://hub.docker.com/r/octopusdeploy/worker-tools.

    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?