UOS 创建kingbaseES R3 流复制.pdf

盖国强

1048

19页

3次

2021-03-12

5墨值下载

UOS系统创建kingbaseESR3主备流复制

物理流复制工作机制：

一、系统环境

1 #操作系统

2 root@kingbase‐PC:~#cat/etc/issue

3 UniontechOSServer20Enterprise\n\l

5 #数据库版本

6 prod=#selectversion();

7 version

8 ‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐

‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐

9 KingbaseV008R003C002B0180onx86_64‐unknown‐linux‐gnu,compiledbygcc

(GCC)4.1.220080704(RedHat4.1.2‐46),

10 64‐bit

12 #系统环境配置

13 root@node1:~#cat/etc/hosts

14 192.168.2.10node1

15 192.168.2.11node2

二、UOS配置ssh互信（配置root用户和数据库用户）

1 1、配置root用户ssh互信

3 1）创建密钥对（所有node）

4 root@node1:~#ssh‐keygen‐trsa

5 Generatingpublic/privatersakeypair.

6 Enterfileinwhichtosavethekey(/root/.ssh/id_rsa):

7 Createddirectory'/root/.ssh'.

8 Enterpassphrase(emptyfornopassphrase):

9 Entersamepassphraseagain:

10 Youridentificationhasbeensavedin/root/.ssh/id_rsa.

11 Yourpublickeyhasbeensavedin/root/.ssh/id_rsa.pub.

12 Thekeyfingerprintis:

13 SHA256:pSB0+TY8bLWi2ZUp+Qv8Gq3jralKK2pLVp3icf1jYXoroot@node1

14 Thekey'srandomartimageis:

15 +‐‐‐[RSA2048]‐‐‐‐+

16 |...|

17 |....|

18 |..+o.+|

19 |..o.%o=|

20 |++OSX|

21 |o+oB.o|

22 |o....E..|

23 |o....+=+|

24 |oo..o..o*+.|

25 +‐‐‐‐[SHA256]‐‐‐‐‐+

27 2）生成公钥文件

28 root@node1:~/.ssh#catid_rsa.pub>>authorized_keys

29 root@node1:~/.ssh#ls‐lh

30 总用量12K

31 ‐rw‐r‐‐r‐‐1rootroot3923月110:40authorized_keys

32 ‐rw‐‐‐‐‐‐‐1rootroot1.8K3月110:40id_rsa

33 ‐rw‐r‐‐r‐‐1rootroot3923月110:40id_rsa.pub

34 root@node1:~/.ssh#chmod600authorized_keys

36 3)将node2节点的公钥追加到authorized_keys

37 root@node2:~/.ssh#catauthorized_keys>1.txt

38 root@node2:~/.ssh#scpid_rsa.pubnode1:~/.ssh/1.txt

39 root@node1:~/.ssh#cat1.txt>>authorized_keys

41 4)查看ssh互信的公钥信息

42 root@node1:~/.ssh#catauthorized_keys

43 ssh‐rsaAAAAB3NzaC1yc2EAAAADAQABAAABAQCnOgfsxB0BHYxQgNEw3jVPSpZlE9a+N4zG

Gh/8uJ0zlqz8j4VTrB9daTfsid/JOTMKJih/wolaXOWs0gfdgnk3niC67mbtGsP16i8zwjqcd9v

V0BQZAuL/1djb0OZpXlohiHpd+6NKiYjBxEikdCOuDQ8wevS9fI2WKJT9GoV7U/X6gWc2Wb0NPa

LqrVA1vc4tuSlLS4gAqnWKYnOIxmoBnxl0iXAfC0FLOFEBBjtRItxZVOouloRKczcSvw2EYYSW/Z

qnoKa5Sp2UvFU7b1cB32TP/WqAgvS0DLyk03/jSW9mGF4JmS60QdgrCcu2lUdgEQ8cIZ2s4dlZl

559tvdVroot@node1

44 ssh‐rsaAAAAB3NzaC1yc2EAAAADAQABAAABAQC5czhceq3k54iO+Iy3Ic8r5lL+wHkvouGW

l66cFk76lUm6opNgjFHxO5u3oJXpF40QL7tPudQ+GGQL0u8a/SI7A+F3yV6lMx8TF+0VmMPPumR

uepYwDgV6JxCvQRBU/w/Fttauqp1lgxIGLrZhv0qcMxLlYf53teZj4OvsELRXKzdaDeIwy3NUFU

9k2c+GBNhH40YPE5cYFIMMTcoGzVtM0hm/uTSQmiZRZbNX6uY89nqj/zbATqEe3NRSBQFTimoKF

6gMvbpD8WiaTQj2Dpydwrg1gLANcz0FmtTYsNFkYHo5JdPuEcSRV3p5xZaMXZGmraRFKBKr6KYu

VxeLG6VNroot@node2

45 root@node1:~/.ssh#scpauthorized_keysnode2:~/.ssh

47 5）验证ssh互信

48 root@node1:~/.ssh#sshnode2

49 Welcometouos20GNU/Linux

50 *Homepage:https://www.chinauos.com/

51 *Bugreport:https://bbs.chinauos.com/

52 Lastlogin:MonMar110:35:092021from192.168.2.1

55 2、对于数据库用户ssh互信配置如root用户

56 kingbase@node1:~$sshnode2

57 Welcometouos20GNU/Linux

58 *Homepage:https://www.chinauos.com/

59 *Bugreport:https://bbs.chinauos.com/

60 Lastlogin:MonMar110:52:112021from127.0.0.1

三、查看和关闭UOS防火墙

1 root@node1:~/.ssh#systemctlstatusfirewalld.service

2 Unitfirewalld.servicecouldnotbefound.

4 root@node1:~/.ssh#iptables‐L

5 ChainINPUT(policyACCEPT)

6 targetprotoptsourcedestination

8 ChainFORWARD(policyACCEPT)

9 targetprotoptsourcedestination

11 ChainOUTPUT(policyACCEPT)

of 19

5墨值下载

kingbase

相关文档

评论