4 results found

1. Allow Mysql Slow Query log on read-only replicas

   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 Mysql service enables the slow query log through advanced config, the output destination will be the mysql.slowlog table.
   https://docs.aiven.io/docs/products/mysql/reference/advanced-params#slow-query-log
   This is a problem for read replicas, because the slow query log cannot be written to. The following error is produced in such cases on the read replica server.

   "[Server] Failed to write to mysql.slow_log: The MySQL server is running with the --read-only option so it cannot execute this statement (cannot open table for slow log)"

   Because of the above reasons, it is currently impossible for a customer to enable and use the slow query log on a read replica. Any slow query logging would have to be done on the main service.
   Read replicas have a fundamentally different type of workload compared to main nodes. so monitoring slow queries on the main service will might not be a valid approach, depending on use case and setup.

   For these reasons, a feature allowing the slow query log to be enabled on a read replica would be beneficial.

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

   5 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   Gathering Interest  ·  0 comments  ·  Aiven for MySQL  ·  Delete…  ·  Admin →
   How important is this to you?

   Nice to have You must login first! Should have You must login first! Must have You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

2. Ability to change join_buffer_size

   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)

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   Gathering Interest  ·  0 comments  ·  Aiven for MySQL  ·  Delete…  ·  Admin →
   How important is this to you?

   Nice to have You must login first! Should have You must login first! Must have You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

3. See the end time or current status of a backup taking place

   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.

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   Gathering Interest  ·  0 comments  ·  Aiven for MySQL  ·  Delete…  ·  Admin →
   How important is this to you?

   Nice to have You must login first! Should have You must login first! Must have You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

4. Aiven Cli Integration with octopusdeploy CD

   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

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   Gathering Interest  ·  0 comments  ·  Aiven for MySQL  ·  Delete…  ·  Admin →
   How important is this to you?

   Nice to have You must login first! Should have You must login first! Must have You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close