GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

problem about mk-table-sync

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • problem about mk-table-sync

    i posted it on Maatkit Help google group last month,but no reply.
    i hope i can find answer here .

    i have a replication mysql env , and one master (version 5.0.22-
    log) ,one slave (version 5.0.77-log)
    and i find one table has different data ,but when i use mk-table-sync
    to sync data ,i find after sync the value of checksum is same with
    before sync
    [root@OA_DB_21 ~]# mk-table-checksum h=localhost,u=root
    h=10.103.33.29,u=mkuser,p=mkuser --databases=oa_cate --
    tables=category1
    DATABASE TABLE CHUNK HOST ENGINE COUNT
    CHECKSUM TIME WAIT STAT LAG
    oa_cate category1 0 localhost MyISAM NULL
    105196059 0 0 NULL NULL
    oa_cate category1 0 10.103.33.29 MyISAM NULL
    2212111249 0 0 NULL NULL
    [root@OA_DB_21 ~]# mk-table-sync h=localhost,u=root
    h=10.103.33.29,u=mkuser,p=mkuser --databases=oa_cate --
    tables=category1 --execute --nocheck-slave
    [root@OA_DB_21 ~]# mk-table-checksum h=localhost,u=root
    h=10.103.33.29,u=mkuser,p=mkuser --databases=oa_cate --
    tables=category1
    DATABASE TABLE CHUNK HOST ENGINE COUNT
    CHECKSUM TIME WAIT STAT LAG
    oa_cate category1 0 localhost MyISAM NULL
    105196059 0 0 NULL NULL
    oa_cate category1 0 10.103.33.29 MyISAM NULL
    2212111249 0 0 NULL NULL

  • #2
    Your question is incomprehensible.

    Comment

    Working...
    X