Updates to Releem Agent
Apply and Rollback MySQL ConfigurationWe're super happy to announce that we've added a simple command that applies the recommended MySQL configuration. This feature has been in the works for a while now, and we are finally ready to release it to our customers.
This new command will significantly reduce the time it takes to apply recommended configurations.
Also, we've added a new command to roll back to previous configurations. It'll significantly reduce the rollback operation's time if the previous configuration works better.
To ensure this feature is robust, we built a test platform for Releem Agent using AWS, CloudFormation, and Ansible. It's been tested on Debian (10,11) and CentOS (7,8) to work with the following server versions:
- MariaDB (10.X)
- MySQL 5.7, 8.0
- Percona 5.7, 8.0
Please update Releem Agent on your servers, and follow the documentation to use the "apply" and "rollback" commands.
Updates to Releem Cloud PlatformWe aim to add more configuration variables each month to bring the best performance to your database servers, and this month, we’ve added innodb_page_cleaners and innodb_purge_threads. These new variables help make better configuration recommendations. Now Releem supports 35 MySQL variables.
New Supported Variables innodb_page_cleaners and innodb_purge_threadsThe innodb_page_cleaners variable sets the number of page cleaner threads.
The innodb_purge_threads variable is the number of background threads dedicated to InnoDB purge operations. This variable can be set to a value from 1 to 32. For example, if innodb_purge_threads is set to 12, there are 12 separate purge threads.