{"id":553,"date":"2020-08-25T16:19:34","date_gmt":"2020-08-25T16:19:34","guid":{"rendered":"https:\/\/4linux.com.br\/?page_id=553"},"modified":"2024-08-30T19:42:59","modified_gmt":"2024-08-30T19:42:59","slug":"o-que-e-hotstandby","status":"publish","type":"page","link":"https:\/\/4linux.com.br\/o-que-e-hotstandby\/","title":{"rendered":"O que \u00e9 HotStandby"},"content":{"rendered":"\n

Quando o ambiente se torna grande demais, por vezes, faz-se a cria\u00e7\u00e3o de r\u00e9plicas, tamb\u00e9m conhecido como crescimento horizontal. As r\u00e9plicas s\u00e3o criadas com o intuito de se distribuir a carga de dados para consulta. Neste ponto entra o HotStandby, este \u00e9 o nome que se d\u00e1 as r\u00e9plicas que est\u00e3o liberadas para leitura, tamb\u00e9m conhecidas como slaves.<\/p>\n\n\n\n

O PostgreSQL trabalha com dois tipos de replica\u00e7\u00e3o, a replica\u00e7\u00e3o s\u00edncrona e a ass\u00edncrona, e essas r\u00e9plicas se comunicam com o servidor master. A comunica\u00e7\u00e3o se d\u00e1 de duas formas: Log Shipping e\/ou Streaming Replication. Sendo que a streaming replication utiliza um protocolo pr\u00f3prio de comunica\u00e7\u00e3o.<\/p>\n\n\n

\n
\n\n

Colocar um curso da 4Linux no seu LinkedIn faz toda a diferen\u00e7a!<\/h2>\n\n\n\n

Transforme a sua carreira agora, invista em um curso que n\u00e3o \u00e9 palestra e sim cursos para quem quer aprender de verdade, colocando a \u2018m\u00e3o na massa\u2019.<\/p>\n\n\n\n

Aprenda com a \u00fanica escola que tamb\u00e9m implementa projetos, trazendo essa experi\u00eancia do mundo corporativo para a sala de aula.<\/p>\n\n\n\n

J\u00e1 treinamos +200.000 profissionais em nossos +40 cursos nas \u00e1reas de: Cloud, Containers, DevOps, Linux, Banco de Dados, Monitoramento de TI, Seguran\u00e7a.<\/h5>\n\n\n\n
\n
Conhe\u00e7a agora<\/a><\/div>\n\n\n\n
Fale com nossos especialistas<\/a><\/div>\n<\/div>\n\n<\/div>\n\n
\n\n
\"\"<\/figure>\n\n<\/div>\n<\/div>\n\n\n

O ‘continuous archiving’ pode ser usado para criar uma configura\u00e7\u00e3o de cluster de alta disponibilidade (HA) com um ou mais servidores em espera prontos para assumir as opera\u00e7\u00f5es se o servidor prim\u00e1rio falhar. Esse recurso \u00e9 amplamente conhecido como warm standby ou Log Shipping.<\/p>\n\n\n\n

Streaming Replication (SR) fornece ao banco de dados prim\u00e1rio a capacidade de enviar e aplicar continuamente os registros WAL XLOG a um certo n\u00famero de servidores em standby para mant\u00ea-los atualizados. A Streaming Replication permite que um servidor em standby fique o mais atualizado poss\u00edvel com o envio de log baseado em arquivo. O standby se conecta ao prim\u00e1rio, que transmite os registros do WAL para o modo de espera \u00e0 medida que s\u00e3o gerados, sem esperar que o arquivo do WAL seja preenchido.<\/p>\n","protected":false},"excerpt":{"rendered":"

Quando o ambiente se torna grande demais, por vezes, faz-se a cria\u00e7\u00e3o de r\u00e9plicas, tamb\u00e9m conhecido como crescimento horizontal.<\/p>\n","protected":false},"author":4,"featured_media":850,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"class_list":["post-553","page","type-page","status-publish","has-post-thumbnail"],"acf":[],"yoast_head":"\nO que \u00e9 hot standby postgresql - 4Linux<\/title>\n<meta name=\"description\" content=\"Replica\u00e7\u00e3o no PostgreSQL. Hot standby no PostgreSQL. O que \u00e9 Log Shipping e\/ou Streaming Replication. HA e Cluster no PostgreSQL.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/4linux.com.br\/o-que-e-hotstandby\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"O que \u00e9 hot standby postgresql - 4Linux\" \/>\n<meta property=\"og:description\" content=\"Replica\u00e7\u00e3o no PostgreSQL. Hot standby no PostgreSQL. O que \u00e9 Log Shipping e\/ou Streaming Replication. HA e Cluster no PostgreSQL.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/4linux.com.br\/o-que-e-hotstandby\/\" \/>\n<meta property=\"og:site_name\" content=\"4Linux\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/4linux\" \/>\n<meta property=\"article:modified_time\" content=\"2024-08-30T19:42:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/4linux.com.br\/wp-content\/uploads\/2020\/08\/o-que-e-hotstandby.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1366\" \/>\n\t<meta property=\"og:image:height\" content=\"396\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@4linux\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/4linux.com.br\/o-que-e-hotstandby\/\",\"url\":\"https:\/\/4linux.com.br\/o-que-e-hotstandby\/\",\"name\":\"O que \u00e9 hot standby postgresql - 4Linux\",\"isPartOf\":{\"@id\":\"https:\/\/4linux.com.br\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/4linux.com.br\/o-que-e-hotstandby\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/4linux.com.br\/o-que-e-hotstandby\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/4linux.com.br\/wp-content\/uploads\/2020\/08\/o-que-e-hotstandby.jpg\",\"datePublished\":\"2020-08-25T16:19:34+00:00\",\"dateModified\":\"2024-08-30T19:42:59+00:00\",\"description\":\"Replica\u00e7\u00e3o no PostgreSQL. Hot standby no PostgreSQL. O que \u00e9 Log Shipping e\/ou Streaming Replication. HA e Cluster no PostgreSQL.\",\"breadcrumb\":{\"@id\":\"https:\/\/4linux.com.br\/o-que-e-hotstandby\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/4linux.com.br\/o-que-e-hotstandby\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/4linux.com.br\/o-que-e-hotstandby\/#primaryimage\",\"url\":\"https:\/\/4linux.com.br\/wp-content\/uploads\/2020\/08\/o-que-e-hotstandby.jpg\",\"contentUrl\":\"https:\/\/4linux.com.br\/wp-content\/uploads\/2020\/08\/o-que-e-hotstandby.jpg\",\"width\":1366,\"height\":396,\"caption\":\"Hotstandby\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/4linux.com.br\/o-que-e-hotstandby\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/4linux.com.br\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"O que \u00e9 HotStandby\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/4linux.com.br\/#website\",\"url\":\"https:\/\/4linux.com.br\/\",\"name\":\"4Linux\",\"description\":\"Open Software Specialists\",\"publisher\":{\"@id\":\"https:\/\/4linux.com.br\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/4linux.com.br\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/4linux.com.br\/#organization\",\"name\":\"4Linux\",\"url\":\"https:\/\/4linux.com.br\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/4linux.com.br\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/4linux.com.br\/wp-content\/uploads\/2020\/02\/logo-POSITIVO.png\",\"contentUrl\":\"https:\/\/4linux.com.br\/wp-content\/uploads\/2020\/02\/logo-POSITIVO.png\",\"width\":1024,\"height\":325,\"caption\":\"4Linux\"},\"image\":{\"@id\":\"https:\/\/4linux.com.br\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/4linux\",\"https:\/\/x.com\/4linux\",\"https:\/\/www.instagram.com\/4linux\",\"https:\/\/www.linkedin.com\/company\/4linux\",\"https:\/\/www.youtube.com\/user\/4linuxmultimidia\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"O que \u00e9 hot standby postgresql - 4Linux","description":"Replica\u00e7\u00e3o no PostgreSQL. Hot standby no PostgreSQL. O que \u00e9 Log Shipping e\/ou Streaming Replication. HA e Cluster no PostgreSQL.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/4linux.com.br\/o-que-e-hotstandby\/","og_locale":"en_US","og_type":"article","og_title":"O que \u00e9 hot standby postgresql - 4Linux","og_description":"Replica\u00e7\u00e3o no PostgreSQL. Hot standby no PostgreSQL. O que \u00e9 Log Shipping e\/ou Streaming Replication. HA e Cluster no PostgreSQL.","og_url":"https:\/\/4linux.com.br\/o-que-e-hotstandby\/","og_site_name":"4Linux","article_publisher":"https:\/\/www.facebook.com\/4linux","article_modified_time":"2024-08-30T19:42:59+00:00","og_image":[{"width":1366,"height":396,"url":"https:\/\/4linux.com.br\/wp-content\/uploads\/2020\/08\/o-que-e-hotstandby.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_site":"@4linux","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/4linux.com.br\/o-que-e-hotstandby\/","url":"https:\/\/4linux.com.br\/o-que-e-hotstandby\/","name":"O que \u00e9 hot standby postgresql - 4Linux","isPartOf":{"@id":"https:\/\/4linux.com.br\/#website"},"primaryImageOfPage":{"@id":"https:\/\/4linux.com.br\/o-que-e-hotstandby\/#primaryimage"},"image":{"@id":"https:\/\/4linux.com.br\/o-que-e-hotstandby\/#primaryimage"},"thumbnailUrl":"https:\/\/4linux.com.br\/wp-content\/uploads\/2020\/08\/o-que-e-hotstandby.jpg","datePublished":"2020-08-25T16:19:34+00:00","dateModified":"2024-08-30T19:42:59+00:00","description":"Replica\u00e7\u00e3o no PostgreSQL. Hot standby no PostgreSQL. O que \u00e9 Log Shipping e\/ou Streaming Replication. HA e Cluster no PostgreSQL.","breadcrumb":{"@id":"https:\/\/4linux.com.br\/o-que-e-hotstandby\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/4linux.com.br\/o-que-e-hotstandby\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/4linux.com.br\/o-que-e-hotstandby\/#primaryimage","url":"https:\/\/4linux.com.br\/wp-content\/uploads\/2020\/08\/o-que-e-hotstandby.jpg","contentUrl":"https:\/\/4linux.com.br\/wp-content\/uploads\/2020\/08\/o-que-e-hotstandby.jpg","width":1366,"height":396,"caption":"Hotstandby"},{"@type":"BreadcrumbList","@id":"https:\/\/4linux.com.br\/o-que-e-hotstandby\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/4linux.com.br\/"},{"@type":"ListItem","position":2,"name":"O que \u00e9 HotStandby"}]},{"@type":"WebSite","@id":"https:\/\/4linux.com.br\/#website","url":"https:\/\/4linux.com.br\/","name":"4Linux","description":"Open Software Specialists","publisher":{"@id":"https:\/\/4linux.com.br\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/4linux.com.br\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/4linux.com.br\/#organization","name":"4Linux","url":"https:\/\/4linux.com.br\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/4linux.com.br\/#\/schema\/logo\/image\/","url":"https:\/\/4linux.com.br\/wp-content\/uploads\/2020\/02\/logo-POSITIVO.png","contentUrl":"https:\/\/4linux.com.br\/wp-content\/uploads\/2020\/02\/logo-POSITIVO.png","width":1024,"height":325,"caption":"4Linux"},"image":{"@id":"https:\/\/4linux.com.br\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/4linux","https:\/\/x.com\/4linux","https:\/\/www.instagram.com\/4linux","https:\/\/www.linkedin.com\/company\/4linux","https:\/\/www.youtube.com\/user\/4linuxmultimidia"]}]}},"_links":{"self":[{"href":"https:\/\/4linux.com.br\/wp-json\/wp\/v2\/pages\/553"}],"collection":[{"href":"https:\/\/4linux.com.br\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/4linux.com.br\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/4linux.com.br\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/4linux.com.br\/wp-json\/wp\/v2\/comments?post=553"}],"version-history":[{"count":0,"href":"https:\/\/4linux.com.br\/wp-json\/wp\/v2\/pages\/553\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/4linux.com.br\/wp-json\/wp\/v2\/media\/850"}],"wp:attachment":[{"href":"https:\/\/4linux.com.br\/wp-json\/wp\/v2\/media?parent=553"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}