阿里雲Polardb國產資料庫高可用部署實踐

# 透過引數關閉大頁

echo never >   /sys/kernel/mm/transparent_hugepage/enabled

echo 'echo never > /sys/kernel/mm/transparent_hugepage/enabled'   >> /etc/rc.d/rc.local

# 驗證是否關閉了透明大頁

grep HugePages_Total  /proc/meminfo

cat /proc/sys/vm/nr_hugepages

vm.dirty_expire_centisecs=3000

net.ipv4.tcp_synack_retries=2

net.core.rmem_default=262144

vm.dirty_background_bytes=409600000

net.core.wmem_default=262144

vm.mmap_min_addr=65536

vm.overcommit_ratio=90

kernel.shmmni=819200

net.core.rmem_max=4194304

vm.dirty_writeback_centisecs=100

fs.file-max=76724600

net.core.somaxconn=4096

fs.aio-max-nr=1048576

net.ipv4.tcp_max_tw_buckets=262144

vm.swappiness=0

fs.nr_open=20480000

net.ipv4.tcp_fin_timeout=5

net.ipv4.ip_local_port_range=40000   65535

net.ipv4.tcp_keepalive_probes=3

net.ipv4.tcp_mem=8388608   12582912 16777216

kernel.shmmax = 329853488332

kernel.shmall=80530636

kernel.shmmni =   4096

kernel.msgmax =   65536

kernel.msgmni =   2005

kernel.msgmnb =   65536

kernel.sem=4096   2147483647 2147483646 512000

net.ipv4.tcp_keepalive_intvl=20

net.ipv4.tcp_keepalive_time=60

vm.overcommit_memory=0

net.ipv4.tcp_syncookies=1

net.ipv4.tcp_max_syn_backlog=4096

net.ipv4.tcp_timestamps=1

net.ipv4.tcp_rmem=8192   87380 16777216

net.ipv4.tcp_wmem=8192   65536 16777216

net.core.wmem_max=4194304

vm.dirty_ratio=80

net.core.netdev_max_backlog=10000

vm.zone_reclaim_mode=0

net.ipv4.tcp_tw_reuse=1

vm.nr_hugepages=192000

vm.nr_overcommit_hugepages=1000000

vm.overcommit_memory   = 2

* soft nofile 655360

* hard nofile   655360

* soft nproc 655360

* hard nproc 655360

* soft memlock   unlimited

* hard memlock   unlimited

* soft core   unlimited

* hard core   unlimited

-- 關閉防火牆

systemctl stop   firewalld

systemctl disable   firewalld

-- 關閉 selinux

vi /etc/selinux/config

SELINUX=disabled               -- 修改為disabled

groupadd   polardb;useradd -g polardb polardb

echo " 密碼 " | passwd polardb --stdin

#rpm -qa sudo

sudo-1.8.6p7-16.el7.x86_64

#usermod   -aG wheel polardb

# id polardb

uid=1002(polardb) gid=1005(polardb)   groups=1005(polardb),10(wheel)

polardb         ALL=(ALL)       NOPASSWD: ALL

sudo sed   -i   's/Defaults    requiretty/#Defaults    requiretty/g'   /etc/sudoers

sudo cat /etc/sudoers | grep requiretty

s udo rpm -ivh   t-polarstore-pfsd-san-1.1.41-20200830160257.alios7.x86_64.rpm

sudo rpm -ivh    PolarDB-O-0200-2.0.0-20200902034114.alios7.x86_64.rpm

1.          以 polardb 使用者登入，執行以下命令，格式化 $PFSDISK 裝置

sudo   /usr/local/bin/pfs -C disk mkfs -u 30 -l 1073741824 -f $PFSDISK

2.          等待一段時間，回顯輸出 pfs mkfs succeeds! 後，執行以下命令，啟動 PFS 服務

sudo   /usr/local/polarstore/pfsd/bin/start_pfsd.sh -p $PFSDISK

3.          執行以下命令，建立 PFS 的資料庫目錄

sudo   /usr/local/bin/pfs -C disk mkdir $PFSDIR

initdb -D $PGDATA -E UTF8 --locale=C -U polardb

sudo /usr/local/polardb_o_current/bin/polar-initdb.sh $PGDATA/ $PFSDIR/   disk

引數名

引數值

說明

vi $PGDATA/pg_hba.conf

host all all   0.0.0.0/0 md5

host replication   all 0.0.0.0/0 md5

pg_ctl start -D $PGDATA

pg_ctl stop -D   $PGDATA

psql -h$PGDATA -p$PGPOR T   -c “select 1”

psql -h$PGDATA   -p$PGPORT -c"select version()"

psql -h$PGDATA -p$PGPORT -c"create user  replicator  password ' 密碼 ' superuser; "

polar_basebackup -h< 主庫 IP> -p5432 -U replicator -D $PGDATA   --polardata=$PFSDIR --polar_storage_cluster_name=disk   --polar_disk_name=$PFSDISK --polar_host_id=2 -X stream --progress   --write-recovery-conf -v

polar_hostid = 2

polar_disk_name =   $PFSDISK

polar_datadir =   $PFSDIR

polar_storage_cluster_name   = 'disk'

pg_ctl -c start -D $PGDATA

psql -h$PGDATA   -p$PGPORT

psql -h$PGDATA -p$PGPORT -c"select * from   pg_stat_replication;"

ssh-keygen -t rsa

ssh-copy-id -i   ~/.ssh/id_rsa.pub  polardb 節點 1

ssh-copy-id -i   ~/.ssh/id_rsa.pub  polardb 節點 2

# 測試互信關係是否配置好，執行如下命令不需要輸密碼，說明互信已打通。

ssh polardb 節點 1 date;ssh polardb 節點 2 date;

rpm -ivh polardb_cluster_manager-1.0.0-1.x86_64.rpm

/usr /local/polardb_o_current/bin/createuser   -p $PGPORT -h $PGDATA --login

aurora -P -s

# 這裡密碼配置為“ 密碼 ”

mkdir -p /app/polardb_cluster_manager/ /conf

#polardb_cluster_manager.conf 檔案中新增如下內容：

vi  /app/polardb_cluster_manager/   conf/polardb_cluster_manager.conf

{

"work_mode":"PolarPure",   "consensus":{ "port":5001 },

"account_info":{   "aurora_user":"aurora",   "aurora_password":" 密碼 ",

"replica_user":"replicator",   "replica_password":" 密碼 " },

"cluster_info":{   "port":5000 } }

/usr/local/polardb_cluster_manager/bin/polardb_cluster_manager_control.py   /app/polardb_cluster_manager start

/usr/local/polardb_cluster_manager/bin/polardb_cluster_manager_control.py   /app/polardb_cluster_manager stop

/usr/local/polardb_cluster_manager/bin/polardb_cluster_manager_control.py   /app/polardb_cluster_manager status

curl -H "Content-Type:application/json" -X POST --data   "{\"user\":\"polardb\",\"dataPath\":\"/app/polardb_data\",\"ip\":\" < 主庫 IP>\",\"port\":\"5432\",\"type\":\"   Master\",\"storage_type\":\"local_ssd\",\"sync\":\"SYNC\"}   "

curl -H "Content-Type:application/json" -X POST --data   "{\"user\":\"polardb\",\"dataPath\":\"/app/polardb_data\",\"ip\":\" < 備 IP>\",\"port\":\"5432\",\"type\":\"   Standby \",\"storage_type\":\"local_ssd\",\"sync\":\"SYNC\"}"  

curl -H "Content-Type:application/json" -X POST --data   "{\"vip\":\" <VIP 地址 >\",\"mask\":\"255.255.255.0\",\"interface\":\"team0\"}   "

curl -H "Content-Type:application/json" -X POST --data   "{\"from\":\" < 主庫 IP>:5432\",\"to\":\"< 備庫 IP>:5432\"}"