sync不能成功同步
[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
声明:本站所有文章资源内容,如无特殊说明或标注,均为采集网络资源。如若本站内容侵犯了原著者的合法权益,可联系本站删除。