Skip to content

Can gh-ost be safely run in parallel ? #448

@aadant

Description

@aadant

I am testing gh-ost in parallel on 2 big tables using --test-on-replica

I get this :

2017/07/16 20:54:18 binlogsyncer.go:568: [info] rotate to (binary.007954, 928158623)
2017-07-16 20:54:18 INFO rotate to next log name: binary.007954
[MySQL] 2017/07/16 20:54:18 statement.go:27: Invalid Connection
[MySQL] 2017/07/16 20:54:19 statement.go:27: Invalid Connection
2017/07/16 20:54:19 binlogsyncer.go:535: [info] receive EOF packet, retry ReadPacket
2017/07/16 20:54:19 binlogsyncer.go:490: [error] connection was bad
2017/07/16 20:54:20 binlogsyncer.go:452: [info] begin to re-sync from (binary.007954, 942446687)
2017/07/16 20:54:20 binlogsyncer.go:134: [info] register slave for master server mysql-dw01:3306
2017/07/16 20:54:20 binlogsyncer.go:568: [info] rotate to (binary.007954, 942446687)
2017-07-16 20:54:20 INFO rotate to next log name: binary.007954
2017/07/16 20:54:22 binlogsyncer.go:535: [info] receive EOF packet, retry ReadPacket
2017/07/16 20:54:22 binlogsyncer.go:490: [error] connection was bad
[MySQL] 2017/07/16 20:54:22 statement.go:27: Invalid Connection
2017/07/16 20:54:23 binlogsyncer.go:452: [info] begin to re-sync from (binary.007954, 959927496)
2017/07/16 20:54:23 binlogsyncer.go:134: [info] register slave for master server mysql-dw01:3306
2017/07/16 20:54:23 binlogsyncer.go:568: [info] rotate to (binary.007954, 959927496)
2017-07-16 20:54:23 INFO rotate to next log name: binary.007954
[MySQL] 2017/07/16 20:54:24 statement.go:27: Invalid Connection
2017/07/16 20:54:25 binlogsyncer.go:535: [info] receive EOF packet, retry ReadPacket
2017/07/16 20:54:25 binlogsyncer.go:490: [error] connection was bad
2017/07/16 20:54:26 binlogsyncer.go:452: [info] begin to re-sync from (binary.007954, 977717890)
2017/07/16 20:54:26 binlogsyncer.go:134: [info] register slave for master server mysql-dw01:3306
2017/07/16 20:54:26 binlogsyncer.go:568: [info] rotate to (binary.007954, 977717890)
2017-07-16 20:54:26 INFO rotate to next log name: binary.007954
2017/07/16 20:54:27 binlogsyncer.go:535: [info] receive EOF packet, retry ReadPacke

Is it expected ?
Can gh-ost be run in parallel with several cut over files ?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions