基本材料：
同一台机器，安装了MySQL8，两个库：nacos 和 datax-demo，
在nacos库新建一个视图v_datax_role_user；
在datax-demo新建一个表t_datax_role_user；
【注：使用的都是root用户】
job.json内容为：
{
"job": {
"setting": {
"speed": {
"channel": 3
},
"errorLimit": {
"record": 0,
"percentage": 0.02
}
},
"content": [
{
"reader": {
"name": "mysqlreader",
"parameter": {
"username": "nacos",
"password": "nacos",
"connection": [
{
"querySql": [
"SELECT username, password, enabled, role FROM v_datax_role_user;"
],
"jdbcUrl": [
"jdbc:mysql://127.0.0.1:3306/nacos?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true"
]
}
]
}
},
"writer": {
"name": "mysqlwriter",
"parameter": {
"writeMode": "insert",
"username": "root",
"password": "root",
"column": [
"username",
"password",
"enabled",
"role"
],
"preSql": [
"delete from t_datax_role_user"
],
"connection": [
{
"jdbcUrl": "jdbc:mysql://127.0.0.1:3306/datax-demo?useUnicode=true&characterEncoding=utf8&serverTimezoneGMT%2B8&useSSL=true&rewriteBatchedStatements=true",
"table": [
"t_datax_role_user"
]
}
]
}
}
}
]
}
}
打算将nacos 的users和role同步到 datax-demo库的t_datax_role_user，报异常了。具体错误信息为：
经DataX智能分析,该任务最可能的错误原因是:
com.alibaba.datax.common.exception.DataXException: Code:[MYSQLErrCode-02], Description:[数据库服务的IP地址或者Port错误，请检查填写的IP地址和Port或者联系DBA确认IP地址和Port是否正确。如果是同步中心用户请联系DBA确认idb上录入的IP和PORT信息和数据库的当前实际信息是一致的]. - 具体错误信息为：com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
