You are here: Setup > Advanced Configuration > SQL Cluster

SQL Cluster

If you plan to use an SQL cluster, it is recommended to install MEDIAL using a local copy of SQL Express. After this,  you can migrate the database to the cluster. When installing MEDIAL for use with a cluster, ensure that the account has rights to create, access, and modify the two databases:

VLS database

ASPState database for sessions

Back up Databases

1. Log into SQL Management Studio with an account that has full permission to access and back up the VLS database.

2. Expand the server node. Expand Databases and right-click on the VLS database to select Tasks > Back Up.

3. For Destination, click the Disk radio button and add the path for the backup of the database followed by VLS.bak.

4. On the left-hand menu click Options and check the Verify backup when finished box. Click OK to perform the backup.

5. Follow the same steps for the ASPState database if there is not one already present on the SQL cluster.

Migrate Databases

1. Import the VLS database by logging into SQL Management Studio on the cluster and creating a new VLS database.

2. Call the database VLS and then click OK to create it.

3. Once the database has been created, right-click it and then select Tasks > Restore > Database.

4. Select the From device radio button and click the ellipsis on the right.

5. Click Add in the Specify Backup window.

6. Browse to the backup of the VLS database and select it. Click OK.

7. Click OK when you are returned to the Specify Backup window.

8. Check the box for the source database in the Restore column and then click Options.

9. In Restore Options, choose Overwrite the existing database (WITH REPLACE). Click OK.

10. Repeat this process with the ASPState database if there is not an ASPState database already on the cluster.

Change the Connection Strings

To enable MEDIAL to use the database on the cluster, you must change the connection strings in the web.config files to refer to the new database location. There are four web.config files that need to be changed:

vls

upload (web.config)

vlsservice (vlsservice.config)

encoder (encoder.config).

To change the connection strings:

1. On the MEDIAL server, locate and open the MEDIAL installation folder.

2. Starting with the encoder folder, open the file called encoder.config.

3. Locate the connection string in the connectionString XML element and change it so that it points to the database on the cluster. The account will also need to be changed to the one that is going to be used for MEDIAL on the cluster.

4. Repeat this process for the remaining configuration files in the vls, upload, and vlsservice folders.

 

Copyright © 2017 Streaming Ltd