Template:VALT Server Migration: Difference between revisions

From IVS Wiki
Jump to navigation Jump to search
← Older edit
No edit summary
No edit summary
 
(4 intermediate revisions by the same user not shown)
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><br>
<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><br>
<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><br>
<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}}<br>
: {{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><br>
<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 98: Line 98:
<div class="section">
<div class="section">
<ol start="10">
<ol start="10">
{{Aside | content = It can be useful to run the migration in a screen. Use {{Code Block - Mini | text = screen -S video_migration}} to start a named session.}}
<li>Type in the following, then press {{Keyboard | key = Enter}}:</li>
<li>Type in the following, then press {{Keyboard | key = Enter}}:</li>
<div class="codeText">sudo rsync -av --progress ivsadmin@<b>OldServerIP</b>:/usr/local/WowzaStreamingEngine/content/valt_recordings/* /usr/local/WowzaStreamingEngine/content/valt_recordings/</div>
<div class="codeText">sudo rsync -av --progress ivsadmin@<b>OldServerIP</b>:/usr/local/WowzaStreamingEngine/content/valt_recordings/* /usr/local/WowzaStreamingEngine/content/valt_recordings/</div>
Line 133: Line 134:
: {{ 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>
 
[[Category:rsync]]

Latest revision as of 23:09, 5 March 2025

Note: Change IP's in the below commands to match the IP's of the new and old server

On the Old Server

  1. Disable the Apache web service to prevent further recordings:
    sudo service apache2 stop
  2. Disable the restart Wowza cronjob:
    - Type in the following command:
    crontab -e
    - Press 1 to continue

  1. Comment out the following job:
    2. 0 3 * * * /usr/local/valt/bin/restartwowza
  2. Press CTRL + X to exit
  3. Press Y to save

  1. Type in the following, then press Enter:
    2. sudo chmod 777 -R /usr/local/WowzaStreamingEngine/content/
  2. Type in the following, then press Enter:
    3. mysqldump -uivsadmin -p valt > valt.sql
  3. Enter in the MySQL password and press Enter:

  1. Copy over the database file to the new server
    2. scp valt.sql ivsadmin@NewServerIP:/home/ivsadmin/
  2. Enter password for ivsadmin and press Enter:

On the New Server

  1. Type in the following and press Enter:
    mysql -uivsadmin -p valt
  2. Enter in the MySQL password and press Enter:
  1. Type in the following and press Enter:
    2. DROP database valt;
:
  1. Type in the following and press Enter:
    2. CREATE database valt;
:
  1. Type in the following and press Enter:
    2. exit
  2. Type in the following and press Enter:
    3. mysql -uivsadmin -p valt < valt.sql
  3. Enter in the MySQL password and press Enter:
  1. Type in the following and press Enter:
    2. mysql -uivsadmin -p valt -e "UPDATE wowza SET address = 'NewServerIP'"
  2. Enter in the MySQL password and press Enter:
    ✎
    It can be useful to run the migration in a screen. Use screen -S video_migration to start a named session.
  1. Type in the following, then press Enter:
    2. sudo rsync -av --progress ivsadmin@OldServerIP:/usr/local/WowzaStreamingEngine/content/valt_recordings/* /usr/local/WowzaStreamingEngine/content/valt_recordings/
  2. When prompted, type yes to continue connecting to the server:
  3. Type in the ivsadmin password and press Enter:
  1. 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
  1. 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.
Retrieved from "https://ivs.help/wiki/index.php?title=Template:VALT_Server_Migration&oldid=14423"