{"id":146187,"date":"2025-10-23T17:12:00","date_gmt":"2025-10-23T15:12:00","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vypusk-subd-mysql-9-5-0"},"modified":"2025-10-23T17:12:00","modified_gmt":"2025-10-23T15:12:00","slug":"vypusk-subd-mysql-9-5-0","status":"publish","type":"post","link":"https:\/\/prohoster.info\/fr\/blog\/news\/vypusk-subd-mysql-9-5-0","title":{"rendered":"Sortie de la base de donn\u00e9es MySQL 9.5.0","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>La soci\u00e9t\u00e9 Oracle a cr\u00e9\u00e9 une nouvelle branche de la base de donn\u00e9es MySQL 9.5.0. Les builds de MySQL Community Server 9.5.0 sont pr\u00e9par\u00e9s pour toutes les principales distributions Linux, FreeBSD, macOS et Windows. Conform\u00e9ment au mod\u00e8le de versionnement mis en place en 2023, MySQL 9.5 est class\u00e9 dans les branches \u00ab Innovation \u00bb. Les branches Innovation sont recommand\u00e9es pour ceux qui souhaitent acc\u00e9der plus t\u00f4t \u00e0 de nouvelles fonctionnalit\u00e9s, elles sont publi\u00e9es tous les 3 mois et ne sont support\u00e9es que jusqu'\u00e0 la publication de la prochaine version majeure (par exemple, apr\u00e8s la sortie de la branche 9.5, le support de la branche 9.4 sera arr\u00eat\u00e9). Un LTS sera pr\u00e9vu cet hiver pour la version 9.6, recommand\u00e9 pour les d\u00e9ploiements n\u00e9cessitant pr\u00e9visibilit\u00e9 et un comportement inchang\u00e9 sur le long terme. Suivant la branche LTS, une nouvelle branche Innovation sera form\u00e9e \u2014 MySQL 10.0.      <\/p>\n<p>Principales modifications de MySQL 9.5 :  <\/p>\n<ul>\n<li class=\"l\"> Une option \u00ab activate_mandatory_roles \u00bb a \u00e9t\u00e9 ajout\u00e9e pour une gestion avanc\u00e9e des r\u00f4les \u2014 lorsque la configuration \u00ab activate_all_roles_on_login \u00bb est d\u00e9sactiv\u00e9e et que \u00ab activate_mandatory_roles \u00bb est activ\u00e9e, le support des r\u00f4les obligatoires (attribu\u00e9s automatiquement \u00e0 l'utilisateur lors de la connexion) est activ\u00e9 en plus des r\u00f4les standards.\n<li class=\"l\"> Le plugin MySQL Multilingual Engine dans l'impl\u00e9mentation du langage JavaScript prend en charge la sp\u00e9cification ECMAScript 2025.\n<li class=\"l\"> Ajout de l'utilitaire mysqldm (MySQL Diagnostic Monitor), destin\u00e9 \u00e0 la collecte d'informations de diagnostic (un ensemble pr\u00e9d\u00e9fini de requ\u00eates est analys\u00e9), qui peut \u00eatre transmis par l'utilisateur au service d'assistance pour faciliter l'analyse des probl\u00e8mes.\n<li class=\"l\"> Ajout de la possibilit\u00e9 d'installer simultan\u00e9ment des versions courantes et LTS de MySQL c\u00f4te \u00e0 c\u00f4te.\n<li class=\"l\"> Dans les param\u00e8tres de r\u00e9plication, la protection par d\u00e9faut utilise des options avanc\u00e9es, impliquant l'utilisation de chiffrement pour toutes les connexions lors de la r\u00e9plication.\n<li class=\"l\"> Dans le plugin MySQL Thread Pool, les param\u00e8tres sont automatiquement ajust\u00e9s pour atteindre des performances maximales en fonction de la configuration mat\u00e9rielle disponible.\n<li class=\"l\"> Le comportement de l'option \u00ab innodb_log_writer_threads \u00bb a \u00e9t\u00e9 modifi\u00e9, son activation par d\u00e9faut d\u00e9pend d\u00e9sormais du mode actif des journaux redo binaires (log_bin). Lorsque \u00ab log_bin \u00bb n'est pas actif, l'option \u00ab innodb_log_writer_threads \u00bb est activ\u00e9e pour les syst\u00e8mes avec plus de 4 CPU logiques, et lorsqu'elle est active \u2014 pour ceux avec plus de 31 CPU logiques.\n<li class=\"l\"> Par d\u00e9faut, la valeur du param\u00e8tre \u00ab binlog_transaction_dependency_history_size \u00bb a \u00e9t\u00e9 augment\u00e9e de 25 000 \u00e0 un million. La valeur maximale possible pour ce param\u00e8tre a \u00e9t\u00e9 augment\u00e9e de 1 \u00e0 10 millions.\n<li class=\"l\"> La valeur du param\u00e8tre \u00ab caching_sha2_password_digest_rounds \u00bb a \u00e9t\u00e9 augment\u00e9e \u00e0 10 000 par d\u00e9faut.\n<li class=\"l\"> L'utilisation de la m\u00e9thode d'authentification SCRAM-SHA-1 pour se connecter \u00e0 SASL LDAP est d\u00e9sormais obsol\u00e8te. Il est conseill\u00e9 d'utiliser la m\u00e9thode SCRAM-SHA-256, qui est maintenant d\u00e9finie par d\u00e9faut dans le param\u00e8tre \u00ab authentication_ldap_sasl_auth_method_name \u00bb.\n<li class=\"l\"> Le support des variables \u00ab group_replication_allow_local_lower_version_join \u00bb et \u00ab replica_parallel_type \u00bb, pr\u00e9c\u00e9demment d\u00e9clar\u00e9es obsol\u00e8tes, a \u00e9t\u00e9 arr\u00eat\u00e9.\n<li class=\"l\"> Sur la plateforme Solaris, le support de la compilation utilisant Clang et GCC a \u00e9t\u00e9 ajout\u00e9. La possibilit\u00e9 d'utiliser OpenSSL 3 sur Solaris a \u00e9galement \u00e9t\u00e9 introduite.\n<li class=\"l\"> La version minimale prise en charge de CMake a \u00e9t\u00e9 port\u00e9e \u00e0 3.17.5.\n<li class=\"l\"> Neuf vuln\u00e9rabilit\u00e9s ont \u00e9t\u00e9 corrig\u00e9es, dont la plus grave a re\u00e7u un niveau de dangerosit\u00e9 de 5,5 sur 10. Les d\u00e9tails ne sont pas communiqu\u00e9s, il est seulement indiqu\u00e9 que les vuln\u00e9rabilit\u00e9s se trouvent dans InnoDB, DML et l'optimiseur. Un acc\u00e8s authentifi\u00e9 \u00e0 la base de donn\u00e9es est requis pour exploiter ces vuln\u00e9rabilit\u00e9s.   <\/ul>\n<p>Source : <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=64100\">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 9.5.0. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 9.5.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 \u0441\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0432\u0438\u0438 \u0441 \u0432\u043d\u0435\u0434\u0440\u0451\u043d\u043d\u043e\u0439 \u0432 2023 \u0433\u043e\u0434\u0443 \u043c\u043e\u0434\u0435\u043b\u044c\u044e \u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u0440\u0435\u043b\u0438\u0437\u043e\u0432, MySQL 9.5 \u043e\u0442\u043d\u0435\u0441\u0451\u043d \u043a \u0432\u0435\u0442\u043a\u0430\u043c &#171;Innovation&#187;. Innovation-\u0432\u0435\u0442\u043a\u0438 \u0440\u0435\u043a\u043e\u043c\u0435\u043d\u0434\u043e\u0432\u0430\u043d\u044b \u0434\u043b\u044f \u0442\u0435\u0445, \u043a\u0442\u043e \u0445\u043e\u0447\u0435\u0442 \u0440\u0430\u043d\u044c\u0448\u0435 \u043f\u043e\u043b\u0443\u0447\u0430\u0442\u044c \u0434\u043e\u0441\u0442\u0443\u043f \u043a \u043d\u043e\u0432\u043e\u0439 \u0444\u0443\u043d\u043a\u0446\u0438\u043e\u043d\u0430\u043b\u044c\u043d\u043e\u0441\u0442\u0438, \u043f\u0443\u0431\u043b\u0438\u043a\u0443\u044e\u0442\u0441\u044f \u043a\u0430\u0436\u0434\u044b\u0435 3 \u043c\u0435\u0441\u044f\u0446\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-146187","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 9.5.0. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 9.5.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.\" \/>\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\/fr\/blog\/news\/vypusk-subd-mysql-9-5-0\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.2\" \/>\n\t\t<meta property=\"og:locale\" content=\"fr_FR\" \/>\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\u0412\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 MySQL 9.5.0 | 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 9.5.0. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 9.5.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.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/fr\/blog\/news\/vypusk-subd-mysql-9-5-0\" \/>\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=\"2025-10-23T15:12:00+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2025-10-23T15:12:00+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\udd47Sortie du SGBD MySQL 9.5.0 | ProHoster","description":"La soci\u00e9t\u00e9 Oracle a form\u00e9 une nouvelle branche du SGBD MySQL 9.5.0. Les versions de MySQL Community Server 9.5.0 ont \u00e9t\u00e9 pr\u00e9par\u00e9es pour toutes les principales distributions Linux, FreeBSD, macOS et Windows.","canonical_url":"https:\/\/prohoster.info\/fr\/blog\/news\/vypusk-subd-mysql-9-5-0","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"fr_FR","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\u0412\u044b\u043f\u0443\u0441\u043a \u0421\u0423\u0411\u0414 MySQL 9.5.0 | 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 9.5.0. \u0421\u0431\u043e\u0440\u043a\u0438 MySQL Community Server 9.5.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.","og:url":"https:\/\/prohoster.info\/fr\/blog\/news\/vypusk-subd-mysql-9-5-0","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":"2025-10-23T15:12:00+00:00","article:modified_time":"2025-10-23T15:12:00+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"146187","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-01-23 15:31:19","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2026-01-23 15:31:19","updated":"2026-01-23 15:31:19","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/posts\/146187","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/comments?post=146187"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/posts\/146187\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/media?parent=146187"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/categories?post=146187"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/tags?post=146187"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}