CHANGELOG.md

Releem releases

Information about releases of the Releem.

Releem 1.17.0, 2024-06-30

• Improved Weekly Reports
• Added Alerts on CPU Utilization and Disk space. Closes #147
• Added applying configuration without restart to Releem Agent.
• Added SSL support to Releem Agent. Closes #310
• Added collection information from performance_schema.file_summary_by_instance
• Fixed Automatic installation doens't work in some cases. Closes #166
• Fixed buffer recommendations more that total RAM. Closes #262

Releem 1.16.0, 2024-05-31 (What's New At Releem | May 2024)

• Added Security Checks
• Added new event for partially applied configuration.
• Added support of AWS RDS Aurora. Closes #308
• Fixed Many events on MySQL restart. Closes #305

Releem 1.15.0, 2024-04-30

• Added new option to disable Query Cache manually. Feature request #289
• Added Max Query Length option allows Releem to save full queries for analysis. Closes #291
• Added Query Inspect popup displays the details of queries.
• Fixed IP address update in the dashboard if real IP address was changed. Closes #292
• Fixed Releem can't recognize that innodb_log_file_buffering is enabled. Closes #285
• Fixed Latency on the Servers page displays not in ms. Closes #303
• Fixed Incorrect aggregation on weekly and monthly charts.
• Fixed Using innodb_log_file_size instead of innodb_redo_log_capacity for Percona 8.x
• Removed transaction_prealloc_size for Percona 8.0.29 and later

Releem 1.14.0, 2024-03-31 (What's New At Releem | April 2024)

• Added SQL Query Analytics block to the Dashboard. Closes #256
• Added new task collection of performance_schema.events_statements_summary_by_digest to Releem Agent
• Added new metric to the Dashboard Aborted_clients
• Fixed incorrect permissions after installation. Closes #272
• Fixed File integrity issue after the agent update. Closes #277
• Fixed open_files_limit issue for AWS RDS. Closes #284
• Fixed recommendations of variables that couldn't be changed ffor AWS RDS Aurora. Closes #281
• Fixed Releem Agent fatal error when an agent couldn't get disk information. Closes #276
• Improved Wizard to add new servers

Releem 1.13.0, 2024-02-29 (What's New At Releem | February 2024)

• Added MySQL memory_limit and long_query_time to settings in the Releem dashboard
• Added sending logs to Platform when agent crashed
• Added detection that configuration was changed without MySQL restart (for AWS RDS customers). Closes #270
• Added collection information about the file system. Closes #189
• Added version of Releem Agent for i686. Closes #263
• Improved description of MySQL Health Checks
• Integrated RabbitMQ to remove dependence on AWS Lambda and process metrics asynchronously
• Changed time of metrics to Releem Platform time instead of time on customers servers Closes #264
• Removed transaction_prealloc_size from recommendations for MySQL 8.0.29 as deprecated. Closes #267

Releem 1.12.0, 2024-01-31 (What's New At Releem | January 2024)

• Improved Servers page to highligt servers with unapplied recommendations
• Added email reports for newly recommended MySQL configurations Closes #193
• Disabled apply button for old agents
• Published list of MySQL variables that Releem tuned on Free plan
• Migrated database metrics from MySQL to ClickHouse and improve performance of Dashboard by 25%
• Fixed bugs on RAM and IOPS charts

Releem 1.11.0, 2023-12-31 (What's New At Releem | December 2023)

• Added notification on increasing open_files_limit. Closes #171
• Added server restarts to MySQL Metrics graphs. Closes #191
• Added Automatic applying configuration by clicking button in the web interface.
• Added automatic rollback function if any issues arise while applying a new configuration. Closes #187
• Added new Health check - Table Definition Cache
• Fixed unable to bring recommendations for servers with disabled InnoDB. Closes #213
• Fixed InnoDB log file size Health Check calculation. Closes #234
• Fixed Releem Agent installation guide for AWS RDS. Closes #223
• Fixed Releem Agent tends to stop by itself from time to time. Closes #210

Releem 1.9.0, 2023-10-31 (What's New At Releem | October 2023)

• Improved InnoDB Log File Size Health Check. Closes #202
• Improved Table Cache Hit Rate Health Check. Closes #201
• Added Open Files Utilization
• Added Table Locking Efficiency
• Added InnoDB Dirty Pages Ratio
• Added default start page for users with multiple servers. Closes #177
• Added new Help windows with Frequently Asked Questions.
• Fixed RDS Memory Usage. Closes #212
• Fixed query_cache_type. Closes #214
• Fixed query_cache_size. Closes #216
• Fixed the time of applying configuration events on the day graph. Closes #220
• Improved documentation.

Releem 1.8.0, 2023-09-30 (What's New At Releem | September 2023)

• Added OS version to the Releem Score block
• Fixed the issue with graphs for the America/Mexico_City timezone Closes #196.
• Added a detailed description for the [Memory Limit] (https://releem.com/docs/getstarted#rec586933587). Closes #205.
• Added unapplied recommendations to the server list. Closes #176.
• Fixed innodb_page_cleaners wasn't changed during applying configuration. Closes #197.

Releem 1.7.0, 2023-08-31 (What's New At Releem | August 2023)

• Added Automated Updates for Releem Agent installed in docker container. Closes #184
• Improved version for mobile and Firefox compatibility.
• Improved Query Cache suggestions. Closes #135
• Fixed 'innodb_max_dirty_pages_pct' bug on MySQL 5.5. Closes #183
• Fixed metrics collecttion issue for db servers with Sphinx engine. Closes #174 , Closes #175
• Fixed bug for users with unapproved email. Closes #179
• Fixed bug with saving errors in MySQL configuration when Releem Platform reply with errors.

Releem 1.6.0, 2023-07-31 (What's New At Releem | July 2023)

• Added IOPS graph to Releem Dashboard.
• Added System Information to System Metrics block. Closes #169
• Improved MySQL Metrics graph and included ‘Applying Configuration’ events on the timeline.
• Improved graphs and made Y-axis absolute and not relative. Closes #167
• Removed innodb_flush_log_at_trx_commit automatic recommendations. Closes #170
• Fixed minor issues with the 'innodb_buffer_pool_instance' and 'thread_cache' MySQL variables.
• Improved Releem Agent installation for older MySQL and MariaDB versions without Performance Schema.

Releem 1.5.0, 2023-06-30 (What's New At Releem | June 2023)

• Improved the Recommended configuration window to show users all variables that Releem tunes and details on variables.
• Improved MySQL metric charts with buttons and avg metrics remove Latency and SlowLog
• Improved design of Recommendation block re current applied configuration and enable Configure button.
• Fixed bug in Releem Agent to work with old databases. Closes #163
• Fixed bug in full data metrics collection prevented collecting minute metrics.
• Added collecting configuration performance metric (Latency) in the period when configuration applied
• Added support of MariaDB 11

Releem 1.4.0, 2023-05-31 (What's New At Releem | May 2023)

• Improved “Add server” page to simplify the installation depending on environment
• Added new states for Recommendation block to make clear current state of Releem.
• Fixed bug in Releem Agent to collect information on database size 1 time in 12 hours to prevent performance issues.
• Add change period of all metrics collection in docker. Closes #161
• Added new variables 'innodb_change_buffering', 'innodb_autoextend_increment', 'innodb_change_buffer_max_size', 'thread_stack', 'innodb_adaptive_flushing_lwm', 'transaction_prealloc_size', 'innodb_max_dirty_pages_pct'

Releem 1.3.0, 2023-04-30

• Improved Documentation
• Fixed bug agents for AWS periodical restarts. Closes #159
• Fixed bug in Releem Agents calculation of iops for cpanel with cagefs. Closes #149
• Added fast detection of applying MySQL configuration
• Added detection that MySQL server was restarted
• Added support for arm64 architecture

Releem 1.2.0, 2023-03-31 (What's New At Releem | March 2023)

• Added deletion servers in the Releem Customer Portal
• Improved charts performance in the Releem Customer Portal
• Added a start screen for users without servers in the Releem Customer Portal
• Improved the installation process of Releem Agent and show users if Agent installed not properly
• Added hostname for Releem Agent in docker containers
• Added Events

Releem 1.1.0, 2023-02-28 (What's New At Releem | February 2023)

• Added Display RDS instanses in the Releem Customer Portal
• Added MySQL Health Checks in the Releem Customer Portal
• Redesigned Recommendation block in the Releem Customer Portal
• Renamed and redesigned MySQL Performance Score block to Releem Score
• Added Releem Agent Uninstallation
• Fixed MySQL socket detection in mysql_host

Releem 1.0.0, 2023-01-31 (What’s New At Releem | January 2023)

• Added new insights (QPS and Latency) to Weekly Reports
• Added CPU, IOPS, Memory charts for all users in the Releem Customer Portal
• Added Collecting RDS metrics from Enhanced monitoring
• Added Period selector to see data on graphs for more than 1 day in the Releem Customer Portal
• Added Initialize server in docker.
• Added Automated deployment via Fargate in AWS account.
• Fixed connection to db using hostname.
• Fixed default value to timer.
• Fixed Output after successfull installation. Closes #142
• Fixed Set domain name in mysql_host automatically in case using RDS. Closes #138
• Fixed Agent crashed when set domain name instead of IP in mysql_host. Closes #137
• Fixed Failed installation when password contains "!". Closes #121

Releem 0.9.9, 2022-12-31

• Added system metrics collection CPU, RAM, Swap, IOPS
• Added Slow Log Graph in the Releem Customer Portal
• Added CPU, IOPS, and Memory gauges for all users in the Releem Customer Portal
• Added Docker integration container. Closes #108
• Added Connection to MySQL via socket. Closes #117
• Added All Servers page in the Releem Customer Portal
• Improved Best Practices and Recommendations Block in the Releem Customer Portal
• Improved Documentation
• Fixed Installation with custome ip address. Closes #118
• Fixed Releem Agent stopped after server reboot. Closes #122
• Fixed During installation /etc/mysql/my.cnf was broke. Closes #126

Releem 0.9.8, 2022-11-30

• Added slow log queriest collection
• Added Latency Graph in the Releem Customer Portal
• Added collecting metrics from Performance Scheme
• Improved Releem Agent installation process just in one command
• Fixed output color. Closes #109
• Fixed Exclude "MySQL client" information. Closes #45
• Fixed Can't open error on CloudLinux. Closes #101

Releem 0.9.7, 2022-10-31

• Added installation logs collection.
• Improved metrics collection using new Releem Agent implemented using Go.
• Improved installation. Removed cron to collect metrics.
• Redesigned front page of Releem Customer Portal.
• Fixed run installation with sudo user.

Releem 0.9.6, 2022-09-30

• Added Queries per Second metric collection
• Added graph QPS in Releem Customer Portal
• Redesigned Dashboard in Releem Customer Portal
• Added Weekly Reelem Reports
• Improved server metrics aggregation algorithm (hostnames instead IP adresses) Closes #100
• Fixed warning during execution. Closes #93

Releem 0.9.5, 2022-08-31

• Added Apply recommended MySQL configuration and rollback to previous configuration. Closes #63
• Added Automatic update.
• Added innodb_page_cleaners and innodb_purge_threads calculations.
• Improved performance of Releem Agent minimize workload an run on servers with hundreds databases. Closes #30. Closes #58

Releem 0.9.4, 2022-07-31

• Added FreeBSD support. Closes #95
• Added innodb_redo_log_capacity calculation
• Added query_cache_min_res_unit calculation
• Improved calculation thread_cache_size. Closes #91
• Fixed Error is:'int' object has no attribute 'strip'
• Fixed Error KeyError: 'Virtual Machine'

Releem 0.9.3, 2022-06-30

• Added thread_pool_size calculation.
• Improved performance of metrics page.
• Improved MySQL Performance Score.
• Fixed innodb_buffer_pool_size calculation.
• Fixed height of Recommended Configuration block.

Releem 0.9.2, 2022-05-31

• Added manual selection of innodb_flush_log_at_trx_commit in Releem Customer Portal for every server.
• Added innodb_log_buffer_size calculaction.
• Added optimizer_search_depth calculaction.
• Improved innodb_log_file_size variable. Closes #3
• Improved Documentation.
• Fixed Metrics Collection Issue.

Releem Agent 0.9.1, 2022-04-30

• Added display of Memory Limit in Releem Customer Portal
• Improved MySQL Performance Score
• Fixed duplicated servers in Releem Customer Portal
• Removed servers where Releem Agent is not active.

Releem MySQLConfigurer 0.9.0, 2022-03-30

• Added checks of the database server version
• Added configuration file releem.conf
• Added -u option to update Releem Agent
• Added list of variable changes. Closes #75
• Improved calculation of max_heap_table_size
• Improved calculation of tmp_table_size
• Fixed MySQLTuner version
• Fixed metrics collection

Releem MySQLConfigurer 0.8.0, 2022-01-12

• Added support of MariaDB 10.6. Closes #82
• Added Automated subscriptions and credit card payments
• Added hostnames to servers list. Closes #77
• Improved documentation

Releem MySQLConfigurer 0.7.0, 2021-11-16

• Added Display timezone on server page. Closes #72
• Added Documentation.
• Added Automated Installation of Releem Agent
• Fixed Cache values too high. Closes #73
• Fixed Error when no Innodb tables only MyISAM. Closes #76
• Fixed The values on the left and right are not in the same terminology. Closes #74
• Removed Removed MySQLTuner Recommendations

Releem MySQLConfigurer 0.6.0, 2021-06-17

• Added MySQL Performance Score metric.
• Added runtime information. Closes #62
• Added Display Recommended Configuration.
• Improved documentation Installation, Usage and Tests.
• Improved calcualtion of the 'myisam_sort_buffer_size' variable.
• Improved calculation of the 'read_rnd_buffer_size' variable.
• Improved calculation of the 'sort_buffer_size' variable.
• Removed usage of "mysqltuner.pl" domain.

Releem MySQLConfigurer 0.5.0, 2021-01-30

• Added simple one step installation process. Closes #23.
• Improved documentation.
• Improved and published tests description at releem.com. Closes #31.
• Fixed problem with timeout variables. Closes #29.
• Added calculation of the 'max_allowed_packet' variable.
• Added calculation of the 'read_rnd_buffer_size' variable.
• Improved calcualtion of the 'sort_buffer_size' variable.
• Improved calculation of the 'innodb_buffer_pool_size' variable.
• Improved calculation of the 'key_buffer_size' variable.
• Improved calculation of the 'innodb_buffer_pool_instances' variable. Closes #37.

Releem MySQLConfigurer 0.4.0, 2020-11-21

• Improved documentation
• Added option -m to set memory limit for MySQL in MBs. Closes #42.
• Fixed downloading MySQLTuner every launch. Closes #46.
• Added option -k - Releem API Key authorization.
• Created Releem Community groups on Slack and Telegram.

MySQL Configurer 0.3.2, 2020-08-24

• Added MySQL 8 support. Closes #39
• Fixed calculation of the 'key_buffer_size' variable for MySQL 8.0.
• Tested compatibility with MySQL 5.5, MySQL 5.6, MySQL 5.7, MySQL 8.0, MariaDB 10.1, MariaDB 10.2, MariaDB 10.3, MariaDB 10.4, MariaDB 10.5.
• Improved documentation with Security section.
• Improved documentation with information about setting open_files_limit.
• Improved documentation with installation perl-Data-Dumper module on Centos.

MySQL Configurer 0.3.1, 2020-07-08

• Added calculation of the 'table_open_cache' variable.
• Added calculation of the 'table_definition_cache' variable. Closes #18

MySQL Configurer 0.3.0, 2020-06-24

• Tested compatibility with MySQL 5.5, MySQL 5.6, MySQL 5.7, MariaDB 10.1, MariaDB 10.2, MariaDB 10.3.
• Added calculation of the 'key_buffer_size' variable for improve performance of the MyIsam storage engine.
• Added calculation of the 'innodb_buffer_pool_chunk_size' variable for MySQL 5.7.5 and later, MariaDB 10.2.2 and later.
• Added calculation of the 'max_connections' variable based on 'Max_used_connections' MySQL status variable.
• Improve calculation of the 'innodb_log_file_size' variable using 'innodb_log_files_in_group' variable.
• Improve documentation with install dependencies step for Debian/Ubuntu and Centos/Redhat.
• Fix documentation. Update example of the recommended configuration file. Closes #35
• Fix documentation. How to safely apply the configuration file. Closes #36

MySQL Configurer 0.2.2, 2020-04-25

• Improve documentation. Added supported MySQL versions. Closes #22
• Imrove stability. Response message for incompatible report. Closes #10

MySQL Configurer 0.2.1, 2020-04-11

• Fixed rename file z_aiops_mysql.conf -> z_aiops_mysql.cnf. Issue #14 was closed
• Added rounding of variables. Issue #17 was closed.
• Added calculation 'max_connections'. Issue #16 was closed.
• Added calculation 'thread_cache_size'. Issue #15 was closed.
• Improve documentation. Issue #13 was closed.

MySQL Configurer 0.1.2, 2020-01-15

• Fixed "internal server error" in logging subsystem returned when the mysqltuner report contains empty parameter name. Issue #9 was closed.

MySQL Configurer 0.1.1, 2020-01-11

• Added check MySQLTuner exit code for prevent invalid requests to API. Issue #5 was closed
• Added -s option for the curl command to hide unnecessary output. Issue #2 was closed
• Fixed documentation and added check for JSON module. Issue #6 was closed
• Added old values to configuration file. Issue #4 was closed
• Fixed calculations of the innodb_buffer_pool_instances. Issue #1 was closed
• Improve advanced output for errors

MySQL Configurer 0.1.0, 2019-12-25 First release