LightDB 客户端工具安装

背景介绍

实现一个客户端包（zip绿色包），绿色包解压配置环境变量后，用户可以直接使用相关的工具。从LightDB 23.2版本开始，LightDB-X和LightDB-A提供了客户端zip包。

zip包需要在linux环境下解压。

LightDB-X-Client 安装

1. 将LightDB-X client安装包拷贝到服务器的安装目录下，对于本文档演示所用的范例来说安装包是lightdb-x-client-13.8-23.2-12177-el7.x86_64.zip，安装目录是 /root。

[root@localhost ~]# ls
anaconda-ks.cfg  Desktop  Documents  Downloads  lightdb-x-client-13.8-23.2-12177-el7.x86_64.zip  Music  original-ks.cfg  Pictures  Public  Templates  Videos
[root@localhost ~]#
[root@localhost ~]# pwd
/root
[root@localhost ~]#

2. 解压LightDB-X client安装包。

[root@localhost ~]# unzip lightdb-x-client-13.8-23.2-12177-el7.x86_64.zip
Archive:  lightdb-x-client-13.8-23.2-12177-el7.x86_64.zip
   creating: lightdb-x-client-13.8-23.2-12177-el7.x86_64/
   creating: lightdb-x-client-13.8-23.2-12177-el7.x86_64/bin/
  inflating: lightdb-x-client-13.8-23.2-12177-el7.x86_64/bin/lt_distributed_probackup.py
  inflating: lightdb-x-client-13.8-23.2-12177-el7.x86_64/bin/lt_distributed_dump.py
  inflating: lightdb-x-client-13.8-23.2-12177-el7.x86_64/bin/lt_distributed_restore.py
  inflating: lightdb-x-client-13.8-23.2-12177-el7.x86_64/bin/ltlog.py
  inflating: lightdb-x-client-13.8-23.2-12177-el7.x86_64/bin/base.py
  inflating: lightdb-x-client-13.8-23.2-12177-el7.x86_64/bin/ltuldr
  inflating: lightdb-x-client-13.8-23.2-12177-el7.x86_64/bin/lt_basebackup

3. cd到LightDB-X client解压后生成的目录中，本例中就是lightdb-x-client-13.8-23.2-12177-el7.x86_64目录，bin目录中存放的就是客户能够使用的脚本和可执行文件，lib目录存放的是被依赖的so文件。

[root@localhost ~]# ls lightdb-x-client-13.8-23.2-12177-el7.x86_64
bin  lib
[root@localhost ~]#

4. 使用bin中提供的lt_distributed_dump.py、lt_distributed_restore.py、lt_distributed_probackup.py脚本，依赖python3，如果本地没有安装，则需要安装python3环境。

	# centos7默认不安装，执行下面的命令安装python3
	sudo yum install -y python3

5. 配置环境变量。

	export LTHOME=/root/lightdb-x-client-13.8-23.2-12177-el7.x86_64
	export PATH=${LTHOME}/bin:${PATH}
	export LD_LIBRARY_PATH=${LTHOME}/lib:${LD_LIBRARY_PATH}

6. 以上步骤都执行成功，则LightDB-X client安装成功。

LightDB-A-Client 安装

1. 目前LightDB-A数据库服务端只有CentOS7版本，所以LightDB-A的客户端也只有CentOS7版本。
2. 将LightDB-A client安装包拷贝到服务器的安装目录下，对于本文档演示所用的范例来说安装包是lightdb-a-client-23.2-12178-el7.x86_64.zip，安装目录是 /root。

	[root@localhost ~]# ls
	anaconda-ks.cfg  Desktop  Documents  Downloads  lightdb-a-client-23.2-12178-el7.x86_64.zip  Music  original-ks.cfg  Pictures  Public  Templates  Videos
	[root@localhost ~]#
	[root@localhost ~]# pwd
	/root
	[root@localhost ~]#

3. 解压LightDB-A client安装包。

	[root@localhost ~]# unzip lightdb-a-client-23.2-12178-el7.x86_64.zip
	Archive:  lightdb-a-client-23.2-12178-el7.x86_64.zip
	   creating: lightdb-a-client-23.2-12178-el7.x86_64/
	   creating: lightdb-a-client-23.2-12178-el7.x86_64/bin/
	  inflating: lightdb-a-client-23.2-12178-el7.x86_64/bin/psql
	  inflating: lightdb-a-client-23.2-12178-el7.x86_64/bin/pg_restore
	  inflating: lightdb-a-client-23.2-12178-el7.x86_64/bin/pg_dumpall
	  inflating: lightdb-a-client-23.2-12178-el7.x86_64/bin/pg_dump
	  inflating: lightdb-a-client-23.2-12178-el7.x86_64/bin/gpfdist
	  inflating: lightdb-a-client-23.2-12178-el7.x86_64/bin/gpload.py
	  inflating: lightdb-a-client-23.2-12178-el7.x86_64/bin/pg_config
	   creating: lightdb-a-client-23.2-12178-el7.x86_64/lib/
	    linking: lightdb-a-client-23.2-12178-el7.x86_64/lib/libpq.so  -> libpq.so.5.12
	    linking: lightdb-a-client-23.2-12178-el7.x86_64/lib/libpq.so.5  -> libpq.so.5.12
	  inflating: lightdb-a-client-23.2-12178-el7.x86_64/lib/libpq.so.5.12

4. cd到LightDB-A client解压后生成的目录中，本例中就是lightdb-a-client-23.2-12178-el7.x86_64目录，bin目录中存放的就是客户能够使用的脚本和可执行文件，lib目录存放的是被依赖的so文件，include是依赖的头文件。

	[root@localhost ~]# ls lightdb-a-client-23.2-12178-el7.x86_64
	bin  include  lib
	[root@localhost ~]#

5. 配置环境变量。

  export GPHOME=/root/lightdb-a-client-23.2-12178-el7.x86_64
  export PATH=${GPHOME}/bin:${PATH}
  export LD_LIBRARY_PATH=${GPHOME}/lib:${LD_LIBRARY_PATH}
  export PYTHONPATH=${GPHOME}/lib/python:${PYTHONPATH}

6. 安装依赖包。

  sudo yum install -y epel-release
  sudo yum install -y python3 python3-pip python3-devel
  sudo yum install -y apr libzstd
  
  tee python-dependencies.txt <<-'EOF'
  psutil==5.7.0
  pygresql==5.2
  pyyaml==5.3.1
  EOF
  

  pip3 install -r python-dependencies.txt --user  \
     -i http://yum.hundsun.com/mirrors/pypi/simple/ \
     --trusted-host yum.hundsun.com

7. 以上步骤都执行成功，则LightDB-A client安装成功。