基本使用datax 将数据从mysql转入postgresql

1、安装jdk

[root@Antiy47 ~]# mkdir /usr/local/java
[root@Antiy47 ~]# tar zxvf jdk-8u211-linux-x64.tar.gz -C /usr/local/java
[root@Antiy47 ~]# rpm -e --nodeps `rpm -qa | grep java `
[root@Antiy47 ~]# alternatives --install /usr/bin/java  java  /usr/local/java/jdk1.8.0_211/bin/java  300
[root@Antiy47 ~]# alternatives --config java

2、安装mvn

[root@Antiy47 ~]# tar zxvf apache-maven-3.6.1-bin.tar.gz -C /opt
[root@Antiy47 ~]# vim /etc/profile
export JAVA_HOME=/usr/local/java/jdk1.8.0_211
export JRE_HOME=/usr/local/java/jdk1.8.0_211/jre
export PATH=$PATH:$JAVA_HOME/bin:$JRE_HOME/bin
export CLASSPATH=$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jar:$JRE_HOME/lib
export MAVEN_HOME=/opt/apache-maven-3.6.1/
export PATH=$PATH:$JAVA_HOME/bin:$JRE_HOME/bin:$MAVEN_HOME/bin
[root@Antiy47 ~]# java -version
java version "1.8.0_171"
Java(TM) SE Runtime Environment (build 1.8.0_171-b11)
Java HotSpot(TM) 64-Bit Server VM (build 25.171-b11, mixed mode)
[root@Antiy47 ~]# mvn -version
Apache Maven 3.6.1 (d66c9c0b3152b2e69ee9bac180bb8fcc8e6af555; 2019-04-05T03:00:29+08:00)
Maven home: /opt/apache-maven-3.6.1
Java version: 1.8.0_211, vendor: Oracle Corporation, runtime: /usr/local/java/jdk1.8.0_211/jre
Default locale: en_US, platform encoding: UTF-8
OS name: "linux", version: "4.11.6-1.el6.elrepo.x86_64", arch: "amd64", family: "unix"

3、安装驱动

[root@Antiy47 ~]# rpm -ivh mysql-connector-java-8.0.16-1.el7.noarch.rpm 
[root@Antiy47 ~]# cp postgresql-42.2.5.jar /usr/local/java/jdk1.8.0_211/lib/

4、安装datax

[root@Antiy47 ~]# tar zxvf datax.tar.gz -C /opt/

5、测试datax

[root@Antiy47 ~]# cd /opt/datax/bin
[root@Antiy47 ~]# python datax.py ../job/job.json
最后返回
2019-06-14 00:09:44.149 [job-0] INFO  StandAloneJobContainerCommunicator - Total 100000 records, 2600000 bytes | Speed 253.91KB/s, 10000 records/s | Error 0 records, 0 bytes |  All Task WaitWriterTime 0.022s |  All Task WaitReaderTime 0.036s | Percentage 100.00%
2019-06-14 00:09:44.149 [job-0] INFO  JobContainer - 
任务启动时刻                    : 2019-06-14 00:09:34
任务结束时刻                    : 2019-06-14 00:09:44
任务总计耗时                    :                 10s
任务平均流量                    :          253.91KB/s
记录写入速度                    :          10000rec/s
读出记录总数                    :              100000
读写失败总数                    :                   0