{"id":146812,"date":"2025-10-30T11:11:58","date_gmt":"2025-10-30T09:11:58","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vyshel-pgbalancer-1-0-balansirovshhik-nagruzki-postgresql-na-osnove-ii-podderzhivayushhij-rest-api-i-mqtt"},"modified":"2025-10-30T11:11:58","modified_gmt":"2025-10-30T09:11:58","slug":"vyshel-pgbalancer-1-0-balansirovshhik-nagruzki-postgresql-na-osnove-ii-podderzhivayushhij-rest-api-i-mqtt","status":"publish","type":"post","link":"https:\/\/prohoster.info\/fr\/blog\/news\/vyshel-pgbalancer-1-0-balansirovshhik-nagruzki-postgresql-na-osnove-ii-podderzhivayushhij-rest-api-i-mqtt","title":{"rendered":"pgbalancer 1.0 est sorti, un r\u00e9partiteur de charge PostgreSQL bas\u00e9 sur l'IA, prenant en charge REST API et MQTT.","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Le premier volume de pgbalancer, un r\u00e9partiteur de charge PostgreSQL bas\u00e9 sur l'intelligence artificielle avec REST API et MQTT, a \u00e9t\u00e9 publi\u00e9. Pgbalancer g\u00e8re le pool de connexions et la r\u00e9partition de charge pour PostgreSQL, est contr\u00f4l\u00e9 par HTTP et prend en charge la diffusion d'\u00e9v\u00e9nements en temps r\u00e9el. Le projet est cr\u00e9\u00e9 comme un fork de pgpool-II avec des am\u00e9liorations significatives pour le routage intelligent des requ\u00eates. Le code est \u00e9crit en C et distribu\u00e9 sous la licence ouverte PostgreSQL.      <\/p>\n<p>Fonctionnalit\u00e9s et caract\u00e9ristiques principales :  <\/p>\n<ul>\n<li class=\"l\"> Pool de connexions et r\u00e9partition de charge.\n<li class=\"l\"> Basculement automatique avec prise en charge du minuteur watchdog.\n<li class=\"l\"> Surveillance de l'\u00e9tat et mise en cache des requ\u00eates.\n<li class=\"l\"> Authentification SSL\/TLS, PAM\/LDAP.\n<li class=\"l\"> Compatibilit\u00e9 avec PostgreSQL 13-18.\n<li class=\"l\">  Fait partie des utilitaires pgElephant, garantissant une haute disponibilit\u00e9. Peut s'int\u00e9grer avec pgraft pour le consensus Raft, avec le monitoring de pgSentinel.\n<li class=\"l\"> R\u00e9partition de charge bas\u00e9e sur l'IA.\n<ul>\n<li class=\"l\"> Algorithmes d'apprentissage machine pour le routage intelligent des requ\u00eates.\n<li class=\"l\"> L'apprentissage s'adapte en fonction du temps de r\u00e9ponse des requ\u00eates et de l'\u00e9tat des ressources. <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/fr\/server\/dts-los-angeles\/\" title=\"de serveurs\" data-wpil-keyword-link=\"linked\" data-wpil-monitor-id=\"3988\">de serveurs<\/a>.\n<li class=\"l\"> L'\u00e9tat est \u00e9valu\u00e9 en temps r\u00e9el et la r\u00e9partition des requ\u00eates est pr\u00e9dite.\n<li class=\"l\"> Param\u00e8tres de poids configurables pour la vitesse d'apprentissage et la vitesse de pr\u00e9diction d'\u00e9v\u00e9nements al\u00e9atoires.\n<li class=\"l\"> Possibilit\u00e9 d'int\u00e9gration avec les plateformes de monitoring Prometheus et Grafana.  <\/ul>\n<p>Gestion via REST API.  <\/p>\n<ul>\n<li class=\"l\"> 17 fonctions HTTP\/JSON pour une gestion compl\u00e8te du cluster.\n<li class=\"l\"> API int\u00e9gr\u00e9 <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/fr\/server\/\"   title=\"serveur\" data-wpil-keyword-link=\"linked\">serveur<\/a> fonctionnant sur le port 8080.\n<li class=\"l\"> Authentification par tokens JWT HMAC-SHA256.\n<li class=\"l\"> Obtention de statistiques et de m\u00e9triques d'\u00e9tat de l'ex\u00e9cution.\n<li class=\"l\"> Temps de r\u00e9ponse inf\u00e9rieur \u00e0 10 ms.  <\/ul>\n<p>Diffusion d'\u00e9v\u00e9nements MQTT.  <\/p>\n<ul>\n<li class=\"l\"> MQTT est utilis\u00e9 pour publier des changements d'\u00e9tat des n\u0153uds, le basculement et les v\u00e9rifications d'\u00e9tat des ressources en temps r\u00e9el.\n<li class=\"l\"> Les topics MQTT peuvent \u00eatre configur\u00e9s pour diff\u00e9rents types d'\u00e9v\u00e9nements.\n<li class=\"l\"> Int\u00e9gration avec Mosquitto, EMQX ou tout courtier MQTT.\n<li class=\"l\"> Fournit des alertes automatiques sur des \u00e9v\u00e9nements exceptionnels et fournit un canal de transport pour l'orchestration du cluster.  <\/ul>\n<li class=\"l\"> Utilitaire en ligne de commande bctl :\n<ul>\n<li class=\"l\"> Une interface unique rempla\u00e7ant plus de 10 commandes distinctes \u00ab pcp_* \u00bb.\n<li class=\"l\"> 3 formats de sortie : tableaux, JSON ou format brut.\n<li class=\"l\"> Sortie de tableaux format\u00e9s avec cadre pour les donn\u00e9es runtime pgbalancer.\n<li class=\"l\"> Gestion \u00e0 distance et mode de sortie avanc\u00e9.  <\/ul>\n<li class=\"l\"> Workflow GitHub Actions :\n<ul>\n<li class=\"l\"> build-matrix.yml : Builds sur plusieurs plateformes (Ubuntu, macOS, Rocky Linux).\n<li class=\"l\"> Support de PostgreSQL 13-18.\n<li class=\"l\"> Paquets DEB pour Ubuntu 22.04\/24.04, Debian 11\/12.\n<li class=\"l\"> Paquets RPM pour Rocky 9, AlmaLinux 9, CentOS Stream 9.\n<li class=\"l\"> Support d'Autotools avec int\u00e9gration d'autoreconf.\n<li class=\"l\"> docs.yml : D\u00e9ploiement de la documentation sur GitHub Pages.  <\/ul>\n<\/ul>\n<p>Source : <a rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=64140\">opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d \u043f\u0435\u0440\u0432\u044b\u0439 \u0432\u044b\u043f\u0443\u0441\u043a pgbalancer, \u0431\u0430\u043b\u0430\u043d\u0441\u0438\u0440\u043e\u0432\u0449\u0438\u043a\u0430 \u043d\u0430\u0433\u0440\u0443\u0437\u043a\u0438 PostgreSQL \u043d\u0430 \u043e\u0441\u043d\u043e\u0432\u0435 \u0438\u0441\u043a\u0443\u0441\u0441\u0442\u0432\u0435\u043d\u043d\u043e\u0433\u043e \u0438\u043d\u0442\u0435\u043b\u043b\u0435\u043a\u0442\u0430 \u0441 REST API \u0438 MQTT. Pgbalancer \u043e\u0431\u0435\u0441\u043f\u0435\u0447\u0438\u0432\u0430\u0435\u0442 \u043e\u0431\u0440\u0430\u0431\u043e\u0442\u043a\u0443 \u043f\u0443\u043b\u0430 \u0441\u043e\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u0439 \u0438 \u0431\u0430\u043b\u0430\u043d\u0441\u0438\u0440\u043e\u0432\u043a\u0443 \u043d\u0430\u0433\u0440\u0443\u0437\u043a\u0438 \u0434\u043b\u044f PostgreSQL, \u0443\u043f\u0440\u0430\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u043f\u043e \u043f\u0440\u043e\u0442\u043e\u043a\u043e\u043b\u0443 HTTP \u0438 \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u0435\u0442 \u043f\u043e\u0442\u043e\u043a\u043e\u0432\u0443\u044e \u043f\u0435\u0440\u0435\u0434\u0430\u0447\u0443 \u0441\u043e\u0431\u044b\u0442\u0438\u0439 \u0432 \u0440\u0435\u0436\u0438\u043c\u0435 \u0440\u0435\u0430\u043b\u044c\u043d\u043e\u0433\u043e \u0432\u0440\u0435\u043c\u0435\u043d\u0438. \u041f\u0440\u043e\u0435\u043a\u0442 \u0441\u043e\u0437\u0434\u0430\u043d \u043a\u0430\u043a \u0444\u043e\u0440\u043a pgpool-II \u0441 \u0441\u0435\u0440\u044c\u0451\u0437\u043d\u044b\u043c\u0438 \u0443\u043b\u0443\u0447\u0448\u0435\u043d\u0438\u044f\u043c\u0438 \u0434\u043b\u044f \u0443\u043c\u043d\u043e\u0439 \u043c\u0430\u0440\u0448\u0440\u0443\u0442\u0438\u0437\u0430\u0446\u0438\u0438 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432. \u041a\u043e\u0434 \u043d\u0430\u043f\u0438\u0441\u0430\u043d \u043d\u0430 \u044f\u0437\u044b\u043a\u0435 [&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-146812","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.3 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d \u043f\u0435\u0440\u0432\u044b\u0439 \u0432\u044b\u043f\u0443\u0441\u043a pgbalancer, \u0431\u0430\u043b\u0430\u043d\u0441\u0438\u0440\u043e\u0432\u0449\u0438\u043a\u0430 \u043d\u0430\u0433\u0440\u0443\u0437\u043a\u0438 PostgreSQL \u043d\u0430 \u043e\u0441\u043d\u043e\u0432\u0435 \u0438\u0441\u043a\u0443\u0441\u0441\u0442\u0432\u0435\u043d\u043d\u043e\u0433\u043e \u0438\u043d\u0442\u0435\u043b\u043b\u0435\u043a\u0442\u0430 \u0441 REST API \u0438 MQTT.\" \/>\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\/vyshel-pgbalancer-1-0-balansirovshhik-nagruzki-postgresql-na-osnove-ii-podderzhivayushhij-rest-api-i-mqtt\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.3\" \/>\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\u0448\u0435\u043b pgbalancer 1.0, \u0431\u0430\u043b\u0430\u043d\u0441\u0438\u0440\u043e\u0432\u0449\u0438\u043a \u043d\u0430\u0433\u0440\u0443\u0437\u043a\u0438 PostgreSQL \u043d\u0430 \u043e\u0441\u043d\u043e\u0432\u0435 \u0418\u0418, \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u044e\u0449\u0438\u0439 REST API \u0438 MQTT | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d \u043f\u0435\u0440\u0432\u044b\u0439 \u0432\u044b\u043f\u0443\u0441\u043a pgbalancer, \u0431\u0430\u043b\u0430\u043d\u0441\u0438\u0440\u043e\u0432\u0449\u0438\u043a\u0430 \u043d\u0430\u0433\u0440\u0443\u0437\u043a\u0438 PostgreSQL \u043d\u0430 \u043e\u0441\u043d\u043e\u0432\u0435 \u0438\u0441\u043a\u0443\u0441\u0441\u0442\u0432\u0435\u043d\u043d\u043e\u0433\u043e \u0438\u043d\u0442\u0435\u043b\u043b\u0435\u043a\u0442\u0430 \u0441 REST API \u0438 MQTT.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/fr\/blog\/news\/vyshel-pgbalancer-1-0-balansirovshhik-nagruzki-postgresql-na-osnove-ii-podderzhivayushhij-rest-api-i-mqtt\" \/>\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-30T09:11:58+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2025-10-30T09:11:58+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\udd47pgbalancer 1.0 est lanc\u00e9, un \u00e9quilibreur de charge PostgreSQL bas\u00e9 sur l'IA, supportant l'API REST et MQTT | ProHoster","description":"La premi\u00e8re version de pgbalancer, un \u00e9quilibreur de charge PostgreSQL bas\u00e9 sur l'intelligence artificielle avec API REST et MQTT, est maintenant publi\u00e9e.","canonical_url":"https:\/\/prohoster.info\/fr\/blog\/news\/vyshel-pgbalancer-1-0-balansirovshhik-nagruzki-postgresql-na-osnove-ii-podderzhivayushhij-rest-api-i-mqtt","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\u0448\u0435\u043b pgbalancer 1.0, \u0431\u0430\u043b\u0430\u043d\u0441\u0438\u0440\u043e\u0432\u0449\u0438\u043a \u043d\u0430\u0433\u0440\u0443\u0437\u043a\u0438 PostgreSQL \u043d\u0430 \u043e\u0441\u043d\u043e\u0432\u0435 \u0418\u0418, \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u044e\u0449\u0438\u0439 REST API \u0438 MQTT | ProHoster","og:description":"\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d \u043f\u0435\u0440\u0432\u044b\u0439 \u0432\u044b\u043f\u0443\u0441\u043a pgbalancer, \u0431\u0430\u043b\u0430\u043d\u0441\u0438\u0440\u043e\u0432\u0449\u0438\u043a\u0430 \u043d\u0430\u0433\u0440\u0443\u0437\u043a\u0438 PostgreSQL \u043d\u0430 \u043e\u0441\u043d\u043e\u0432\u0435 \u0438\u0441\u043a\u0443\u0441\u0441\u0442\u0432\u0435\u043d\u043d\u043e\u0433\u043e \u0438\u043d\u0442\u0435\u043b\u043b\u0435\u043a\u0442\u0430 \u0441 REST API \u0438 MQTT.","og:url":"https:\/\/prohoster.info\/fr\/blog\/news\/vyshel-pgbalancer-1-0-balansirovshhik-nagruzki-postgresql-na-osnove-ii-podderzhivayushhij-rest-api-i-mqtt","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-30T09:11:58+00:00","article:modified_time":"2025-10-30T09:11:58+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"146812","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-22 15:54:02","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2026-01-23 15:39:19","updated":"2026-02-22 15:54:02","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\/146812","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=146812"}],"version-history":[{"count":4,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/posts\/146812\/revisions"}],"predecessor-version":[{"id":173122,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/posts\/146812\/revisions\/173122"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/media?parent=146812"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/categories?post=146812"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/tags?post=146812"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}