【Mariadb】centos7搭建mariadb Galera集群--v1.0(成功)

2019-11-08 20:49:39

字體：大中小

來源：轉載

供稿：網友

################################################################################## MariaDB群集安裝參考腳本 by johnlaw 2017-02-18 ## CentOS7+MariaDB+ galera ################################################################################一、規劃機器列表 ############################################################################################# 兩臺數據庫實現雙主1） 192.168.170.156 --> MDB012） 192.168.170.157 --> MDB02二、第一個節點安裝及配置##########################################################################################1、關閉SElinux 修改/etc/selinux/config文件中的SELINUX="" 為 disabled ，然后重啟。關閉防火墻 [root@MDB01 ~]# systemctl stop firewalld.service [root@MDB01 ~]# systemctl disable firewalld.service2、設置mariadb的yum源并安裝（所有節點都要）修改yum源文件 vi /etc/yum.repos.d/mariadb.repo--------------------------------------------------[mariadb]name = MariaDBbaseurl = http://yum.mariadb.org/10.1/centos7-amd64gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDBgpgcheck=1enabled=03、安裝數據及服務組件 [root@MDB01 ~]# yum --enablerepo=mariadb -y install MariaDB-server galera MariaDB-client rsync 4、配置第一個節點[192.168.170.156 MDB01]--1、建立Cluster使用者，密碼及用戶(現用默認root用戶，設置遠程登錄) [root@MDB01 ~]# MySQLadmin -u root flush-PRivileges passWord 'ayilian' [root@MDB01 ~]# mysql -uroot -p MariaDB [(none)]> use mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed MariaDB [mysql]> grant all privileges on *.* to root@'%' identified by 'ayilian'; [root@MDB01 ~]# vi /etc/my.cnf.d/server.cnf--2、主節點的配置文件server.cnf## * Galera-related settings#[galera]# Mandatory settingswsrep_on=ON ##開啟wsrep服務wsrep_provider=/usr/lib64/galera/libgalera_smm.so ##加入/usr/lib64/galera/libgalera_smm.sowsrep_cluster_address="gcomm://" binlog_format=rowdefault_storage_engine=InnoDBinnodb_autoinc_lock_mode=2## Allow server to accept connections on all interfaces.#bind-address=0.0.0.0## Optional setting#wsrep_slave_threads=1#innodb_flush_log_at_trx_commit=0# add follows# cluster namewsrep_cluster_name="MariaDB_Cluster"# own ip address（當前節點的IP）wsrep_node_address="192.168.170.156"wsrep_node_name='radiusone'# replication providerwsrep_sst_method=rsync--3、啟動集群：/bin/galera_new_cluster [root@MDB01 ~]# /bin/galera_new_cluster 注：（第二次啟動動用 [root@MDB01 ~]# systemctl restart mariadb）--4、確認MySQL的3306端口和wsrep的4567端口處于監聽狀態 [root@MDB01 ~]# netstat -tulpn | grep -e 4567 -e 3306 tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 2332/mysqld tcp 0 0 0.0.0.0:4567 0.0.0.0:* LISTEN 2332/mysqld 主：4567是用來同步時用的很重要。#############三、第二個節點安裝及配置其它節點 ########################################################################################## (192.168.170.157 )1、關閉SELINUX 修改/etc/selinux/config文件中的SELINUX="" 為 disabled ，然后重啟。關閉防火墻 [root@MDB02 ~]# systemctl stop firewalld.service [root@MDB02 ~]# systemctl disable firewalld.service2、設置mariadb的yum源并安裝（所有節點都要）修改yum源文件 vi /etc/yum.repos.d/mariadb.repo--------------------------------------------------[mariadb]name = MariaDBbaseurl = http://yum.mariadb.org/10.1/centos7-amd64gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDBgpgcheck=1enabled=03、安裝數據及服務組件 [root@MDB02 ~]# yum --enablerepo=mariadb -y install MariaDB-server galera MariaDB-client rsync 4、配置第一個節點[192.168.170.156 MDB01]--1、建立Cluster使用者，密碼及用戶(現用默認root用戶，設置遠程登錄) [root@MDB02 ~]# mysqladmin -u root flush-privileges password 'ayilian' [root@MDB02 ~]# mysql -uroot -p MariaDB [(none)]> use mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed MariaDB [mysql]> grant all privileges on *.* to root@'%' identified by 'ayilian'; [root@MDB02 ~]# vi /etc/my.cnf.d/server.cnf--2、從節點的配置文件server.cnf[mysqld]## * Galera-related settings#[galera]# Mandatory settingswsrep_on=ON ##開啟動wsrep功能 wsrep_provider=/usr/lib64/galera/libgalera_smm.sowsrep_cluster_address="gcomm://192.168.170.156:4567" ##配置指向主節點，端口很重要 4567binlog_format=rowdefault_storage_engine=InnoDBinnodb_autoinc_lock_mode=2## Allow server to accept connections on all interfaces.#bind-address=0.0.0.0## Optional setting#wsrep_slave_threads=1#innodb_flush_log_at_trx_commit=0# add follows# cluster namewsrep_cluster_name="MariaDB_Cluster"# own IP address（當前節點的主機名和IP）wsrep_node_name='mdb02'wsrep_node_address="192.168.170.157"# replication providerwsrep_sst_method=rsyncwsrep_sst_auth=root:ayilian# this is only for embedded server[embedded]--3、啟動集群數據庫 [root@MDB02 ~]# systemctl restart mariadb--4、確認MySQL的3306端口和wsrep的4567端口處于監聽狀態 [root@MDB02 ~]# netstat -tulpn | grep -e 4567 -e 3306 tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 2332/mysqld tcp 0 0 0.0.0.0:4567 0.0.0.0:* LISTEN 2332/mysqld 三、其它節點同第二節點安裝一樣 ################################################################################ 以下非常重要 wsrep_cluster_address="gcomm://192.168.170.156:4567" ##配置指向主節點，端口很重要 4567四、測試集群狀態 ################################################################################登錄兩個節點測試[root@MDB02 ~]# mysql -uroot -pMariaDB [(none)]> show status like 'wsrep%';如果 "wsrep_local_state_comment" is "Synced" 則表明集群創建成功MariaDB [(none)]> show status like 'wsrep%';+------------------------------+-------------------------------------------+| Variable_name | Value |+------------------------------+-------------------------------------------+| wsrep_apply_oooe | 0.000000 || wsrep_apply_oool | 0.000000 || wsrep_apply_window | 1.000000 || wsrep_causal_reads | 0 || wsrep_cert_deps_distance | 2.000000 || wsrep_cert_index_size | 5 || wsrep_cert_interval | 0.000000 || wsrep_cluster_conf_id | 2 || wsrep_cluster_size | 2 || wsrep_cluster_state_uuid | d10b0988-ed49-11e6-bbb5-163b5f87c5a0 || wsrep_cluster_status | Primary || wsrep_commit_oooe | 0.000000 || wsrep_commit_oool | 0.000000 || wsrep_commit_window | 1.000000 || wsrep_connected | ON || wsrep_desync_count | 0 || wsrep_evs_delayed | || wsrep_evs_evict_list | || wsrep_evs_repl_latency | 0/0/0/0/0 || wsrep_evs_state | OperaTIONAL || wsrep_flow_control_paused | 0.000000 || wsrep_flow_control_paused_ns | 0 || wsrep_flow_control_recv | 0 || wsrep_flow_control_sent | 0 || wsrep_gcomm_uuid | 02e43ded-ee6b-11e6-a0bf-83c5163e6ed3 || wsrep_incoming_addresses | 192.168.170.157:3306,192.168.170.156:3306 || wsrep_last_committed | 13 || wsrep_local_bf_aborts | 0 || wsrep_local_cached_downto | 11 || wsrep_local_cert_failures | 0 || wsrep_local_commits | 1 || wsrep_local_index | 0 || wsrep_local_recv_queue | 0 || wsrep_local_recv_queue_avg | 0.000000 || wsrep_local_recv_queue_max | 1 || wsrep_local_recv_queue_min | 0 || wsrep_local_replays | 0 || wsrep_local_send_queue | 0 || wsrep_local_send_queue_avg | 0.000000 || wsrep_local_send_queue_max | 1 || wsrep_local_send_queue_min | 0 || wsrep_local_state | 4 || wsrep_local_state_comment | Synced || wsrep_local_state_uuid | d10b0988-ed49-11e6-bbb5-163b5f87c5a0 || wsrep_protocol_version | 7 || wsrep_provider_name | Galera || wsrep_provider_vendor | Codership Oy <info@codership.com> || wsrep_provider_version | 25.3.19(r3667) || wsrep_ready | ON || wsrep_received | 5 || wsrep_received_bytes | 648 || wsrep_repl_data_bytes | 99 || wsrep_repl_keys | 3 || wsrep_repl_keys_bytes | 47 || wsrep_repl_other_bytes | 0 || wsrep_replicated | 1 || wsrep_replicated_bytes | 210 || wsrep_thread_count | 2 |+------------------------------+-------------------------------------------+

上一篇：完全刪除oracle辦法

下一篇：WM_CONCAT字符超過4000的處理辦法