Skip to content

Instantly share code, notes, and snippets.

@fnordbar
Created August 15, 2018 13:44
Show Gist options
  • Save fnordbar/e7ccfbf6eb7662b0932f0cb344316123 to your computer and use it in GitHub Desktop.
Save fnordbar/e7ccfbf6eb7662b0932f0cb344316123 to your computer and use it in GitHub Desktop.
Systemd service file for pt-slave-delay - https://github.com/percona/percona-toolkit
[Unit]
Description = pt-slave-delay 12h delay
After=syslog.target mysql.service
Requires=mysql.service
[Service]
Type = simple
PIDFile = /var/run/ptslavedelay.pid
ExecStartPre = /usr/bin/mysql --defaults-extra-file=/root/.my.cnf -e 'start slave; select sleep(3);'
ExecStart = /usr/bin/pt-slave-delay --daemonize --pid=/var/run/ptslavedelay.pid --nocontinue --delay 12h --defaults-file=/root/.my.cnf localhost
ExecStopPost = /usr/bin/mysql --defaults-extra-file=/root/.my.cnf -e 'stop slave;'
Restart=on-abort
[Install]
WantedBy=multi-user.target
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment