=========== DataX ==========
[1]获取阿里巴巴的 datax.tar.gz
其次,获取python2.7
[2]本地有 mysql postgresql 做实验
[3] 执行命令
python datax.py D:\xdata\test\mysql2mysql.json
注:datax.py位于已经下载的datax目录的bin中。
同步类型
mysql2mysql.json
pg2mysql.json
pg2pg.json
==================mysql2mysql.json=========[start]=========
{
"job": {
"content": [{
"reader": {
"name": "mysqlreader",
"parameter": {
"column": ["*"],
"connection": [{
"jdbcUrl": ["jdbc:mysql://localhost:3306/abc?useUnicode=true&characterEncoding=utf8"],
"table": ["company"]
}],
"password": "admin",
"username": "root"
}
},
"writer": {
"name": "mysqlwriter",
"parameter": {
"writeMode": "insert",
"password": "admin",
"username": "root",
"column": [
"*"
],
"session": [
"set session sql_mode='ANSI'"
],
"preSql": [
"truncate company2"
],
"connection": [{
"jdbcUrl": "jdbc:mysql://localhost:3306/abc?useUnicode=true&characterEncoding=utf8",
"table": ["company2"]
}]
}
}
}],
"setting": {
"speed": {
"channel": "2"
}
}
}
}
==================mysql2mysql.json=========[end]=========
==================pg2mysql.json=========[start]=========
{
"job": {
"content": [{
"reader": {
"name": "postgresqlreader",
"parameter": {
"column": ["*"],
"connection": [{
"jdbcUrl": ["jdbc:postgresql://127.0.0.1:5432/ABC"],
"table": ["company"]
}],
"password": "admin",
"username": "admin"
}
},
"writer": {
"name": "mysqlwriter",
"parameter": {
"username": "root",
"password": "admin",
"column": ["id","name","age","address","salary"],
"connection": [{
"jdbcUrl": "jdbc:mysql://localhost/abc",
"table": ["company"]
}]
}
}
}],
"setting": {
"speed": {
"channel": "2"
}
}
}
}
==================pg2mysql.json=========[end]=========
==================pg2pg.json=========[start]=========
{
"job": {
"content": [{
"reader": {
"name": "postgresqlreader",
"parameter": {
"column": ["*"],
"connection": [{
"jdbcUrl": ["jdbc:postgresql://127.0.0.1:5432/ABC"],
"table": ["company"]
}],
"password": "admin",
"username": "admin"
}
},
"writer": {
"name": "postgresqlwriter",
"parameter": {
"username": "admin",
"password": "admin",
"column": ["*"],
"connection": [{
"jdbcUrl": "jdbc:postgresql://127.0.0.1:5432/ABC",
"table": ["company2"]
}]
}
}
}],
"setting": {
"speed": {
"channel": "2"
}
}
}
}
==================pg2pg.json=========[end]=========