9 results found
-
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…6 votes -
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 -
innodb_buffer_pool_size
As a customer
I want to change the values ofinnodb_buffer_pool_size
,innodb_buffer_pool_instances
, andinnodb_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 -
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 -
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 -
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 -
Enable ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS to enhance replication
As a user of an existing database not using MySQL GTIDs, I want to enable the feature in MySQL 8.0.23+ to assign anonymous transactions to a local GTID [or specific UUID] so that I can continuously replicate part of my database to Aiven.
The objective is to create a live read-only replica or replicas containing region-specific databases, plus shared search data. Initial data can be replicated from a MySQL 8 replica of the non-GTID database, but re-enabling replication from the upstream origin breaks Aiven replication, as anonymous transactions exist.
1 vote -
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 time1 vote -
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
- Don't see your idea?