gprel

README

gprel

Golang Purge RElay Logs
inspired by https://github.com/yoshinorim/mha4mysql-node/blob/master/bin/purge_relay_logs

Motivation

I'm using orchestrator to achieve MySQL HA.
Pseudo-GTID may not exist in relay-log when orchestrator uses relay-log, so I want set relay_log_purge=0 and purge relay-log.
I made this tool to purge the relaylog safely, leaving the Pseudo-GTID.

License

MIT

Author

Motoaki Nishikawa (a.k.a. ichirin2501)

Documentation

Index

• type Configuration
  • func ParseOptions(args []string) (*Configuration, error)
• type Purger
  • func NewPurger(db *sqlx.DB, delay int, dryRun bool) *Purger
  • func (p *Purger) HasPurgePrivilege(ctx context.Context) (bool, error)
  • func (p *Purger) Purge(ctx context.Context) error

Types

type Configuration

type Configuration struct {
	Host              string
	Socket            string
	User              string
	Password          string
	Port              int
	DatabaseName      string
	PurgeDelaySeconds int
	ShowVersion       bool
	DryRun            bool
}

func ParseOptions

func ParseOptions(args []string) (*Configuration, error)

type Purger

type Purger struct {
	DelaySeconds int
	DryRun       bool
	// contains filtered or unexported fields
}

func NewPurger

func NewPurger(db *sqlx.DB, delay int, dryRun bool) *Purger

func (*Purger) HasPurgePrivilege

func (p *Purger) HasPurgePrivilege(ctx context.Context) (bool, error)

func (*Purger) Purge

func (p *Purger) Purge(ctx context.Context) error