gistfile1.txt

2021-05-15 todo list for mysql -> mariadb migration

setup
x prod: apt update packages
x prod: reboot
x prod deal with anything if didn't come up clean
x run an ansible deploy just to see it run - ansible broken
    <pushcx>     "msg": "Failed to set permissions on the temporary files Ansible needs to create when becoming an unprivileged user (rc: 1, err: chmod: invalid mode: ‘+a’\nTry 'chmod --help' for more information.\n}). For information on working around this, see https://docs.ansible.com/ansible/become.html#becoming-an-unprivileged-user"
    <pushcx> this is the 'git clone' step in the playbook - goes away if I comment out the 'become' and 'become_user' directives, but then the next step that uses them fails
- creating a virtualenv and using pip3 to install ansible worked, must be something busted in arch's ansible

db migration:

x DO: create droplet for mariadb, db01
x ensure I can ssh to db01
x apt update & upgrade db01, reboot
x ansible config for mariadb
x db01: permit db connection only from web01
x web01: check can connect to mariadb; external can't
x mysqldump DO prod db
x restore to db01
x check db exists
x put prod into read-only
x mysqldump DO prod db
x restore to db01 (takes ~21m)
x update prod database.config to point db01
x prod: bounce puma to use new config
x uncomment traffichelper
x uncomment replies
x fix perms on replying_comments
x exit read-only
x remove note about read-only
x git commit traffichelper/replies reversions

maybe also today:

  rm tarsnap for restic
  logrotate