UBC Physics & Astronomy
mysql2.phas.ubc.ca
142.103.82.2 (UBC-IT VSS)
UBC VSS Virtual Server:  4 GB memory   32 GB disk 
eth0      Link encap:Ethernet  HWaddr 00:50:56:81:6E:A3  
          inet addr:142.103.82.2  Bcast:142.103.82.15  Mask:255.255.255.240
Disaster Recovery MySQL Backups Using ZRM

13-02-06 problem: copy-plugin exited with error 512 
Omega_Set01:backup:INFO: PHASE START: Creating incremental backup
src = /var/log/mysqlbin/mysqlbinlog.002242
k = /SQLbackups/Omega_Set01/20140715135453/mysqlbinlog.002242
close of pipe failed
Omega_Set01:backup:ERROR: Could not copy file "/var/log/mysqlbin/mysqlbinlog.002242"
Omega_Set01:backup:ERROR: copy-plugin exited with error 512
Omega_Set01:backup:ERROR: Could not copy bin log file /SQLbackups/Omega_Set01/20140715135453/mysqlbinlog.002242
  1. make sure mysql-zrm-socket-server in enabled in /etc/xinetd.d/mysql-zrm-socket-server.
  2. make sure /etc/hosts.allow has line like
    socket-server.pl: 142.103.82.2
  3. check iptables
14-00-00 




13-xx-xx

xxxxxxx










ZZZ Sysadmin Home



-










 








  
    

      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 V6  (or newer).
    3. 
        
  3. web server files
    4. 
        
  4. nfs setup
    5. 
        
  5. Make sure mysqld and httpd are started.
    6. 
        
  6. Make sure to set a root password for mysqld (admin -u root password newpassword).
    7. 
        
  7. Install phpMyAdmin. Create phpMyAdmin dbases: mysql -u root -p < create_tables_mysql_4_1_2+.sql
    8. 
        
  8. Install php-mbstring package from redhat network package archive so phpMyAdmin doesn't complain.
    9. 
        
  9. Get include files installed into /php/includes.
    10. 
        
  10. Check /etc/php.ini configuration file.
    11. 
        
  11. 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
          
    
        
    12. 
        
  12. Install MySQL-zrm.
    13. 
      

Additional, non-critical items to take care of:

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

      		
    

  

















  
    

      webmaster@phas.ubc.ca
      [Dept. Home Page]
      last
updated:
13-02-01