Skip to content

a problem about mysql dump zombie process  #889

Open
@deadspacewii

Description

@deadspacewii

when i use go-mysql to sync data from mysql, it well occur Binlog Dump zombie process.how can i resolve it
image

                cfg := canal.NewDefaultConfig()
		cfg.Addr = conf.Database.Addr
		cfg.User = conf.Database.Username
		cfg.Flavor = "mysql"
		cfg.Password = conf.Database.Password
		// We only care table canal_test in test db
		cfg.Dump.TableDB = s.Rule.GetSourceDataBase()
		if conf.Database.Mysqldump != "" {
			cfg.Dump.ExecutionPath = conf.Database.Mysqldump
		}
		cfg.Dump.Tables = []string{s.Rule.GetSourceTable()}

		c, err := canal.NewCanal(cfg)
		if err != nil {
			logger.Error(fmt.Sprintf("init mysql canal fail: %s, instanceId: %s", err.Error(), s.GetInstanceId()))
			return nil, err
		}
               c.RunFrom(mysql.Position{Name: filename, Pos: uint32(pos)})

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions