Difference between revisions of "DPM upgrade at Oxford"

From GridPP Wiki
Jump to: navigation, search
Line 12: Line 12:
  
 
Changed the name of the old headnode from t2se01 to t2se01tmp in DNS and DHCP server
 
Changed the name of the old headnode from t2se01 to t2se01tmp in DNS and DHCP server
 +
 +
=== New DPM head node ===
 +
 +
Installed the new machine as t2se01.
 +
 +
Setup mysql (MariaDB) using local puppet
 +
 +
    Cat mysql.pp
 +
    $mysql_root_pass  = "****"
 +
    $db_user          = "dpmmgr"
 +
    $db_pass          = "****"
 +
    $db_host          = "localhost"
 +
    $override_options = {
 +
    'mysqld' => {
 +
    'max_connections'    => '1000',
 +
    'query_cache_size'  => '256M',
 +
    'query_cache_limit'  => '1MB',
 +
    'innodb_flush_method' => 'O_DIRECT',
 +
    'innodb_buffer_pool_size' => '1000000000',
 +
      }
 +
    }
 +
    class{"mysql::server":
 +
    service_enabled => true,
 +
    root_password  => "${mysql_root_pass}",
 +
    override_options  => $override_options
 +
    }

Revision as of 11:16, 13 March 2018

Objective

Upgrade and migrate DPM Head node from one SL6 physical server to another Centos7 server keeping the same hostname (t2se01 in our case)

Preparation

After the start of the GOCDB downtime, stopped all DPM related services on head node and pool nodes. Used netstat to confirm that there is no live connection to any pool node.

Run the final backup of mysql database on the old headnode

  /usr/bin/mysqldump --user=$mysql_user --password=$mysql_pw --opt --all-databases --single-transaction | gzip -c > mysql-dump-final.sql.gz

Changed the name of the old headnode from t2se01 to t2se01tmp in DNS and DHCP server

New DPM head node

Installed the new machine as t2se01.

Setup mysql (MariaDB) using local puppet

   Cat mysql.pp
   $mysql_root_pass   = "****"
   $db_user           = "dpmmgr"
   $db_pass           = "****"
   $db_host           = "localhost"
   $override_options = {
   'mysqld' => {
   'max_connections'    => '1000',
   'query_cache_size'   => '256M',
   'query_cache_limit'  => '1MB',
   'innodb_flush_method' => 'O_DIRECT',
   'innodb_buffer_pool_size' => '1000000000',
      }
   }
   class{"mysql::server":
   service_enabled => true,
   root_password   => "${mysql_root_pass}",
   override_options  => $override_options
   }