/

7. Add Cluster Schema

Connect to MySQL and Add Cluster Schema


To connect to the mysql instance which we just created, we suggest using the freeware MySQL workbench tool, and can be downloaded from https://dev.mysql.com/downloads/workbench/.

  • Launch MySQL Workbench tool on your system
  • Click on the “+” icon to the right of MySQL Connections to open the new connection configuration window.
  • Enter a connection name - (for example, “azure-mysql”)
  • Hostname: the database endpoint URL which we obtained from RDS instance details tab
  • Username: the Database Master Username as configured
  • Password: the Database Master password as configured
  • Default Schema: Leave blank for now
  • Click on Test Connection to verify you can connect. : If you have trouble connecting, make sure that the credentials are correct and that your IP address is added in the database firewall settings as described earlier. MySQL Workbench
  • Click "ok" to save configuration and close window.
  • Double click on the new connection you created to open database workspace view.
  • In the "SCHEMAS" section, right-click and select Create schema to create a new schema.
  • Schema Name: type in cluster and click Apply, then Apply again in the REview the SQL Script popup.
  • Right-click on the cluster schema and choose "Set as Default Schema".
  • Download the Red5 Pro Server Distribution, and unzip to your desktop.
  • Click “ok” to save configuration and close window.
  • Download the Red5 Pro Server Distribution, and unzip to your desktop.
  • From menu click => File => Open SQL Script, and browse the server distribution to find the cluster.sql file {red5prohome}/webapps/streammanager/WEB-INF/sql/cluster.sql
  • Make sure that the cluster database is selected, then click the execute icon to execute the sql script which populates the cluster database clusterdbpopulated