Difference between revisions of "Template:VALT Server Migration"
IVSWikiBlue (talk | contribs) |
IVSWikiBlue (talk | contribs) (→On the New Server) |
||
| Line 59: | Line 59: | ||
<ol start="3"> | <ol start="3"> | ||
<li>Type in the following and press {{Keyboard | key = Enter}}:</li> | <li>Type in the following and press {{Keyboard | key = Enter}}:</li> | ||
| − | <code>DROP database valt;</code | + | <code>DROP database valt;</code> |
</ol> | </ol> | ||
</div> | </div> | ||
| Line 77: | Line 77: | ||
<ol start="5"> | <ol start="5"> | ||
<li>Type in the following and press {{Keyboard | key = Enter}}:</li> | <li>Type in the following and press {{Keyboard | key = Enter}}:</li> | ||
| − | <code>exit</code | + | <code>exit</code> |
<li>Type in the following and press {{Keyboard | key = Enter}}:</li> | <li>Type in the following and press {{Keyboard | key = Enter}}:</li> | ||
| − | <code>mysql -uivsadmin -p valt < valt.sql</code | + | <code>mysql -uivsadmin -p valt < valt.sql</code> |
<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}} | + | : {{img | file = Database_IMPORT.png}} |
<div class="section"> | <div class="section"> | ||
<ol start="8"> | <ol start="8"> | ||
<li>Type in the following and press {{Keyboard | key = Enter}}:</li> | <li>Type in the following and press {{Keyboard | key = Enter}}:</li> | ||
| − | <code>mysql -uivsadmin -p valt -e "UPDATE wowza SET address = '<b>NewServerIP</b>'"</code | + | <code>mysql -uivsadmin -p valt -e "UPDATE wowza SET address = '<b>NewServerIP</b>'"</code> |
<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> | ||
| Line 133: | Line 133: | ||
: {{ 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 | + | <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> |
[[Category:rsync]] | [[Category:rsync]] | ||
Revision as of 15:39, 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.
