DataX支持MySQL-8读写

1、mysqlwrite模块

1.1、修改pom

如果只用到了mysql的写，可以只修改mysqlwriter目录下的pom文件

		<dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
<!--            <version>${mysql.driver.version}</version>-->
			<version>8.0.28</version>
        </dependency>

2、修改DataBaseType

2.1、打开DataBaseType类

vi plugin-rdbms-util/src/main/java/com/alibaba/datax/plugin/rdbms/util/DataBaseType.java

2.2、全文替换

:%s/convertToNull/CONVERT_TO_NULL/

2.3、修改jdbc驱动的名称

com.mysql.jdbc.Driver 为 com.mysql.cj.jdbc.Driver

plugin-rdbms-util/src/main/java/com/alibaba/datax/plugin/rdbms/util/DataBaseType.java

adswriter/src/main/java/com/alibaba/datax/plugin/writer/adswriter/load/AdsHelper.java

3、编译打包

打包成功后，查看datax/plugin/writer/mysqlwriter/libs/，已经包含新版的驱动jar包

mvn -U clean package assembly:assembly -Dmaven.test.skip=true

4、mysql-jdbc连接

"jdbcUrl":"jdbc:mysql://ip:port/test?useUnicode=true&characterEncoding=UTF-8&useSSL=false",