C\u00e0i \u0111\u1eb7t MariaDB, galera, rsync tr\u00ean c\u00e1c m\u00e1y ch\u1ee7 b\u1eb1ng l\u1ec7nh sau(ch\u00fa \u00fd l\u00e0 t\u1ea5t c\u1ea3 m\u00e1y ch\u1ee7)<\/p>\n
# C\u00e0i \u0111\u1eb7t yum repo\r\ncurl -sS https:\/\/downloads.mariadb.com\/MariaDB\/mariadb_repo_setup | bash -s -- --mariadb-server-version=\"mariadb-10.4\"\r\n\r\n# c\u00e0i \u0111\u1eb7t MariaDB v\u00e0 c\u00e1c g\u00f3i c\u1ea7n thi\u1ebft.\r\nyum install MariaDB-server MariaDB-client galera-4 rsync lsof -y\r\n# trong qu\u00e1 t\u00ecnh c\u00e0i \u0111\u1eb7t nh\u1ea5n \"y\" \u0111\u1ec3 ch\u1ea5p nh\u1eadn c\u00e0i \u0111\u1eb7t c\u00e1c g\u00f3i.\r\n\r\n# c\u00e0i \u0111\u1eb7t mysql_secure_installation tr\u00ean node \u0111\u1ea7u ti\u00ean, c\u00e1c node kh\u00e1c kh\u00f4ng c\u1ea7n c\u00e0i.\r\nsystemctl start mariadb\r\nsystemctl enable mariadb\r\nmysql_secure_installation\r\nsystemctl stop mariadb<\/pre>\nSau khi c\u00e0i \u0111\u1eb7t ho\u00e0n t\u1ea5t, b\u1ea1n kh\u00f4ng kh\u1edfi \u0111\u1ed9ng v\u00e0 ti\u1ebfn h\u00e0nh thi\u1ebft l\u1eadp trong file my.cnf c\u1ee7a c\u00e1c m\u00e1y ch\u1ee7 nh\u01b0 sau(ch\u00fa \u00fd thay \u0111\u1ed5i IP v\u00e0 t\u00ean node trong ph\u1ea7n “Galera Node Configuration” t\u00f9y theo m\u1ed7i server):<\/p>\n
[mariadb]\r\n\r\nbind-address=0.0.0.0\r\nbinlog_format=ROW\r\ndefault_storage_engine=InnoDB\r\ninnodb_autoinc_lock_mode=2\r\nquery_cache_size=0\r\n\r\n\r\n# Galera Provider Configuration\r\nwsrep_on=ON\r\nwsrep_provider=\/usr\/lib64\/galera-4\/libgalera_smm.so\r\n\r\n# Galera Cluster Configuration\r\nwsrep_cluster_name=\"mariadb_cluster\"\r\nwsrep_cluster_address= \"gcomm:\/\/103.130.218.7,103.130.218.26,103.130.219.13\"\r\n\r\n# Galera Synchronization Configuration\r\nwsrep_sst_method=rsync\r\n\r\n# Galera Node Configuration\r\nwsrep_node_address=103.130.218.7\r\nwsrep_node_name=node1<\/pre>\n <\/p>\n
Kh\u1edfi \u0111\u1ed9ng MariaDB Galera Cluster<\/span><\/p>\nSau khi c\u1ea5u h\u00ecnh ho\u00e0n t\u1ea5t nh\u01b0 tr\u00ean, ch\u00fang ta truy c\u1eadp node1 v\u00e0 ch\u1ea1y l\u1ec7nh sau \u0111\u1ec3 kh\u1edfi \u0111\u1ed9ng Galera (ch\u00fa \u00fd kh\u1edfi \u0111\u1ed9ng Galera tr\u00ean node1 s\u1ebd kh\u1edfi \u0111\u1ed9ng MariaDB n\u00ean kh\u00f4ng ph\u1ea3i ch\u1ea1y l\u1ec7nh \u0111\u1ec3 start MariaDB n\u1eefa).<\/p>\n
galera_new_cluster<\/pre>\nn\u1ebfu ch\u1ea1y l\u1ec7nh tr\u00ean kh\u00f4ng nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 t\u1ee9c l\u00e0 \u0111\u00e3 kh\u1edfi t\u1ea1o galera th\u00e0nh c\u00f4ng, ta c\u00f3 th\u1ec3 ch\u1ea1y l\u1ec7nh sau \u0111\u1ec3 ki\u1ec3m tra c\u00f3 bao nhi\u00eau node \u0111ang tham gia trong galera.<\/p>\n
MariaDB [(none)]> SHOW GLOBAL STATUS LIKE 'wsrep_cluster_size';\r\n+--------------------+-------+\r\n| Variable_name | Value |\r\n+--------------------+-------+\r\n| wsrep_cluster_size | 1 |\r\n+--------------------+-------+\r\n1 row in set (0.001 sec)<\/pre>\nNh\u01b0 v\u1eady l\u00e0 node1 \u0111\u00e3 ho\u1ea1t \u0111\u1ed9ng trong galera, ti\u1ebfp \u0111\u1ebfn ta truy c\u1eadp node 2 v\u00e0 kh\u1edfi \u0111\u1ed9ng MariaDB, Galera s\u1ebd t\u1ef1 include c\u00e1c node v\u00e0o Galera.<\/p>\n
[root@node2db ~]# systemctl start mariadb<\/pre>\nV\u00e0 ti\u1ebfp t\u1ee5c kh\u1edfi \u0111\u1ed9ng MariaDB tr\u00ean node3<\/p>\n
[root@node3db ~]# systemctl start mariadb<\/pre>\nN\u1ebfu kh\u00f4ng c\u00f3 l\u1ed7i g\u00ec th\u00ec node2 v\u00e0 node3 \u0111\u00e3 \u0111\u01b0\u1ee3c th\u00eam v\u00e0o Galera, ch\u00fang ta ki\u1ec3m tra l\u1ea1i th\u1eed nh\u00e9:<\/p>\n
MariaDB [(none)]> SHOW GLOBAL STATUS LIKE 'wsrep_cluster_size';\r\n+--------------------+-------+\r\n| Variable_name | Value |\r\n+--------------------+-------+\r\n| wsrep_cluster_size | 3 |\r\n+--------------------+-------+\r\n1 row in set (0.001 sec)<\/pre>\nNh\u01b0 v\u1eady l\u00e0 Galera \u0111\u00e3 \u0111\u01b0\u1ee3c c\u1ea5u h\u00ecnh ho\u00e0n t\u1ea5t, ta ki\u1ec3m tra ho\u1ea1t \u0111\u1ed9ng\u00a0 \u0111\u01a1n gi\u1ea3n b\u1eb1ng c\u00e1ch t\u1ea1o ra 1 database tr\u00ean node1 v\u00e0 sau \u0111\u00f3 l\u1ea7n l\u01b0\u1ee3t ki\u1ec3m tra tr\u00ean node2 v\u00e0 node3 xem database m\u1edbi t\u1ea1o c\u00f3 \u0111\u01b0\u1ee3c \u0111\u1ed3ng b\u1ed9 sang c\u00e1c node n\u00e0y hay kh\u00f4ng<\/p>\n
Tr\u00ean node1 kh\u1edfi t\u1ea1o database name l\u00e0 “test_galera”:<\/p>\n
[root@node1db ~]# mysql\r\nWelcome to the MariaDB monitor. Commands end with ; or \\g.\r\nYour MariaDB connection id is 21\r\nServer version: 10.4.12-MariaDB MariaDB Server\r\n\r\nCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.\r\n\r\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\r\n\r\nMariaDB [(none)]> create database test_galera;\r\nQuery OK, 1 row affected (0.004 sec)<\/pre>\n <\/p>\n
Tr\u00ean node2 ki\u1ec3m tra xem c\u00f3 database name “test_galera” hay kh\u00f4ng:<\/p>\n
[root@node2db ~]# mysql\r\nWelcome to the MariaDB monitor. Commands end with ; or \\g.\r\nYour MariaDB connection id is 14\r\nServer version: 10.4.12-MariaDB MariaDB Server\r\n\r\nCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.\r\n\r\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\r\n\r\nMariaDB [(none)]> show databases;\r\n+--------------------+\r\n| Database |\r\n+--------------------+\r\n| information_schema |\r\n| mysql |\r\n| performance_schema |\r\n| test_galera |\r\n+--------------------+\r\n4 rows in set (0.001 sec)<\/pre>\n <\/p>\n
Tr\u00ean node3 ki\u1ec3m tra xem c\u00f3 database name “test_galera” hay kh\u00f4ng:<\/p>\n
[root@node3db ~]# mysql\r\nWelcome to the MariaDB monitor. Commands end with ; or \\g.\r\nYour MariaDB connection id is 13\r\nServer version: 10.4.12-MariaDB MariaDB Server\r\n\r\nCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.\r\n\r\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\r\n\r\nMariaDB [(none)]> show databases;\r\n+--------------------+\r\n| Database |\r\n+--------------------+\r\n| information_schema |\r\n| mysql |\r\n| performance_schema |\r\n| test_galera |\r\n+--------------------+\r\n4 rows in set (0.001 sec)<\/pre>\n <\/p>\n
Nh\u01b0 v\u1eady l\u00e0 d\u1eef li\u1ec7u \u0111\u00e3 \u0111\u1ed3ng b\u1ed9 tr\u00ean c\u00e1c node server. C\u1ea5u h\u00ecnh MariaDB galera cluster ho\u00e0n t\u1ea5t t\u1ea1i \u0111\u00e2y. C\u00e1c v\u1ea5n \u0111\u1ec1 li\u00ean quan \u0111\u1ebfn vi\u1ec7c\u00a0 cluster, m\u1edf r\u1ed9ng cluster s\u1ebd \u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y trong c\u00e1c b\u00e0i sau.<\/p>\n","protected":false},"excerpt":{"rendered":"
MariaDB Galera l\u00e0 g\u00ec? MariaDB Galera l\u00e0 c\u1ee5m m\u00e1y ch\u1ee7 \u0111\u1ed3ng b\u1ed9 cho MariaDB.\u00a0N\u00f3 ch\u1ec9 kh\u1ea3 d\u1ee5ng tr\u00ean Linux v\u00e0 ch\u1ec9 h\u1ed7 tr\u1ee3 c\u00e1c\u00a0c\u00f4ng c\u1ee5 l\u01b0u tr\u1eef\u00a0XtraDB \/ InnoDB. \u0110\u1eb7c tr\u01b0ng Synchronous replication C\u1ea5u tr\u00fac li\u00ean k\u1ebft Active-active multi-master \u0110\u1ecdc v\u00e0 ghi v\u00e0o b\u1ea5t k\u1ef3 node server Ki\u1ec3m so\u00e1t c\u00e1c node t\u1ef1 \u0111\u1ed9ng, c\u00e1c node […]<\/p>\n","protected":false},"author":11,"featured_media":16424,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"tags":[],"ht_kb_category":[5156],"class_list":["post-4163","ht_kb","type-ht_kb","status-publish","format-standard","has-post-thumbnail","hentry","ht_kb_category-mariadb"],"_links":{"self":[{"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/ht_kb\/4163","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/ht_kb"}],"about":[{"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/comments?post=4163"}],"version-history":[{"count":0,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/ht_kb\/4163\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/media\/16424"}],"wp:attachment":[{"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/media?parent=4163"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/tags?post=4163"},{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/ht_kb_category?post=4163"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"galera_small\"](\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2020\/02\/img_5e5476821ee5c.png\" "\\"galera_small\\"")
<\/p>\n