My collected scripts for which no extra repository is worth it. Mostly in Perl. Maybe they'll help you. Use at your own risk
🚨🚨🚨 No warranty or support! 🚨🚨🚨
check_replication_status.sh- Check MySQL 8.0 replication status and send email on errorcheck_replication_status_hc.sh- Check MySQL 8.0 replication status and ping healthchecks.io
Used in Ansible Playbook:
# Check MySQL 8.0 replication and ping to healthchecks.io - name: Script - Check status and ping healthchecks.io ansible.builtin.get_url: url: https://raw.githubusercontent.com/Cyclenerd/toolbox/master/check_replication_status_hc.sh dest: /root/check_replication_status_hc.sh mode: '0755' owner: root group: root - name: Script - Change healthchecks.io UUID ansible.builtin.lineinfile: path: /root/check_replication_status_hc.sh regexp: '^MY_HC_ID' line: "MY_HC_ID='{{ healthchecks_uuid }}'"Download & Update:
curl -O "https://raw.githubusercontent.com/Cyclenerd/toolbox/master/check_replication_status_hc.sh"xtradir.sh- Runxtrabackupand save either in folder[NUMBER]Aor[NUMBER]B.xtracloud.sh- Backup to S3 Bucket withxtrabackupandxbcloud.
Used in Ansible Playbook:
- name: XtraBackup - Download script ansible.builtin.get_url: url: https://raw.githubusercontent.com/Cyclenerd/toolbox/master/xtradir.sh dest: /root/xtradir.sh mode: '0755' owner: root group: root - name: XtraBackup - Change MY_DIR in script ansible.builtin.lineinfile: path: /root/xtradir.sh regexp: '^MY_DIR' line: "MY_DIR={{ mysql_backup_dir }}"mydumper.sh- Runmydumperand save either in folder[NUMBER]Aor[NUMBER]B.
Used in Ansible Playbook:
- name: MyDumper - Download script ansible.builtin.get_url: url: https://raw.githubusercontent.com/Cyclenerd/toolbox/master/mydumper.sh dest: /root/mydumper.sh mode: '0755' owner: root group: root - name: MyDumper - Change MY_DIR in script ansible.builtin.lineinfile: path: /root/mydumper.sh regexp: '^MY_DIR' line: "MY_DIR={{ mysql_backup_dir }}"GNU Public License version 3. Please feel free to fork and modify this on GitHub (https://github.com/Cyclenerd/toolbox).