Migrating Expertus meeting server to Digital Ocean

Google Docs link: https://docs.google.com/a/expertus.com/spreadsheet/ccc?key=0Atv0MG6V7MbDdFl1eGZsdWVzTUtZUzYxQk54Y3NQbVE&usp=sharing

To be completed the day BEFORE Activity date
It is OK to combine this with the main activity, as long as TTL is lowered to avoid data issues TTL lowered to 1 hour 10 pm @ 8th Apr

• Redeploy current version in PROD.
  1. Change FQDN in deploybbbclient.sh
  2. Change hostname in bigbluebutton.yml
• Quick test.
• Notification of confirmed activity.
• Timezone Reconf after discussion.
  1. What timezone needs to be configured on the server?
• Lower TTL for CNAME expertus.meeting.com.
  1. Using vendor's DNS hosting panel
• Reconf BBB.

     bbb-conf --setip meeting.expertus.com

• Take a DB Dump of existing production server. [Confirmed no schema conflicts].

     mysqldump -umeetingu -pmeetingp  expertus_meeting_prod >  expertus_meeting_prod.05082014.sql
     scp expertus_meeting_prod.05082014.sql expbbbp@107.170.80.241:/deploy/backups/
    

• Load the dump on new production server.

      #either login or execute remotely using ssh
     mysql -u meetingu -p expertus_meeting_prod < expertus_meeting_prod.05082014.sql

• Verify: app config.
  1. Check bigbluebutton and database yml
  2. Other configs as recommended by Udaya
  3. Timezone
• Quick test.
• DNS A Record.
  1. Change A record for expertus.meeting.com from 168.143.88.65 to 107.170.80.241
• Asterisk reconf and reload.

   su root
   sed -i .5045 's/meet-gw/meetprod-gw' /etc/asterisk/extensions.conf
   asterisk -rx "core reload"
   

• Reset DNS A Record.
• Reset Asterisk conf.
• Reset TTL.

• Reset TTL.
• Shutdown VM on OpSource.
• Delete VM (Deferred). Reimage VM as .81 to be used for dev.
• Archive deploy scripts