{"id":115474,"date":"2024-05-01T18:46:44","date_gmt":"2024-05-01T16:46:44","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/dostupna-subd-mysql-8-4-0-lts"},"modified":"2024-05-01T18:46:44","modified_gmt":"2024-05-01T16:46:44","slug":"dostupna-subd-mysql-8-4-0-lts","status":"publish","type":"post","link":"https:\/\/prohoster.info\/en\/blog\/news\/dostupna-subd-mysql-8-4-0-lts","title":{"rendered":"MySQL 8.4.0 LTS database is available.","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Oracle has created a new branch of the MySQL DBMS 8.4 and released a corrective update MySQL 8.0.37. Builds of MySQL Community Server 8.4.0 are prepared for all major Linux distributions, FreeBSD, macOS, and Windows. The 8.4.0 release is classified under long-term support (LTS) branches, which are released every two years and supported for 5 years (plus there is an option for an additional 3 years of extended support).         <\/p>\n<p>MySQL 8.4.0 is the fourth release under the new release model, which includes two types of MySQL branches \u2014 'Innovation' and 'LTS'. The Innovation branches, which include MySQL 8.1, 8.2, and 8.3, are recommended for those who want early access to new features. These branches are published every 3 months and are supported only until the next significant release is published (for example, after the 8.4 branch is released, support for the 8.3 branch ends). LTS branches are recommended for deployments that require predictability and long-term stable behavior. A new Innovation branch \u2014 MySQL 9.0 \u2014 will follow the LTS branch.        <\/p>\n<p>Main changes in MySQL 8.4:  <\/p>\n<ul>\n<li class=\"l\"> The optimizer now supports automatic histogram updates independent of the 'ANALYZE TABLE' operation for the parent table. Automatic updates are enabled by specifying the 'AUTO UPDATE' expression during the 'ANALYZE TABLE' operation and are disabled by specifying the 'MANUAL UPDATE' expression, which is the default.\n<li class=\"l\"> New options '--keyring-migration-from-component', '--keyring-migration-source', and '--keyring-migration-destination' have been added for migrating from the keyring component to the keyring plugin.\n<li class=\"l\"> A new privilege FLUSH_PRIVILEGES has been added, which, unlike the previously available RELOAD privilege, grants the user rights only to perform the 'FLUSH PRIVILEGES' operation.\n<li class=\"l\"> A new privilege OPTIMIZE_LOCAL_TABLE has been added, allowing the user to perform the 'OPTIMIZE LOCAL TABLE' and 'OPTIMIZE NO_WRITE_TO_BINLOG TABLE' operations.\n<li class=\"l\"> The default values for the system variables group_replication_consistency and group_replication_exit_state_action have been changed. The variable group_replication_consistency is now set to BEFORE_ON_PRIMARY_FAILOVER instead of EVENTUAL, and the variable group_replication_exit_state_action is set to OFFLINE_MODE instead of READ_ONLY.\n<li class=\"l\"> In the builds shipped with the embedded OpenSSL library, a new version of OpenSSL 3.0.13 is utilized.\n<li class=\"l\"> Direct upgrades from MySQL 5.7 to MySQL 8.4 have been discontinued. To migrate from MySQL 5.7, you must first upgrade to branch 8.0 before updating to version 8.4.\n<li class=\"l\"> The default values for the following InnoDB settings have been changed: innodb_adaptive_hash_index, innodb_buffer_pool_in_core_file, innodb_buffer_pool_instances, innodb_change_buffering, innodb_doublewrite_files, innodb_doublewrite_pages, innodb_flush_method, innodb_io_capacity, innodb_io_capacity_max, innodb_log_buffer_size, innodb_numa_interleave, innodb_page_cleaners, innodb_parallel_read_threads, innodb_purge_threads, innodb_read_io_threads, innodb_use_fdatasync, temptable_max_ram, temptable_max_mmap, and temptable_use_mmap.\n<li class=\"l\"> Support has been added for package builds for Fedora 40 and Ubuntu 24.04.\n<li class=\"l\"> The mysql_native_password server plugin, which enables authentication using passwords, has been disabled by default and deprecated. It is recommended to switch to the caching_sha2_password plugin, which uses SHA2 hashing instead of SHA1. To revert to mysql_native_password support, the option '--mysql-native-password=ON' or the setting 'mysql_native_password=ON' can be used.\n<li class=\"l\"> Support for insecure protocols and encryption algorithms has been discontinued. Only TLS v1.2 and TLS v1.3 remain, alongside algorithms that provide forward secrecy, ciphers and certificates with SHA2, and AES algorithms in GCM or AEAD mode.\n<li class=\"l\"> SQL expressions related to replication that were previously deprecated due to the use of politically incorrect terminology have been removed: START SLAVE (use START REPLICA); STOP SLAVE (use STOP REPLICA); SHOW SLAVE STATUS (use SHOW REPLICA STATUS); SHOW SLAVE HOSTS (SHOW REPLICAS); RESET SLAVE (RESET REPLICA); CHANGE MASTER TO (CHANGE REPLICATION SOURCE TO); RESET MASTER (RESET BINARY LOGS AND GTIDS); SHOW MASTER STATUS (SHOW BINARY LOG STATUS); PURGE MASTER LOGS (PURGE BINARY LOGS); SHOW MASTER LOGS (SHOW BINARY LOGS).\n<li class=\"l\"> Previously deprecated options used in the expressions 'CHANGE REPLICATION SOURCE TO' and 'START REPLICA' that employed the term 'master' have been removed. 'master' has been replaced with 'source': MASTER_AUTO_POSITION (use SOURCE_AUTO_POSITION), MASTER_HOST (use SOURCE_HOST), MASTER_BIND (use SOURCE_BIND), MASTER_USER (SOURCE_USER), MASTER_PASSWORD (SOURCE_PASSWORD), MASTER_PORT (SOURCE_PORT), MASTER_CONNECT_RETRY (SOURCE_CONNECT_RETRY), MASTER_RETRY_COUNT (SOURCE_RETRY_COUNT), MASTER_DELAY (SOURCE_DELAY), MASTER_SSL (SOURCE_SSL), MASTER_SSL_CA (SOURCE_SSL_CA), MASTER_SSL_CAPATH (SOURCE_SSL_CAPATH), MASTER_SSL_CIPHER (SOURCE_SSL_CIPHER), MASTER_SSL_CRL (SOURCE_SSL_CRL), MASTER_SSL_CRLPATH (SOURCE_SSL_CRLPATH), MASTER_SSL_KEY (SOURCE_SSL_KEY), MASTER_SSL_VERIFY_SERVER_CERT (SOURCE_SSL_VERIFY_SERVER_CERT), MASTER_TLS_VERSION (SOURCE_TLS_VERSION), MASTER_TLS_CIPHERSUITES (SOURCE_TLS_CIPHERSUITES), MASTER_SSL_CERT (SOURCE_SSL_CERT), MASTER_PUBLIC_KEY_PATH (SOURCE_PUBLIC_KEY_PATH), GET_MASTER_PUBLIC_KEY (GET_SOURCE_PUBLIC_KEY), MASTER_HEARTBEAT_PERIOD (SOURCE_HEARTBEAT_PERIOD), MASTER_COMPRESSION_ALGORITHMS (SOURCE_COMPRESSION_ALGORITHMS), MASTER_ZSTD_COMPRESSION_LEVEL (SOURCE_ZSTD_COMPRESSION_LEVEL), MASTER_LOG_FILE (SOURCE_LOG_FILE), MASTER_LOG_POS (SOURCE_LOG_POS).\n<li class=\"l\"> System variables that used the terms 'master' and 'slave' have been removed: Com_slave_start (use Com_replica_start); Com_slave_stop (Com_replica_stop); Com_show_slave_status (Com_show_replica_status); Com_show_slave_hosts (Com_show_replicas); Com_show_master_status (Com_show_binary_log_status); and Com_change_master (Com_change_replication_source).\n<li class=\"l\"> The system variable group_replication_allow_local_lower_version_join has been deprecated. Previously deprecated options '--no-dd-upgrade', '--old', '--new', '--language', '--<a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/en\/ssl-sertifikat\/\"   title=\"ssl\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"2285\">ssl<\/a>', '--admin-ssl' and the variables binlog_transaction_dependency_tracking, group_replication_recovery_complete_at, avoid_temporal_upgrade, show_old_temporals, and default_authentication_plugin have been removed.\n<li class=\"l\"> The unused table INFORMATION_SCHEMA.TABLESPACES has been removed.\n<li class=\"l\"> Support for using the value LOW_PRIORITY with the expression 'LOCK TABLES ... WRITE' has been discontinued.\n<li class=\"l\"> Support for the AUTO_INCREMENT modifier used with FLOAT and DOUBLE types has been discontinued.\n<li class=\"l\"> The utility mysql_ssl_rsa_setup has been removed when built with OpenSSL. <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/en\/server\/\"   title=\"server\" data-wpil-keyword-link=\"linked\">server<\/a> MySQL can automatically generate missing SSL and RSA files upon startup.\n<li class=\"l\"> The mysql_upgrade utility has been removed, which is not used with the MySQL 8.0.16 release.\n<li class=\"l\"> The utilities mysqlpump, lz4_decompress, and zlib_decompress have been removed, for which mysqldump or interactive shell dump commands should be used instead.\n<li class=\"l\"> The following plugins have been removed: authentication_fido, authentication_fido_client (use authentication_webauthn instead); keyring_file (use component_keyring_file instead); keyring_encrypted_file (use component_keyring_encrypted_file instead); keyring_oci (use component_keyring_oci instead).\n<li class=\"l\"> Support for the expression ENGINE along with various options for 'DROP TABLESPACE' and 'ALTER TABLESPACE' has been discontinued.\n<li class=\"l\"> The privilege 'SET_USER_ID' has been removed and can no longer be specified in GRANT statements.\n<li class=\"l\"> The following C API functions have been restored: mysql_kill(), mysql_list_fields(), mysql_list_processes(), mysql_refresh(), mysql_reload(), mysql_shutdown(), and mysql_ssl_set(), some of which have been redesigned using the mysql_real_query() function. These functions were removed in the MySQL 8.3 branch but have been reinstated for support in the LTS branch of MySQL 8.4.\n<li class=\"l\"> A total of 26 vulnerabilities have been addressed that could be exploited remotely. The most serious issue has a severity level of 6.5 and relates to a vulnerability in OpenSSL. Less critical vulnerabilities affect the optimizer, InnoDB, Thread Pooling, Group Replication Plugin, Audit Plugin, DML, and mysqldump.         <\/ul>\n<p>Source: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=61098\">opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041a\u043e\u043c\u043f\u0430\u043d\u0438\u044f Oracle \u0441\u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043b\u0430 \u043d\u043e\u0432\u0443\u044e \u0432\u0435\u0442\u043a\u0443 \u0421\u0423\u0411\u0414 MySQL 8.4 \u0438 \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043b\u0430 \u043a\u043e\u0440\u0440\u0435\u043a\u0442\u0438\u0440\u0443\u044e\u0449\u0435\u0435 \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0435 MySQL 8.0.37. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 8.4.0 \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043b\u0435\u043d\u044b \u0434\u043b\u044f \u0432\u0441\u0435\u0445 \u043e\u0441\u043d\u043e\u0432\u043d\u044b\u0445 \u0434\u0438\u0441\u0442\u0440\u0438\u0431\u0443\u0442\u0438\u0432\u043e\u0432 Linux, FreeBSD, macOS \u0438 Windows. \u0412\u044b\u043f\u0443\u0441\u043a 8.4.0 \u043e\u0442\u043d\u0435\u0441\u0451\u043d \u043a \u0432\u0435\u0442\u043a\u0430\u043c \u0441 \u0434\u043b\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u043c \u0441\u0440\u043e\u043a\u043e\u043c \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0438 (LTS), \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u0432\u044b\u043f\u0443\u0441\u043a\u0430\u044e\u0442\u0441\u044f \u0440\u0430\u0437 \u0432 \u0434\u0432\u0430 \u0433\u043e\u0434\u0430 \u0438 \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u044e\u0442\u0441\u044f 5 \u043b\u0435\u0442 (\u043f\u043b\u044e\u0441 \u043c\u043e\u0436\u043d\u043e \u043f\u043e\u043b\u0443\u0447\u0438\u0442\u044c \u0435\u0449\u0451 3 \u0433\u043e\u0434\u0430 [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-115474","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.2 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u041a\u043e\u043c\u043f\u0430\u043d\u0438\u044f Oracle \u0441\u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043b\u0430 \u043d\u043e\u0432\u0443\u044e \u0432\u0435\u0442\u043a\u0443 \u0421\u0423\u0411\u0414 MySQL 8.4 \u0438 \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043b\u0430 \u043a\u043e\u0440\u0440\u0435\u043a\u0442\u0438\u0440\u0443\u044e\u0449\u0435\u0435 \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0435 MySQL 8.0.37.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/en\/blog\/news\/dostupna-subd-mysql-8-4-0-lts\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.2\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47\u0414\u043e\u0441\u0442\u0443\u043f\u043d\u0430 \u0421\u0423\u0411\u0414 MySQL 8.4.0 LTS | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041a\u043e\u043c\u043f\u0430\u043d\u0438\u044f Oracle \u0441\u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043b\u0430 \u043d\u043e\u0432\u0443\u044e \u0432\u0435\u0442\u043a\u0443 \u0421\u0423\u0411\u0414 MySQL 8.4 \u0438 \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043b\u0430 \u043a\u043e\u0440\u0440\u0435\u043a\u0442\u0438\u0440\u0443\u044e\u0449\u0435\u0435 \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0435 MySQL 8.0.37.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/en\/blog\/news\/dostupna-subd-mysql-8-4-0-lts\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2024-05-01T16:46:44+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2024-05-01T16:46:44+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47MySQL 8.4.0 LTS is now available | ProHoster","description":"Oracle has formed a new database branch of MySQL 8.4 and released a patch update for MySQL 8.0.37.","canonical_url":"https:\/\/prohoster.info\/en\/blog\/news\/dostupna-subd-mysql-8-4-0-lts","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"en_US","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u0414\u043e\u0441\u0442\u0443\u043f\u043d\u0430 \u0421\u0423\u0411\u0414 MySQL 8.4.0 LTS | ProHoster","og:description":"\u041a\u043e\u043c\u043f\u0430\u043d\u0438\u044f Oracle \u0441\u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043b\u0430 \u043d\u043e\u0432\u0443\u044e \u0432\u0435\u0442\u043a\u0443 \u0421\u0423\u0411\u0414 MySQL 8.4 \u0438 \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043b\u0430 \u043a\u043e\u0440\u0440\u0435\u043a\u0442\u0438\u0440\u0443\u044e\u0449\u0435\u0435 \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0435 MySQL 8.0.37.","og:url":"https:\/\/prohoster.info\/en\/blog\/news\/dostupna-subd-mysql-8-4-0-lts","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2024-05-01T16:46:44+00:00","article:modified_time":"2024-05-01T16:46:44+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"115474","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":"2026-02-09 17:29:02","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2026-01-22 23:29:19","updated":"2026-02-09 17:29:02","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/en\/wp-json\/wp\/v2\/posts\/115474","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/en\/wp-json\/wp\/v2\/comments?post=115474"}],"version-history":[{"count":2,"href":"https:\/\/prohoster.info\/en\/wp-json\/wp\/v2\/posts\/115474\/revisions"}],"predecessor-version":[{"id":172904,"href":"https:\/\/prohoster.info\/en\/wp-json\/wp\/v2\/posts\/115474\/revisions\/172904"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/en\/wp-json\/wp\/v2\/media?parent=115474"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/en\/wp-json\/wp\/v2\/categories?post=115474"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/en\/wp-json\/wp\/v2\/tags?post=115474"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}