1、grant all on . to repl identified by '111111';
两边都创建用户,并刷新
2、我的配置文件
{
"Name":"dtle-demo",
"Tasks":[
{
"Type":"Src",
"Config":{
"Gtid":"",
"ReplicateDoDb":[
{
"TableSchema":"yappam",
"Tables":[
{
"TableName":"demo_tbl"
}
]
}
],
"ConnectionConfig":{
"Host":"192.168.0.170",
"Port":"3306",
"User":"repl",
"Password":"111111"
}
}
},
{
"Type":"Dest",
"Config":{
"ConnectionConfig":{
"Host":"192.168.0.204",
"Port":"3306",
"User":"repl",
"Password":"111111"
}
}
}
]
}
3 我的建表语句:
mysql> create table demo_tbl(
-> Id int primary key auto_increment,#部门编号 ××× 主键 自增长
-> Name varchar(18),#部门名称
-> description varchar(100)#描述
-> );
4、命令备注
创建复制任务 curl -H "Accept:application/json" -XPOST "http://127.0.0.1:8190/v1/jobs" -d @job.json -s | jq
查看作业ID curl -XGET "127.0.0.1:8190/v1/jobs" -s | jq '.[].ID'
查看作业状态 curl -XGET "127.0.0.1:8190/v1/job/7ab55a58-e1a6-a500-12e8-8a50485aa7dc" -s | jq