Difference between revisions of "Template:VALT Server Migration"
IVSWikiBlue (talk | contribs) (→On the Old Server) |
IVSWikiBlue (talk | contribs) |
||
| Line 53: | Line 53: | ||
#: <code>mysql -uivsadmin -p valt</code> | #: <code>mysql -uivsadmin -p valt</code> | ||
# Enter in the MySQL password and press {{Keyboard | key = Enter}}: | # Enter in the MySQL password and press {{Keyboard | key = Enter}}: | ||
| − | </div | + | </div> |
: {{img | file = MySQL_Login.png}} | : {{img | file = MySQL_Login.png}} | ||
| − | + | ||
<div class="section"> | <div class="section"> | ||
<ol start="3"> | <ol start="3"> | ||
| Line 61: | Line 61: | ||
<code>DROP database valt;</code><br> | <code>DROP database valt;</code><br> | ||
</ol> | </ol> | ||
| − | </div> | + | </div> |
| + | |||
: :{{img | file = Database_DROP.png}} | : :{{img | file = Database_DROP.png}} | ||
| − | + | ||
<div class="section"> | <div class="section"> | ||
<ol start="4"> | <ol start="4"> | ||
<li>Type in the following and press {{Keyboard | key = Enter}}:</li> | <li>Type in the following and press {{Keyboard | key = Enter}}:</li> | ||
| − | <code>CREATE database valt;</code | + | <code>CREATE database valt;</code> |
</ol> | </ol> | ||
| − | </div> | + | </div> |
| + | |||
: :{{img | file = Database_CREATE.png}} | : :{{img | file = Database_CREATE.png}} | ||
| − | + | ||
<div class="section"> | <div class="section"> | ||
<ol start="5"> | <ol start="5"> | ||
| Line 80: | Line 82: | ||
<li>Enter in the MySQL password and press {{Keyboard | key = Enter}}:</li> | <li>Enter in the MySQL password and press {{Keyboard | key = Enter}}:</li> | ||
</ol> | </ol> | ||
| − | </div> | + | </div> |
| + | |||
: {{img | file = Database_IMPORT.png}}<br> | : {{img | file = Database_IMPORT.png}}<br> | ||
| − | + | ||
<div class="section"> | <div class="section"> | ||
<ol start="8"> | <ol start="8"> | ||
| Line 89: | Line 92: | ||
<li>Enter in the MySQL password and press {{Keyboard | key = Enter}}:</li> | <li>Enter in the MySQL password and press {{Keyboard | key = Enter}}:</li> | ||
</ol> | </ol> | ||
| − | </div> | + | </div> |
| + | |||
: {{img | file = MySQL_Wowza_Update_Address.png}} | : {{img | file = MySQL_Wowza_Update_Address.png}} | ||
| − | + | ||
<div class="section"> | <div class="section"> | ||
<ol start="10"> | <ol start="10"> | ||
| Line 99: | Line 103: | ||
<li>Type in the <b>ivsadmin</b> password and press {{Keyboard | key = Enter}}:</li> | <li>Type in the <b>ivsadmin</b> password and press {{Keyboard | key = Enter}}:</li> | ||
</ol> | </ol> | ||
| − | </div> | + | </div> |
| + | |||
: {{img | file = Rsync_Recordings.png}} | : {{img | file = Rsync_Recordings.png}} | ||
| Line 106: | Line 111: | ||
<li>The video files will begin copying over to the new server and will look like this:</li> | <li>The video files will begin copying over to the new server and will look like this:</li> | ||
</ol> | </ol> | ||
| − | </div | + | </div> |
| − | |||
| − | : {{img | file = Video_Copy 2.PNG | width = }} | + | : {{img | file = Video_Copy 1.PNG | width = }} |
| + | |||
| + | : {{img | file = Video_Copy 2.PNG | width = }} | ||
<div class="floating_card"> | <div class="floating_card"> | ||
| Line 117: | Line 123: | ||
<li>Assuming the copy is running at a full 1GB link, it will take about 2.8 hours per 1 TB of data</li> | <li>Assuming the copy is running at a full 1GB link, it will take about 2.8 hours per 1 TB of data</li> | ||
</ul> | </ul> | ||
| − | </div | + | </div> |
<div class="section"> | <div class="section"> | ||
| Line 123: | Line 129: | ||
<li>After the video files are done copying over, you will see a confirmation message similar to the one below:</li> | <li>After the video files are done copying over, you will see a confirmation message similar to the one below:</li> | ||
</ol> | </ol> | ||
| − | </div | + | </div> |
| − | : {{ img | file = Rsync_Confirmation.png}} | + | |
| + | : {{ img | file = Rsync_Confirmation.png}} | ||
<div class="floating_card">After the files have been copied over, navigate to the VALT webpage on the new server and verify that all of the files are there.</div><br> | <div class="floating_card">After the files have been copied over, navigate to the VALT webpage on the new server and verify that all of the files are there.</div><br> | ||
[[Category:rsync]] | [[Category:rsync]] | ||
Revision as of 15:05, 5 August 2022
Contents
Note: Change IP's in the below commands to match the IP's of the new and old server
On the Old Server
- Disable the Apache web service to prevent further recordings:
-
sudo service apache2 stop
-
- Disable the restart Wowza cronjob:
- - Type in the following command:
-
crontab -e - - Press 1 to continue
- Comment out the following job:
- Press CTRL + X to exit
- Press Y to save
0 3 * * * /usr/local/valt/bin/restartwowza
- Type in the following, then press Enter:
- Type in the following, then press Enter:
- Enter in the MySQL password and press Enter:
sudo chmod 777 -R /usr/local/WowzaStreamingEngine/content/
mysqldump -uivsadmin -p valt > valt.sql
- Copy over the database file to the new server
- Enter password for ivsadmin and press Enter:
scp valt.sql ivsadmin@NewServerIP:/home/ivsadmin/
On the New Server
- Type in the following and press Enter:
-
mysql -uivsadmin -p valt
-
- Enter in the MySQL password and press Enter:
- Type in the following and press Enter:
DROP database valt;
- :
- Type in the following and press Enter:
CREATE database valt;
- :
- Type in the following and press Enter:
- Type in the following and press Enter:
- Enter in the MySQL password and press Enter:
exit
mysql -uivsadmin -p valt < valt.sql
- Type in the following and press Enter:
- Enter in the MySQL password and press Enter:
mysql -uivsadmin -p valt -e "UPDATE wowza SET address = 'NewServerIP'"
- Type in the following, then press Enter:
- When prompted, type yes to continue connecting to the server:
- Type in the ivsadmin password and press Enter:
sudo rsync -av --progress ivsadmin@OldServerIP:/usr/local/WowzaStreamingEngine/content/valt_recordings/* /usr/local/WowzaStreamingEngine/content/valt_recordings/
- The video files will begin copying over to the new server and will look like this:
Things to note:
- Depending on the amount of video files, it may take some time for all of the files to transfer
- Assuming the copy is running at a full 1GB link, it will take about 2.8 hours per 1 TB of data
- After the video files are done copying over, you will see a confirmation message similar to the one below:
After the files have been copied over, navigate to the VALT webpage on the new server and verify that all of the files are there.
