{"id":35467,"date":"2019-10-31T22:04:30","date_gmt":"2019-10-31T19:04:30","guid":{"rendered":"https:\/\/prohoster.info\/blog\/stabilnyj-vypusk-subd-mariadb-10-4\/"},"modified":"2019-10-31T22:04:30","modified_gmt":"2019-10-31T19:04:30","slug":"stabilnyj-vypusk-subd-mariadb-10-4","status":"publish","type":"post","link":"https:\/\/prohoster.info\/en\/blog\/news\/stabilnyj-vypusk-subd-mariadb-10-4","title":{"rendered":"Stable release of the MariaDB 10.4 database","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>After a year of development and six preliminary releases <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.org\/mariadb-10-4-6-first-stable-10-4-release-and-mariadb-connector-j-2-4-2-now-available\/\">prepared<\/a><\/noindex> the first stable release of the new branch of the DBMS <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/library\/mariadb-1046-release-notes\/\">MariaDB 10.4<\/a><\/noindex>, which is developed as a fork of MySQL, maintaining backward compatibility and   <noindex><a rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=39444#note\">differentiating itself<\/a><\/noindex> by integrating additional storage engines and extended capabilities. Support for this branch will be provided for 5 years, until June 2024. <\/p>\n<p>The development of MariaDB is overseen by the independent organization MariaDB Foundation in accordance with a completely open and transparent development process, independent of individual vendors. MariaDB is offered instead of MySQL in many Linux distributions (RHEL, SUSE, Fedora, openSUSE, Slackware, OpenMandriva, ROSA, Arch Linux, Debian) and is implemented in major projects such as <noindex><a rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=36759\">Wikipedia<\/a><\/noindex>, <noindex><a rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=37905\">Google Cloud SQL<\/a><\/noindex> and <noindex><a rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=36506\">Nimbuzz<\/a><\/noindex>.<\/p>\n<p>Key <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/library\/mdb-1046-rn\/\">improvements<\/a><\/noindex> <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/library\/changes-improvements-in-mariadb-104\/\">MariaDB 10.4<\/a><\/noindex>:<\/p>\n<ul>\n<li class=\"l\"> It includes the synchronous multi-master replication technology <noindex><a rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=40127\">Galera 4<\/a><\/noindex>, allowing for an active-active multi-master topology, permitting read and write operations from any node. With synchronous replication, all nodes always contain up-to-date data, ensuring no lost transactions since a transaction is confirmed only after data is propagated to all nodes. Replication is carried out in parallel mode, at the row level, transmitting only information about changes;\n<li class=\"l\"> In Unix-like systems, the authentication plugin <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/authentication-plugin-unix-socket\/\">unix_socket<\/a><\/noindex>, which allows the use of existing system accounts to connect to the DBMS via a local unix socket, is enabled by default;\n<li class=\"l\"> Added <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/library\/user-password-expiry\/\">of<\/a><\/noindex> the purpose of the user's password lifetime, after which the password is marked as expired. To set the password expiration in the 'CREATE USER' and 'ALTER USER' statements, the expression 'PASSWORD EXPIRE INTERVAL N DAY' has been added;\n<li class=\"l\"> Support added <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/library\/account-locking\/\">locks<\/a><\/noindex> users of the DBMS via the 'ACCOUNT LOCK' expression in the 'CREATE USER' and 'ALTER USER' statements;\n<li class=\"l\"> The execution of privilege checks has been significantly accelerated in configurations with a large number of users or access rules;\n<li class=\"l\"> <noindex><a rel=\"nofollow\" href=\"https:\/\/jira.mariadb.org\/browse\/MDEV-17658\">The use of<\/a><\/noindex> mysql.user and mysql.host tables has been discontinued. The mysql.global_priv table is now used to store accounts and global privileges;\n<li class=\"l\"> In <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/library\/authentication-plugins\/\">authentication<\/a><\/noindex> plugins <noindex><a rel=\"nofollow\" href=\"https:\/\/jira.mariadb.org\/browse\/MDEV-12321\">has added<\/a><\/noindex> support for the 'SET PASSWORD' expression;\n<li class=\"l\"> <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/library\/authentication-from-mariadb-104\/\">Added<\/a><\/noindex> the ability to use more than one authentication plugin for each account, which can be useful for gradually transitioning users to the <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/authentication-plugin-ed25519\/\">ed25519<\/a><\/noindex>. When creating the user root@localhost with the mysql_install_db script, two authentication plugins are now enabled by default \u2014 unix_socket and mysql_native_password;\n<li class=\"l\"> In the InnoDB storage engine, the operation for instant column deletion (ALTER TABLE \u2026 DROP COLUMN \u2026 ALGORITHM=INSTANT) and changing the order of columns has been implemented. The size of the initial redo log has been reduced. Support for key rotation for innodb_encrypt_log has been added. A checksum verification algorithm has been implemented.<br \/>\n innodb_checksum_algorithm=full_crc32. Instant expansion of VARCHAR types and text encoding changes for non-indexed columns have been provided.<\/p>\n<li class=\"l\"> The optimizer has been improved. The optimizer trace feature has been added and can be enabled via the system variable. <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/optimizer-trace\/\">optimizer-trace<\/a><\/noindex>. By default, statistics that are independent of storage engines are maintained. <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/engine-independent-table-statistics\/\">enabled<\/a><\/noindex> Two new modes for use_stat_tables \u2014 COMPLEMENTARY_FOR_QUERIES and PREFERABLY_FOR_QUERIES \u2014 have been introduced. The optimize_join_buffer_size mode is now enabled. New flags have been added.<br \/>\nTwo new use_stat_tables modes have been introduced \u2014 COMPLEMENTARY_FOR_QUERIES and PREFERABLY_FOR_QUERIES. The optimize_join_buffer_size mode has been enabled. New features have been added. <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/optimizer-switch\/\">Support for system-versioned tables has been expanded, which not only store the current snapshot of data but also retain information about all previously made changes.<\/a><\/noindex> operations<\/p>\n<li class=\"l\"> with time ranges; <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/library\/temporal-data-tables\/#application-time-periods\">A new command \"FLUSH SSL\" has been added to reload SSL certificates without restarting the server.<\/a><\/noindex> The operations \"INSTALL PLUGIN\", \"UNINSTALL PLUGIN\", and \"UNINSTALL SONAME\" now support the expressions \"IF NOT EXISTS\" and \"IF EXISTS\".\n<li class=\"l\"> A new 'FLUSH SSL' command has been added to reload SSL certificates without restarting the server;\n<li class=\"l\"> In the 'INSTALL PLUGIN', 'UNINSTALL PLUGIN', and 'UNINSTALL SONAME' operations, support for the 'IF NOT EXISTS' and 'IF EXISTS' clauses has been added;\n<li class=\"l\"> Transition to the use of C++11 standard has been implemented (atomic operations are utilized). <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/aria\/\">The performance of the locale properties for \"Collation\" has been significantly increased for Unicode, allowing for the specification of sorting rules and matching methods that consider the meaning of characters.<\/a><\/noindex>;\n<li class=\"l\"> a plugin for defining custom field types;\n<li class=\"l\"> Significantly increased performance for locale properties 'Collation' for Unicode, allowing the specification of sorting rules and comparison methods considering the meaning of characters;\n<li class=\"l\"> <noindex><a rel=\"nofollow\" href=\"https:\/\/jira.mariadb.org\/browse\/MDEV-4912\">Added<\/a><\/noindex> UDF functions (User-Defined Functions);\n<li class=\"l\"> In the \"FLUSH TABLES\" operation, the \"BACKUP LOCK\" mode can be used while backing up database files. <noindex><a rel=\"nofollow\" href=\"https:\/\/mariadb.com\/kb\/en\/user-defined-functions\/\">Support for server commands starting with the name mariadb, as alternatives to commands beginning with \"mysql\" (e.g., mariadump instead of mysqldump).<\/a><\/noindex> New article: Computational Photography\n<li class=\"l\"> In the 'FLUSH TABLES' operation <noindex><a rel=\"nofollow\" href=\"https:\/\/jira.mariadb.org\/browse\/MDEV-5336\">is implemented<\/a><\/noindex> the 'BACKUP LOCK' mode, which can be used during database file backups;\n<li class=\"l\"> <noindex><a rel=\"nofollow\" href=\"https:\/\/jira.mariadb.org\/browse\/MDEV-17591\">Added<\/a><\/noindex> support for server commands starting with the prefix mariadb, as alternatives to commands starting with 'mysql' (for example, mariadump instead of mysqldump).\n<\/ul>\n<p><noindex><a rel=\"nofollow\" name=\"link\"><\/a><\/noindex><\/p>\n<p>Source: <a \ncontent=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=50908\">opennet.ru<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041f\u043e\u0441\u043b\u0435 \u0433\u043e\u0434\u0430 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u0438 \u0448\u0435\u0441\u0442\u0438 \u043f\u0440\u0435\u0434\u0432\u0430\u0440\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0445 \u0432\u044b\u043f\u0443\u0441\u043a\u043e\u0432 \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043b\u0435\u043d \u043f\u0435\u0440\u0432\u044b\u0439 \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u044b\u0439 \u0440\u0435\u043b\u0438\u0437 \u043d\u043e\u0432\u043e\u0439 \u0432\u0435\u0442\u043a\u0438 \u0421\u0423\u0411\u0414 MariaDB 10.4, \u0432 \u0440\u0430\u043c\u043a\u0430\u0445 \u043a\u043e\u0442\u043e\u0440\u043e\u0439 \u0440\u0430\u0437\u0432\u0438\u0432\u0430\u0435\u0442\u0441\u044f \u043e\u0442\u0432\u0435\u0442\u0432\u043b\u0435\u043d\u0438\u0435 \u043e\u0442 MySQL, \u0441\u043e\u0445\u0440\u0430\u043d\u044f\u044e\u0449\u0435\u0435 \u043e\u0431\u0440\u0430\u0442\u043d\u0443\u044e \u0441\u043e\u0432\u043c\u0435\u0441\u0442\u0438\u043c\u043e\u0441\u0442\u044c \u0438 \u043e\u0442\u043b\u0438\u0447\u0430\u044e\u0449\u0435\u0435\u0441\u044f \u0438\u043d\u0442\u0435\u0433\u0440\u0430\u0446\u0438\u0435\u0439 \u0434\u043e\u043f\u043e\u043b\u043d\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0445 \u0434\u0432\u0438\u0436\u043a\u043e\u0432 \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f \u0438 \u0440\u0430\u0441\u0448\u0438\u0440\u0435\u043d\u043d\u044b\u0445 \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u0435\u0439. \u041f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0430 \u043d\u043e\u0432\u043e\u0439 \u0432\u0435\u0442\u043a\u0438 \u0431\u0443\u0434\u0435\u0442 \u043e\u0441\u0443\u0449\u0435\u0441\u0442\u0432\u043b\u044f\u0442\u044c\u0441\u044f 5 \u043b\u0435\u0442, \u0434\u043e \u0438\u044e\u043d\u044f 2024 \u0433\u043e\u0434\u0430. \u0420\u0430\u0437\u0432\u0438\u0442\u0438\u0435 MariaDB \u043a\u0443\u0440\u0438\u0440\u0443\u0435\u0442 \u043d\u0435\u0437\u0430\u0432\u0438\u0441\u0438\u043c\u0430\u044f \u043e\u0440\u0433\u0430\u043d\u0438\u0437\u0430\u0446\u0438\u044f MariaDB Foundation \u0432 \u0441\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0432\u0438\u0438 [&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-35467","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.1.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u041f\u043e\u0441\u043b\u0435 \u0433\u043e\u0434\u0430 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u0438 \u0448\u0435\u0441\u0442\u0438 \u043f\u0440\u0435\u0434\u0432\u0430\u0440\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0445 \u0432\u044b\u043f\u0443\u0441\u043a\u043e\u0432\" \/>\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\/stabilnyj-vypusk-subd-mariadb-10-4\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.1.1\" \/>\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\u0421\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u044b\u0439 \u0432\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 MariaDB 10.4 | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041f\u043e\u0441\u043b\u0435 \u0433\u043e\u0434\u0430 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u0438 \u0448\u0435\u0441\u0442\u0438 \u043f\u0440\u0435\u0434\u0432\u0430\u0440\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0445 \u0432\u044b\u043f\u0443\u0441\u043a\u043e\u0432\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/en\/blog\/news\/stabilnyj-vypusk-subd-mariadb-10-4\" \/>\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=\"2019-10-31T19:04:30+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2019-10-31T19:04:30+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\udd47Stable release of the MariaDB DBMS 10.4 | ProHoster","description":"After a year of development and six preview releases","canonical_url":"https:\/\/prohoster.info\/en\/blog\/news\/stabilnyj-vypusk-subd-mariadb-10-4","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\u0421\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u044b\u0439 \u0432\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 MariaDB 10.4 | ProHoster","og:description":"\u041f\u043e\u0441\u043b\u0435 \u0433\u043e\u0434\u0430 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u0438 \u0448\u0435\u0441\u0442\u0438 \u043f\u0440\u0435\u0434\u0432\u0430\u0440\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0445 \u0432\u044b\u043f\u0443\u0441\u043a\u043e\u0432","og:url":"https:\/\/prohoster.info\/en\/blog\/news\/stabilnyj-vypusk-subd-mariadb-10-4","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":"2019-10-31T19:04:30+00:00","article:modified_time":"2019-10-31T19:04:30+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"35467","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":null,"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-01-21 23:24:19","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-03-01 02:01:27","updated":"2026-01-21 23:24:19","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\/35467","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=35467"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/en\/wp-json\/wp\/v2\/posts\/35467\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/en\/wp-json\/wp\/v2\/media?parent=35467"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/en\/wp-json\/wp\/v2\/categories?post=35467"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/en\/wp-json\/wp\/v2\/tags?post=35467"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}