{"id":312,"date":"2024-09-24T00:43:06","date_gmt":"2024-09-24T00:43:06","guid":{"rendered":"https:\/\/pietrocornelio-labs.com\/?p=312"},"modified":"2024-09-27T11:55:54","modified_gmt":"2024-09-27T11:55:54","slug":"postgresql-in-ha-con-percona","status":"publish","type":"post","link":"https:\/\/pietrocornelio-labs.com\/?p=312","title":{"rendered":"PostgreSQL in HA con Percona"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><strong>Appunti Pratici<\/strong> : <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Di seguito i miei appunti sviluppati durante alcuni test di laboratorio per la realizzazione di un RDBMS in alta affidabilit\u00e0. Si tratta di un tutorial \u201cfor dummies\u201d ma non banale che espone con chiarezza passo dopo passo come si costruisce un cluster ad alta affidabilit\u00e0.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In questo tutorial viene esposto come installare e configurare correttamente un impianto cluster in alta disponibilit\u00e0 HA (High Avalaibility) dell\u2019RDBMS PostgreSQL insieme al <strong>framework Patroni<\/strong>, un <strong>archivio ETCD<\/strong> e un <strong>bilanciatore basato su HA Proxy<\/strong> pi\u00f9 altre tecnologie (come <strong>Keepalived<\/strong>) che rendono questo impianto altamente resiliente, funzionale e potente nel gestire connessioni client SQL concorrenti.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\">Per altri dettagli e nuove release si faccia riferimento alla documentazione ufficiale sul portale <a href=\"https:\/\/www.percona.com\/postgresql\">Percona<\/a>.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"739\" src=\"https:\/\/i0.wp.com\/pietrocornelio-labs.com\/wp-content\/uploads\/2024\/09\/Cluster-Percona-PostgreSQL-HA-by-Pietro-Cornelio.png?resize=1024%2C739&#038;ssl=1\" alt=\"\" class=\"wp-image-414\" srcset=\"https:\/\/i0.wp.com\/pietrocornelio-labs.com\/wp-content\/uploads\/2024\/09\/Cluster-Percona-PostgreSQL-HA-by-Pietro-Cornelio.png?resize=1024%2C739&amp;ssl=1 1024w, https:\/\/i0.wp.com\/pietrocornelio-labs.com\/wp-content\/uploads\/2024\/09\/Cluster-Percona-PostgreSQL-HA-by-Pietro-Cornelio.png?resize=300%2C216&amp;ssl=1 300w, https:\/\/i0.wp.com\/pietrocornelio-labs.com\/wp-content\/uploads\/2024\/09\/Cluster-Percona-PostgreSQL-HA-by-Pietro-Cornelio.png?resize=768%2C554&amp;ssl=1 768w, https:\/\/i0.wp.com\/pietrocornelio-labs.com\/wp-content\/uploads\/2024\/09\/Cluster-Percona-PostgreSQL-HA-by-Pietro-Cornelio.png?w=1088&amp;ssl=1 1088w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<div data-wp-interactive=\"core\/file\" class=\"wp-block-file\"><object data-wp-bind--hidden=\"!state.hasPdfPreview\" hidden class=\"wp-block-file__embed\" data=\"https:\/\/pietrocornelio-labs.com\/wp-content\/uploads\/2024\/09\/Tutorial-PostgreSQL-HA-Percona-by-Pietro-Cornelio-1.pdf\" type=\"application\/pdf\" style=\"width:100%;height:600px\" aria-label=\"Incorporamento di Tutorial PostgreSQL HA Percona by Pietro Cornelio.\"><\/object><a id=\"wp-block-file--media-2e6aa4d3-a0c3-4fb4-b914-0d8f829b6847\" href=\"https:\/\/pietrocornelio-labs.com\/wp-content\/uploads\/2024\/09\/Tutorial-PostgreSQL-HA-Percona-by-Pietro-Cornelio-1.pdf\">Tutorial PostgreSQL HA Percona by Pietro Cornelio<\/a><a href=\"https:\/\/pietrocornelio-labs.com\/wp-content\/uploads\/2024\/09\/Tutorial-PostgreSQL-HA-Percona-by-Pietro-Cornelio-1.pdf\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-2e6aa4d3-a0c3-4fb4-b914-0d8f829b6847\">Download<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Appunti Pratici : Di seguito i miei appunti sviluppati durante alcuni test di laboratorio per la realizzazione di un RDBMS in alta affidabilit\u00e0. Si tratta di un tutorial \u201cfor dummies\u201d ma non banale che espone con chiarezza passo dopo passo come si costruisce un cluster ad alta affidabilit\u00e0. In questo tutorial viene esposto come installare &#8230; <a title=\"PostgreSQL in HA con Percona\" class=\"read-more\" href=\"https:\/\/pietrocornelio-labs.com\/?p=312\" aria-label=\"Per saperne di pi\u00f9 su PostgreSQL in HA con Percona\">Leggi tutto<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[9,38,49,41],"tags":[],"class_list":["post-312","post","type-post","status-publish","format-standard","hentry","category-elettronica-informatica","category-informatica","category-sistemi-informatici","category-unix"],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/pietrocornelio-labs.com\/index.php?rest_route=\/wp\/v2\/posts\/312","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pietrocornelio-labs.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pietrocornelio-labs.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pietrocornelio-labs.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pietrocornelio-labs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=312"}],"version-history":[{"count":3,"href":"https:\/\/pietrocornelio-labs.com\/index.php?rest_route=\/wp\/v2\/posts\/312\/revisions"}],"predecessor-version":[{"id":415,"href":"https:\/\/pietrocornelio-labs.com\/index.php?rest_route=\/wp\/v2\/posts\/312\/revisions\/415"}],"wp:attachment":[{"href":"https:\/\/pietrocornelio-labs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=312"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pietrocornelio-labs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=312"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pietrocornelio-labs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=312"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}