{"id":12569,"date":"2024-01-22T16:43:07","date_gmt":"2024-01-22T13:43:07","guid":{"rendered":"https:\/\/itsm.com\/?p=12569"},"modified":"2024-09-20T16:50:22","modified_gmt":"2024-09-20T13:50:22","slug":"masshtabirovanie-baz-dannyh-2","status":"publish","type":"post","link":"https:\/\/itsm.com\/pb\/blog\/masshtabirovanie-baz-dannyh-2\/","title":{"rendered":"Dimensionamento do banco de dados"},"content":{"rendered":"<p>No processo de desenvolvimento dos neg\u00f3cios, o volume de dados necess\u00e1rios e as opera\u00e7\u00f5es com eles aumentam. Em um determinado momento, um servidor n\u00e3o consegue mais lidar com a carga, e ent\u00e3o \u00e9 necess\u00e1rio dimensionar o banco de dados. Como esse processo \u00e9 realizado?<\/p>\n[cta_banner link=&#8221;https:\/\/itsm.com\/pb\/platform\/&#8221; title=&#8221;Mais detalhado&#8221;]<a href=\"https:\/\/itsm.com\/pb\/platform\/\">Sistema ESM escal\u00e1vel<\/a> [\/cta_banner]\n<h2>Dimensionamento vertical<\/h2>\n<p>O dimensionamento vertical envolve o aumento da capacidade do servidor. A principal vantagem do m\u00e9todo \u00e9 sua simplicidade. N\u00e3o h\u00e1 necessidade de reescrever o c\u00f3digo ao adicionar capacidade, e \u00e9 muito mais f\u00e1cil gerenciar um servidor grande do que um sistema inteiro. Essa tamb\u00e9m \u00e9 a principal desvantagem: o dimensionamento dos recursos de um servidor tem limita\u00e7\u00f5es de hardware bastante espec\u00edficas. Tamb\u00e9m vale a pena considerar o custo dessa solu\u00e7\u00e3o: um servidor com v\u00e1rios recursos computacionais, na maioria dos casos, \u00e9 mais caro do que v\u00e1rios servidores menos potentes que oferecem o mesmo desempenho no total.<\/p>\n<h2>Escalonamento horizontal<\/h2>\n<p>O escalonamento horizontal significa aumentar o desempenho dividindo os dados em v\u00e1rios servidores. Esse m\u00e9todo envolve aumentar o desempenho sem diminuir a toler\u00e2ncia a falhas. H\u00e1 tr\u00eas tipos principais de escalonamento horizontal.<\/p>\n<h3>Replica\u00e7\u00e3o<\/h3>\n<p>Esse termo implica a c\u00f3pia de dados entre servidores. Ao usar esse m\u00e9todo, h\u00e1 dois tipos de servidores: mestre e escravo. O mestre \u00e9 usado para gravar ou alterar informa\u00e7\u00f5es, e os escravos s\u00e3o usados para copiar informa\u00e7\u00f5es do mestre e l\u00ea-las. Na maioria das vezes, s\u00e3o usados um mestre e v\u00e1rios escravos, pois geralmente h\u00e1 mais solicita\u00e7\u00f5es de leitura do que de altera\u00e7\u00e3o. A principal vantagem da replica\u00e7\u00e3o \u00e9 um grande n\u00famero de c\u00f3pias de dados. Portanto, se at\u00e9 mesmo o servidor mestre falhar, qualquer outro servidor poder\u00e1 substitu\u00ed-lo. No entanto, a replica\u00e7\u00e3o n\u00e3o \u00e9 muito conveniente como mecanismo de dimensionamento. O motivo para isso \u00e9 a dessincroniza\u00e7\u00e3o e os atrasos na transfer\u00eancia de dados entre os servidores. A replica\u00e7\u00e3o \u00e9 mais frequentemente usada como um meio de fornecer toler\u00e2ncia a falhas em conjunto com outros m\u00e9todos de dimensionamento.<\/p>\n<h3>Particionamento\/Seccionamento<\/h3>\n<p>Esse m\u00e9todo de dimensionamento envolve o particionamento de dados em partes com base em algum recurso. Por exemplo, uma tabela pode ser particionada em duas com base na paridade. O motivo para usar o particionamento \u00e9 melhorar o desempenho. Isso ocorre porque a pesquisa n\u00e3o \u00e9 realizada em toda a tabela, mas apenas em uma parte dela. Outra vantagem desse m\u00e9todo \u00e9 a capacidade de excluir rapidamente um fragmento irrelevante da tabela.<\/p>\n<h3>Sharding\/sharding\/segmenta\u00e7\u00e3o<\/h3>\n<p>Sharding \u00e9 um princ\u00edpio de design de banco de dados no qual partes de uma tabela s\u00e3o armazenadas separadamente, em diferentes servidores f\u00edsicos. A fragmenta\u00e7\u00e3o \u00e9 a solu\u00e7\u00e3o mais adequada para opera\u00e7\u00f5es em grande escala, especialmente quando combinada com a replica\u00e7\u00e3o. Mas vale a pena observar que \u00e9 bastante dif\u00edcil de organizar, pois a comunica\u00e7\u00e3o entre servidores deve ser levada em conta.<\/p>\n<h2>Resumo<\/h2>\n<p>Devido \u00e0 cria\u00e7\u00e3o de sistemas corporativos de alta carga, em que o volume de informa\u00e7\u00f5es e de usu\u00e1rios cresce a cada dia, a capacidade de dimensionar o sistema \u00e9 um dos principais fatores na sua sele\u00e7\u00e3o. Afinal, se cada est\u00e1gio do desenvolvimento dos neg\u00f3cios for acompanhado por um longo e complexo processo de otimiza\u00e7\u00e3o do suporte de informa\u00e7\u00f5es, vale a pena pensar na exatid\u00e3o da escolha do sistema de informa\u00e7\u00f5es.<\/p>","protected":false},"excerpt":{"rendered":"<p>No processo de desenvolvimento dos neg\u00f3cios, o volume de dados necess\u00e1rios e as opera\u00e7\u00f5es com eles aumentam. Em um determinado momento, um servidor n\u00e3o consegue mais lidar com a carga, e ent\u00e3o \u00e9 necess\u00e1rio dimensionar o banco de dados. Como esse processo \u00e9 realizado? [cta_banner link=&#8221;https:\/\/itsm.com\/pb\/platform\/&#8221; title=&#8221;Mais detalhado&#8221;]Sistema ESM escal\u00e1vel [\/cta_banner] Dimensionamento vertical O dimensionamento [&hellip;]<\/p>\n","protected":false},"author":48,"featured_media":12570,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[2],"tags":[15],"yoast_head":"<title>Dimensionamento do banco de dados - SimpleOne - Business Process Automation Platform<\/title>\n<meta name=\"description\" content=\"SimpleOne - Business Process Automation Platform Dimensionamento do banco de dados\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Dimensionamento do banco de dados - SimpleOne - Business Process Automation Platform\" \/>\n<meta property=\"og:description\" content=\"SimpleOne - Business Process Automation Platform Dimensionamento do banco de dados\" \/>\n<meta property=\"og:url\" content=\"https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/\" \/>\n<meta property=\"og:site_name\" content=\"SimpleOne - Business Process Automation Platform\" \/>\n<meta property=\"article:published_time\" content=\"2024-01-22T13:43:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/itsm.com\/wp-content\/uploads\/2024\/09\/masshtabirovanie-baz-dannyh-oblozhka.png\" \/>\n\t<meta property=\"og:image:width\" content=\"921\" \/>\n\t<meta property=\"og:image:height\" content=\"641\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/itsm.com\/#organization\",\"name\":\"SimpleOne\",\"url\":\"https:\/\/itsm.com\/\",\"sameAs\":[],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/itsm.com\/#logo\",\"inLanguage\":\"pt-BR\",\"url\":\"\/wp-content\/uploads\/2023\/11\/main_logo-1.png\",\"contentUrl\":\"\/wp-content\/uploads\/2023\/11\/main_logo-1.png\",\"width\":166,\"height\":23,\"caption\":\"SimpleOne\"},\"image\":{\"@id\":\"https:\/\/itsm.com\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/itsm.com\/#website\",\"url\":\"https:\/\/itsm.com\/\",\"name\":\"SimpleOne - Business Process Automation Platform\",\"description\":\"\u3164\",\"publisher\":{\"@id\":\"https:\/\/itsm.com\/#organization\"},\"inLanguage\":\"pt-BR\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/#primaryimage\",\"inLanguage\":\"pt-BR\",\"url\":\"\/wp-content\/uploads\/2024\/09\/masshtabirovanie-baz-dannyh-oblozhka.png\",\"contentUrl\":\"\/wp-content\/uploads\/2024\/09\/masshtabirovanie-baz-dannyh-oblozhka.png\",\"width\":921,\"height\":641},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/#webpage\",\"url\":\"https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/\",\"name\":\"[:en]Database scaling[:pb]Dimensionamento do banco de dados[:tr]Veritaban\u0131 \u00f6l\u00e7eklendirme[:ru]\u041c\u0430\u0441\u0448\u0442\u0430\u0431\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445[:] - SimpleOne - Business Process Automation Platform\",\"isPartOf\":{\"@id\":\"https:\/\/itsm.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/#primaryimage\"},\"datePublished\":\"2024-01-22T13:43:07+00:00\",\"dateModified\":\"2024-09-20T13:50:22+00:00\",\"description\":\"SimpleOne - Business Process Automation Platform [:en]Database scaling[:pb]Dimensionamento do banco de dados[:tr]Veritaban\u0131 \u00f6l\u00e7eklendirme[:ru]\u041c\u0430\u0441\u0448\u0442\u0430\u0431\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445[:]\",\"breadcrumb\":{\"@id\":\"https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/itsm.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Database scaling\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/#webpage\"},\"author\":{\"@id\":\"https:\/\/itsm.com\/#\/schema\/person\/c7515bc91e745fb07aed438cb94d6358\"},\"headline\":\"Dimensionamento do banco de dados\",\"datePublished\":\"2024-01-22T13:43:07+00:00\",\"dateModified\":\"2024-09-20T13:50:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/#webpage\"},\"wordCount\":1701,\"publisher\":{\"@id\":\"https:\/\/itsm.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/#primaryimage\"},\"thumbnailUrl\":\"\/wp-content\/uploads\/2024\/09\/masshtabirovanie-baz-dannyh-oblozhka.png\",\"keywords\":[\"Highload\"],\"articleSection\":[\"Blog\"],\"inLanguage\":\"pt-BR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/itsm.com\/#\/schema\/person\/c7515bc91e745fb07aed438cb94d6358\",\"name\":\"lyubov azarenko\",\"url\":\"https:\/\/itsm.com\/pb\/author\/lyubov-azarenko\/\"}]}<\/script>","yoast_head_json":{"title":"[:en]Database scaling[:pb]Dimensionamento do banco de dados[:tr]Veritaban\u0131 \u00f6l\u00e7eklendirme[:ru]\u041c\u0430\u0441\u0448\u0442\u0430\u0431\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445[:] - SimpleOne - Business Process Automation Platform","description":"SimpleOne - Business Process Automation Platform Dimensionamento do banco de dados","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"pt_BR","og_type":"article","og_title":"Dimensionamento do banco de dados - SimpleOne - Business Process Automation Platform","og_description":"SimpleOne - Business Process Automation Platform Dimensionamento do banco de dados","og_url":"https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/","og_site_name":"SimpleOne - Business Process Automation Platform","article_published_time":"2024-01-22T13:43:07+00:00","og_image":[{"width":921,"height":641,"url":"https:\/\/itsm.com\/wp-content\/uploads\/2024\/09\/masshtabirovanie-baz-dannyh-oblozhka.png","type":"image\/png"}],"twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/itsm.com\/#organization","name":"SimpleOne","url":"https:\/\/itsm.com\/","sameAs":[],"logo":{"@type":"ImageObject","@id":"https:\/\/itsm.com\/#logo","inLanguage":"pt-BR","url":"\/wp-content\/uploads\/2023\/11\/main_logo-1.png","contentUrl":"\/wp-content\/uploads\/2023\/11\/main_logo-1.png","width":166,"height":23,"caption":"SimpleOne"},"image":{"@id":"https:\/\/itsm.com\/#logo"}},{"@type":"WebSite","@id":"https:\/\/itsm.com\/#website","url":"https:\/\/itsm.com\/","name":"SimpleOne - Business Process Automation Platform","description":"\u3164","publisher":{"@id":"https:\/\/itsm.com\/#organization"},"inLanguage":"pt-BR"},{"@type":"ImageObject","@id":"https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/#primaryimage","inLanguage":"pt-BR","url":"\/wp-content\/uploads\/2024\/09\/masshtabirovanie-baz-dannyh-oblozhka.png","contentUrl":"\/wp-content\/uploads\/2024\/09\/masshtabirovanie-baz-dannyh-oblozhka.png","width":921,"height":641},{"@type":"WebPage","@id":"https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/#webpage","url":"https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/","name":"[:en]Database scaling[:pb]Dimensionamento do banco de dados[:tr]Veritaban\u0131 \u00f6l\u00e7eklendirme[:ru]\u041c\u0430\u0441\u0448\u0442\u0430\u0431\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445[:] - SimpleOne - Business Process Automation Platform","isPartOf":{"@id":"https:\/\/itsm.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/#primaryimage"},"datePublished":"2024-01-22T13:43:07+00:00","dateModified":"2024-09-20T13:50:22+00:00","description":"SimpleOne - Business Process Automation Platform [:en]Database scaling[:pb]Dimensionamento do banco de dados[:tr]Veritaban\u0131 \u00f6l\u00e7eklendirme[:ru]\u041c\u0430\u0441\u0448\u0442\u0430\u0431\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445[:]","breadcrumb":{"@id":"https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/itsm.com\/"},{"@type":"ListItem","position":2,"name":"Database scaling"}]},{"@type":"Article","@id":"https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/#article","isPartOf":{"@id":"https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/#webpage"},"author":{"@id":"https:\/\/itsm.com\/#\/schema\/person\/c7515bc91e745fb07aed438cb94d6358"},"headline":"Dimensionamento do banco de dados","datePublished":"2024-01-22T13:43:07+00:00","dateModified":"2024-09-20T13:50:22+00:00","mainEntityOfPage":{"@id":"https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/#webpage"},"wordCount":1701,"publisher":{"@id":"https:\/\/itsm.com\/#organization"},"image":{"@id":"https:\/\/itsm.com\/blog\/masshtabirovanie-baz-dannyh-2\/#primaryimage"},"thumbnailUrl":"\/wp-content\/uploads\/2024\/09\/masshtabirovanie-baz-dannyh-oblozhka.png","keywords":["Highload"],"articleSection":["Blog"],"inLanguage":"pt-BR"},{"@type":"Person","@id":"https:\/\/itsm.com\/#\/schema\/person\/c7515bc91e745fb07aed438cb94d6358","name":"lyubov azarenko","url":"https:\/\/itsm.com\/pb\/author\/lyubov-azarenko\/"}]}},"acf":[],"_links":{"self":[{"href":"https:\/\/itsm.com\/pb\/wp-json\/wp\/v2\/posts\/12569"}],"collection":[{"href":"https:\/\/itsm.com\/pb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/itsm.com\/pb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/itsm.com\/pb\/wp-json\/wp\/v2\/users\/48"}],"replies":[{"embeddable":true,"href":"https:\/\/itsm.com\/pb\/wp-json\/wp\/v2\/comments?post=12569"}],"version-history":[{"count":6,"href":"https:\/\/itsm.com\/pb\/wp-json\/wp\/v2\/posts\/12569\/revisions"}],"predecessor-version":[{"id":12582,"href":"https:\/\/itsm.com\/pb\/wp-json\/wp\/v2\/posts\/12569\/revisions\/12582"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/itsm.com\/pb\/wp-json\/wp\/v2\/media\/12570"}],"wp:attachment":[{"href":"https:\/\/itsm.com\/pb\/wp-json\/wp\/v2\/media?parent=12569"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/itsm.com\/pb\/wp-json\/wp\/v2\/categories?post=12569"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/itsm.com\/pb\/wp-json\/wp\/v2\/tags?post=12569"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}