{"id":1770,"date":"2025-02-18T11:18:55","date_gmt":"2022-05-06T16:48:21","guid":{"rendered":""},"modified":"2025-02-02T00:46:17","modified_gmt":"2025-02-01T23:46:17","slug":"como-configurar-replica-o-master-master-no-mariadb-no-debian-11","status":"publish","type":"post","link":"https:\/\/netcloud24.com\/knowledgebase\/como-configurar-replica-o-master-master-no-mariadb-no-debian-11\/","title":{"rendered":"Como Configurar Replica\u00e7\u00e3o Master-Master no MariaDB no Debian 11"},"content":{"rendered":"<p>\u00a0<\/p>\n<\/p>\n<h1>\u00a0<\/h1>\n<p>A replica\u00e7\u00e3o <strong>Master-Master<\/strong> no MariaDB permite que dois servidores estejam sincronizados de forma que ambos possam realizar leituras e escritas simult\u00e2neas. Esta configura\u00e7\u00e3o \u00e9 \u00fatil para alta disponibilidade e balanceamento de carga em grandes ambientes de banco de dados. Neste tutorial, iremos gui\u00e1-lo na configura\u00e7\u00e3o da replica\u00e7\u00e3o Master-Master no MariaDB em servidores rodando Debian 11.<\/p>\n<h2>Requisitos<\/h2>\n<ul>\n<li>Dois servidores Debian 11<\/li>\n<li>Usu\u00e1rio com privil\u00e9gios sudo<\/li>\n<li>MariaDB instalado em ambos os servidores<\/li>\n<\/ul>\n<h2>Passo 1: Atualizar o Sistema<\/h2>\n<p>Antes de come\u00e7ar, atualize ambos os servidores para garantir que todos os pacotes estejam atualizados:<\/p>\n<pre><code>sudo apt update &amp;&amp; sudo apt upgrade -y<\/code><\/pre>\n<h2>Passo 2: Instalar o MariaDB<\/h2>\n<p>Se o MariaDB n\u00e3o estiver instalado, voc\u00ea pode instal\u00e1-lo em ambos os servidores com o seguinte comando:<\/p>\n<pre><code>sudo apt install mariadb-server -y<\/code><\/pre>\n<h2>Passo 3: Configurar o MariaDB no Servidor 1<\/h2>\n<p>Abra o arquivo de configura\u00e7\u00e3o do MariaDB para editar as op\u00e7\u00f5es de replica\u00e7\u00e3o no primeiro servidor:<\/p>\n<pre><code>sudo nano \/etc\/mysql\/mariadb.conf.d\/50-server.cnf<\/code><\/pre>\n<p>Adicione ou modifique as seguintes linhas na se\u00e7\u00e3o <code>[mysqld]<\/code>:<\/p>\n<pre><code>[mysqld]\r\nserver-id=1\r\nlog_bin=\/var\/log\/mysql\/mysql-bin.log\r\nbinlog_do_db=nome_do_banco\r\nauto_increment_increment=2\r\nauto_increment_offset=1<\/code><\/pre>\n<p>Salve o arquivo e reinicie o MariaDB:<\/p>\n<pre><code>sudo systemctl restart mariadb<\/code><\/pre>\n<h2>Passo 4: Configurar o MariaDB no Servidor 2<\/h2>\n<p>No segundo servidor, edite o arquivo de configura\u00e7\u00e3o da mesma forma:<\/p>\n<pre><code>sudo nano \/etc\/mysql\/mariadb.conf.d\/50-server.cnf<\/code><\/pre>\n<p>Adicione ou modifique as seguintes linhas:<\/p>\n<pre><code>[mysqld]\r\nserver-id=2\r\nlog_bin=\/var\/log\/mysql\/mysql-bin.log\r\nbinlog_do_db=nome_do_banco\r\nauto_increment_increment=2\r\nauto_increment_offset=2<\/code><\/pre>\n<p>Salve o arquivo e reinicie o MariaDB:<\/p>\n<pre><code>sudo systemctl restart mariadb<\/code><\/pre>\n<h2>Passo 5: Configurar o Usu\u00e1rio de Replica\u00e7\u00e3o<\/h2>\n<p>Agora, precisamos criar um usu\u00e1rio de replica\u00e7\u00e3o em ambos os servidores. Execute o seguinte comando no Servidor 1 e no Servidor 2 dentro do MariaDB:<\/p>\n<pre><code>CREATE USER 'replicador'@'%' IDENTIFIED BY 'senha_forte';\r\nGRANT REPLICATION SLAVE ON *.* TO 'replicador'@'%';\r\nFLUSH PRIVILEGES;<\/code><\/pre>\n<h2>Passo 6: Obter Informa\u00e7\u00f5es do Master<\/h2>\n<p>No Servidor 1, execute o seguinte comando para obter as informa\u00e7\u00f5es do log bin\u00e1rio:<\/p>\n<pre><code>SHOW MASTER STATUS;<\/code><\/pre>\n<p>Anote o nome do arquivo e a posi\u00e7\u00e3o. Repita o processo no Servidor 2.<\/p>\n<h2>Passo 7: Configurar a Replica\u00e7\u00e3o<\/h2>\n<p>No Servidor 1, configure o segundo servidor como slave:<\/p>\n<pre><code>CHANGE MASTER TO\r\nMASTER_HOST='IP_DO_SERVIDOR_2',\r\nMASTER_USER='replicador',\r\nMASTER_PASSWORD='senha_forte',\r\nMASTER_LOG_FILE='mysql-bin.000001',\r\nMASTER_LOG_POS= posi\u00e7\u00e3o_log;<\/code><\/pre>\n<p>No Servidor 2, configure o primeiro servidor como slave:<\/p>\n<pre><code>CHANGE MASTER TO\r\nMASTER_HOST='IP_DO_SERVIDOR_1',\r\nMASTER_USER='replicador',\r\nMASTER_PASSWORD='senha_forte',\r\nMASTER_LOG_FILE='mysql-bin.000001',\r\nMASTER_LOG_POS= posi\u00e7\u00e3o_log;<\/code><\/pre>\n<p>Inicie o slave em ambos os servidores:<\/p>\n<pre><code>START SLAVE;<\/code><\/pre>\n<h2>Passo 8: Verificar o Status da Replica\u00e7\u00e3o<\/h2>\n<p>Verifique se a replica\u00e7\u00e3o est\u00e1 funcionando corretamente nos dois servidores:<\/p>\n<pre><code>SHOW SLAVE STATUS\\G;<\/code><\/pre>\n<h2>Servidor VPS<\/h2>\n<p>Se precisar de um <a href=\"https:\/\/netcloud24.com?language=portuguese-pt&amp;currency=4\" target=\"_blank\" rel=\"follow\">servidor VPS<\/a> para configurar sua replica\u00e7\u00e3o Master-Master no MariaDB, veja as op\u00e7\u00f5es dispon\u00edveis aqui.<\/p>\n<p><a href=\"https:\/\/de.netcloud24.com\/\" target=\"_blank\">Windows VPS Deutschland<\/a><\/p>\n<p><a href=\"https:\/\/es.netcloud24.com\/\" target=\"_blank\">Windows VPS Espa\u00f1a<\/a><\/p>\n<p><a href=\"https:\/\/nl.netcloud24.com\/\" target=\"_blank\">Windows VPS Nederland<\/a><\/p>\n<p><a href=\"https:\/\/it.netcloud24.com\/\" target=\"_blank\">Windows VPS Italia<\/a><\/p>\n<p><a href=\"https:\/\/pt.netcloud24.com\/\" target=\"_blank\">Windows VPS Portugal<\/a><\/p>\n<p><a href=\"https:\/\/it.netcloud24.com\/\" target=\"_blank\">VPS Windows Italia<\/a><\/p>\n<p><a href=\"https:\/\/ie.netcloud24.com\" target=\"_blank\">Windows VPS<\/a><\/p>\n<p><a href=\"https:\/\/ie.netcloud24.com\" target=\"_blank\">Windows VPS<\/a><\/p>\n<p><a href=\"https:\/\/ie.netcloud24.com\" target=\"_blank\">Windows VPS Sverige<\/a><\/p>\n<p><a href=\"https:\/\/ie.netcloud24.com\" target=\"_blank\">Windows VPS Norge<\/a><\/p>\n<p><a href=\"https:\/\/ie.netcloud24.com\" target=\"_blank\">Windows VPS<\/a><\/p>\n<p><a href=\"https:\/\/ie.netcloud24.com\" target=\"_blank\">Windows VPS T\u00fcrkiye<\/a><\/p>\n<p><a href=\"https:\/\/ie.netcloud24.com\" target=\"_blank\">Windows RDS (Remote Desktop Services)<\/a><\/p>\n<p><a href=\"https:\/\/ie.netcloud24.com\" target=\"_blank\">Windows VPS<\/a><\/p>\n<div class=\"post-author-box\" style=\"border-top:1px solid #ddd;margin-top:20px;padding-top:15px;\">\n<p><strong>Author:<\/strong> \u0141ukasz Bodziony<\/p>\n<p><strong>Website:<\/strong> <a href=\"https:\/\/ca.netcloud24.com\" target=\"_blank\" rel=\"dofollow\">Windows VPS<\/a><\/p>\n<p><em>\u0141ukasz Bodziony is the CEO and founder of <a href=\"https:\/\/netcloud24.com\" target=\"_blank\" rel=\"dofollow\">NETCLOUD24<\/a>, a global VPS hosting brand proudly originating from Poland. With extensive experience in cloud computing, virtualization, and server management, he delivers high-performance <strong>Windows VPS<\/strong> and <strong>Remote Desktop Services (RDS)<\/strong> solutions to clients across Europe, North America, and beyond.<\/em><\/p>\n<p><em>His expertise covers a wide range of technologies, including <strong>Microsoft Azure<\/strong>, <strong>Proxmox VE<\/strong>, <strong>Amazon Web Services (AWS)<\/strong>, and numerous other virtualization and cloud platforms.<\/em><\/p>\n<p><em>Beyond running his hosting business, \u0141ukasz also provides <strong>professional paid server configuration and optimization services<\/strong> for companies and individuals. Outside of work, he is dedicated to caring for his children and building a secure future for them.<\/em><\/p>\n<p><em>If you are interested in working with him or need expert assistance with your hosting, cloud environment, or server setup, feel free to reach out via <a href=\"https:\/\/ca.netcloud24.com\" target=\"_blank\" rel=\"dofollow\">Windows VPS<\/a>.<\/em><\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u00a0 \u00a0 A replica\u00e7\u00e3o Master-Master no MariaDB permite que dois servidores estejam sincronizados de forma que ambos possam realizar leituras e escritas simult\u00e2neas. Esta configura\u00e7\u00e3o \u00e9 \u00fatil para\u2026<\/p>\n","protected":false},"author":1,"featured_media":3421,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_seopress_robots_primary_cat":"","_seopress_titles_title":"","_seopress_titles_desc":"","_seopress_robots_index":"","footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[],"tags":[14,12,11,23,20,21,22,17,7,8,6,10,18,19,15,24,16,5,13,9],"class_list":["post-1770","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","tag-cheapvps","tag-cloudvps","tag-hostingvps","tag-rds","tag-rdscal","tag-remotedesktop","tag-remotedesktopvps","tag-servervps","tag-ukvps","tag-virtualserver","tag-vpshosting","tag-vpsserver","tag-vpssolutions","tag-vpswindows","tag-vpswithwindows","tag-windowsrds","tag-windowsserver","tag-windowsvps","tag-windowsvpshosting","tag-windowsvpsuk"],"jetpack_publicize_connections":[],"_links":{"self":[{"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/posts\/1770","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/comments?post=1770"}],"version-history":[{"count":0,"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/posts\/1770\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/media\/3421"}],"wp:attachment":[{"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/media?parent=1770"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/categories?post=1770"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/netcloud24.com\/knowledgebase\/wp-json\/wp\/v2\/tags?post=1770"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}