Ubuntu 20.04

Notes about the setup of new m5 servers built on Ubuntu 20.04 

Add an extra disk

mkfs.ext4 "/dev/disk/by-id/scsi-0Linode_Volume_m5p1extra"

mkdir "/mnt/m5p1extra"

mount "/dev/disk/by-id/scsi-0Linode_Volume_m5p1extra" "/mnt/m5p1extra"

/dev/disk/by-id/scsi-0Linode_Volume_m5p1extra /mnt/m5p1extra ext4 defaults,noatime,nofail 0 2

MySQL

Set location of log files

In /etc/mysql/mysql.conf.d/mysqld.cnf

log_bin                 = /mnt/m5p1extra/mysql/mysql-bin.log

Storing mysql replication log files in a non-standard location

Storing mysql replication log files in a non-standard location requires this:

vi /etc/apparmor.d/usr.sbin.mysqld

# Radu: allow replication files access on Linode extra volume

 /mnt/m5p1extra/mysql/ r,

 /mnt/m5p1extra/mysql/** rw,

systemctl restart apparmor

service mysql restart