[root@localhostbin]#./sync_ctrlstartstartthesync_d....startthesync_d0....Target:sync_d0isrunningwithpid143899...startok[root@localhostbin]#./sync_ctrlstatussync_d0isdown

命令启动后，没有真的启动，db_sync_short_video_oss_r2m0_d也没有打日志

drwxr-xr-x.2rootroot4096May1600:10sdaiostat_ddrwxr-xr-x.2rootroot4096May1616:28shardadmin_ddrwxr-xr-x.2rootroot4096May1617:48shardadmin_short_video_oss_20_ddrwxr-xr-x.2rootroot4096May1616:28shard_ddrwxr-xr-x.2rootroot4096May1616:28shard_short_video_oss_200_ddrwxr-xr-x.2rootroot4096May1616:28shard_short_video_oss_20b_ddrwxr-xr-x.2rootroot4096May1616:28shard_short_video_oss_20c_ddrwxr-xr-x.2rootroot4096May1616:28shard_short_video_oss_20d_ddrwxr-xr-x.2rootroot4096May1616:28shard_short_video_oss_20e_ddrwxr-xr-x.2rootroot4096May1616:28shard_short_video_oss_20f_ddrwxr-xr-x.2rootroot4096May1616:28shard_short_video_oss_210_ddrwxr-xr-x.2rootroot4096May1616:28shard_short_video_oss_211_d

可以看sync_d日志，当同步进程成功启动后，会变成db_sync_short_video_oss_r2m0_d目录，目前看日志有如下报错

May1715:42:17warningsync_d[]:[tid:143826][MetaData::loadGlobalInfo]myshard_userempty'SYNC'May1715:42:17critsync_d[]:[tid:143826][MetaData::loadSyncInfo]Unknowncolumn'area_no'in'fieldlist'May1715:45:58warningsync_d[]:[tid:143899][MetaData::loadGlobalInfo]myshard_userempty'SYNC'May1715:45:58critsync_d[]:[tid:143899][MetaData::loadSyncInfo]Unknowncolumn'area_no'in'fieldlist'

说缺少了一个叫area_no的字段，这个需要在sync_server表多加入一个字段

altertablemyshard_sync_serveraddarea_noint(11)DEFAULT1;

同时在myshard.xml上的area字段，也改为1，这个表示区域号，美洲区，欧洲区，亚洲区的编号

[root@localhostsync_r1m0]#cat/data/rds/myshard/bin/myshard.xml<?xmlversion="1.0"encoding="utf-8"?><conf><businessalias="short_video_oss">short_video_oss</business><groupname="">1</group><station>0</station><area>1</area><center-mode>0</center-mode><metadata-db><ip>127.0.0.1</ip><port>6301</port><db>myshard_metadata</db><user>XXXXX</user><pass>XXXXXX</pass></metadata-db><metadata-db-backup><ip>127.0.0.1</ip><port>6301</port><db>myshard_metadata</db><user>XXXXXX</user><pass>XXXXX</pass></metadata-db-backup><sync><log-expire-days>2</log-expire-days></sync></conf>

为了加载元数据，重启shard，shardadmin,sync,重启完以后，看一下重启的时间是不是刚刚，这样保证是已经成功重启的，另外所有节点都加入nc脚本，同时去看是否有人来拉取自己的数据

shard_localRead_offset1052shard_localRead_speed0shard_localRead_bytes_behind0sync_r2m0Read_offset1052sync_r2m0Read_speed0sync_r2m0Read_bytes_behind0sync_r3m0Read_offset1052sync_r3m0Read_speed0sync_r3m0Read_bytes_behind0sync_r4m0Read_offset1052sync_r4m0Read_speed0sync_r4m0Read_bytes_behind0shard_remoteRead_offset698shard_remoteRead_speed0shard_remoteRead_bytes_behind0