UBC Physics & Astronomy
tau-rhel01.phas.ubc.ca
142.103.236.6 (PUBLIC)

Machine Type: Virtual Host

System Info

  

RHEL6 Virtual Networking Setup

Disaster Recovery MySQL Backups Using ZRM

11-03-10
. 
yum install phpmyadmin

ALL CONTENT BELOW HERE NEEDS UPDATING

11-02-02
Turned off iptables - control all access through FWSM.
bacula-5.0.2 installed 




mod_evasive installed












FIX

Installed RAID monitoring Software (
ServeRAID MR Support CD)



cd /usr/local/src
mount -o loop ibm_sw_sraidmr_10.35_anyos_32-64.iso /mnt/iso
yum install libXp
yum install net-snmp
cd /mnt/iso/MSM/Linux/
./install.sh 
[root@omega Linux]# rpm -qa | grep -i mega
MegaRAID_Storage_Manager-2.91-03














YYY home





-















ZZZ home



-










 

NOTES:

passwd, shadow, group files:
  rsync'd from alpha hourly via /etc/cron.hourly/passwd

/www:
  samba shared (/var/httpd/htdocs only to trek/ada2)

WWW STATS 



After editing httpd.conf, run the 
apachectl configtest
to test your config.



RSYNC info:



[root@www sysadmin]# 
crontab -l

-





09-06-26
Ran UpdateXpress:

[root@omega]# cd /opt/sysadmin/IBM/UpdateXpress
[root@omega UpdateXpress]# ./uxspi300.rhel5 &

(1) Broadcom BNX2 RHEL5 Driver
	Name: Broadcom BNX2 RHEL5 Driver
	New Version: 	bnx2-1.8.2b
	Reboot: 	Reboot Required to take effect
	Status: 	Successfully Installed

(2) IBM and LSI Basic or Integrated RAID SAS Controller Driver
	Name: IBM and LSI Basic or Integrated RAID SAS Controller Driver
	New Version: 	4.16.80.01
	Reboot: 	Reboot Required to take effect
	Status: 	Successfully Installed


Installed phpMyAdmin


- 





  
    

      DISASTER RECOVERY

      
    
        
  1. Install a new server.
    2. 
        
  2. Load RHEL V5. 
    3. 
      

Additional, non-critical items to take care of:

      
    
        
  1. Install APCUPSD
    2. 
        
  2. Check webalizer installation (web stats).
    3. 
      

      		
    

  





  
    

      DISASTER RECOVERY

      
    
        
  1. Install a new server.
    2. 
        
  2. Load RHEL V5  (or newer).
    3. 
        
  3. Make sure you select to install the web server and associated modules.
    4. 
        
  4. Make sure you select to install the mysql server and associated modules.
    5. 
        
  5. Copy over backup files from alpha:/home/backups/www (these files are rsync'd daily).
    6. 
        
  6. Make sure mysqld and httpd are started.
    7. 
        
  7. Make sure to set a root password for mysqld (admin -u root password newpassword).
    8. 
        
  8. Install phpMyAdmin. Create phpMyAdmin dbases: mysql -u root -p < create_tables_mysql_4_1_2+.sql
    9. 
        
  9. Install php-mbstring package from redhat network package archive so phpMyAdmin doesn't complain.
    10. 
        
  10. Get include files installed into /php/includes.
    11. 
        
  11. Check /etc/php.ini configuration file.
    12. 
        
  12. Check /etc/http/conf configuration files including certificate files.
          
    /etc/http/conf/ssl.crt/www.phas.ubc.ca.crt
               /etc/http/conf/ssl.crt/gd_bundle.crt
               /etc/http/conf/ssl.key/www.phas.ubc.ca.key
          
    
        
    13. 
        
  13. Install MySQL-zrm.
    14. 
      

Additional, non-critical items to take care of:

      
    
        
  1. Install APCUPSD
    2. 
        
  2. Check webalizer installation (web stats).
    3. 
      

      		
    

  









MySQL Backups
 
Using Zmanda
  (ZRM for MySQL Community Edition - version 1.2.1)




The MySQL databases are backed up nightly (see crontab -l output below).


Configuration data is kept in files in /etc/mysql-zrm.


Backups are kept in /home/backups/omega/var/lib/mysql-zrm


Logs are kept in /var/log/mysql-zrm



To run a backup immediately:
mysql-zrm-scheduler --now --backup-set BackupSet01[02,03]


To Schedule a (daily at 5am) backup:
mysql-zrm-scheduler --add --interval daily --start 05:00 --backup-level 0 --backup-set BackupSet01


Verification that scheduler has been configured:
mysql-zrm-scheduler --query



Backup Reports:

mysql-zrm-reporter --help (to see all options)
mysql-zrm-reporter --destination /home/backups/omega/var/lib/mysql-zrm/ --where backup-set=daily --show backup-method-info
mysql-zrm-reporter --destination /home/backups/omega/var/lib/mysql-zrm/ --where backup-set=daily --show backup-retention-info
mysql-zrm-reporter --destination /home/backups/omega/var/lib/mysql-zrm/ --where backup-set=monthly --show backup-performance-info
mysql-zrm-reporter --destination /home/backups/omega/var/lib/mysql-zrm/ --where backup-set=monthly --show restore-full-info
mysql-zrm-reporter --destination /home/backups/omega/var/lib/mysql-zrm/ --where backup-set=daily --show restore-incr-info



Restoring Databases:

    

  1. Find our which backups are available:

    mysql-zrm-reporter --destination /home/backups/omega/var/lib/mysql-zrm/ --where backup-set=daily -show restore-info
mysql-zrm-reporter --destination /home/backups/omega/var/lib/mysql-zrm/ --where backup-set=monthly -show restore-info

    

  2. Assuming you want to restore the backup which is in /home/backups/omega/var/lib/mysql-zrm/monthly/20061114144656:

    mysql-zrm --action restore --backup-set monthly --source-directory /home/backups/omega/var/lib/mysql-zrm/monthly/20061114144656

    



















  
    

      webmaster@phas.ubc.ca
      [Dept. Home Page]
      last
updated:
11-03-08