On 15/8/2016 (happy birthday!), we are trying to put the FS standabye servers in production as a test.
Linux Mysql DB
Get the mysql databases of the Linux server from the replica ({{backup3.bluelightav.org}} (around 5 minutes):
root@backup3.bluelightav:~# mysqldump --defaults-file=/root/.my.cnf.d/mysqld2.cnf --all-databases | gzip > /tmp/fs.2016.08.15.sql.gzip -- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.
Get that file on a FAT USB drive (adapt, around 5 minutes with Aurinoco's link at around 4MB/s):
phil@phil-mbp:~$ scp root@backup3.bluelightav.org:/tmp/fs.2016.08.15.sql.gzip /Volumes/MULTISYSTEM/tmp
On the spare Linux server, get the dump file (from the USB stick). Adapt accordingly, eg the device name. Duration: 35 minutes on the i3 CPU BL spare machine.
# Mount the USB drive mkdir -p /mnt/usb ; mount /dev/sdb1 /mnt/usb # Copy the file in the filesystem cp /mnt/usb/tmp/fs.2016.08.15.sql.gzip /tmp # Unzip it cd /tmp gunzip fs.2016.08.15.sql.gzip # Import mysql < fs.2016.08.15.sql