9 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

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

   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

3. innodb_buffer_pool_size

   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

   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. Access to MySQL Binary Logs

   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.

   3 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

5. Ability to Change the MySQL Optimizer Behavior

   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

   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  ·  1 comment  ·  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

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

   2 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

7. Enable creation of MariaDB databases as well as MySQL 8

   As an administrator of a wiki farm and news site using MariaDB 10.11, I want to be able to spin up instances of MariaDB LTS (10.11, soon 11.4) so that I can replicate my data set globally without compatibility issues.

   MariaDB is the standard for a MySQL-compatible syntax DB in Debian, Slackware and SUSE Enterprise Linux. The two have diverged in features and are no longer binlog-compatible - MySQL 8.0.34 also deprecated statement replication, making it increasingly difficult to go the other way.

   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

   0 comments  ·  Aiven for MySQL  ·  Edit…  ·  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

8. Show all connections in the connections tab of the web console.

   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

   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

   0 comments  ·  Aiven for MySQL  ·  Edit…  ·  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

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