This article describes the procedure for adding one or more database servers as part of the ScaleArc cluster setup process.
When more than one database is added to a cluster, ScaleArc is able to seamlessly load balance SQL traffic across the multiple databases. Database load balancing is one of the key benefits of deploying ScaleArc.
Database servers can be added during the cluster creation steps as described below. ScaleArc also supports the management of database servers (Add, Modify, Delete) later after the cluster has already been set up as described in Cluster Control Panel - Configuring Database Servers.
Follow the steps below to add and configure standalone or transaction replication database server(s) to your newly created cluster:
- Execute the cluster creation steps described in Creating Clusters.
Locate the Servers panel on the Create Cluster screen. This is the third panel on the screen.
Select Server from the Server Type drop-down menu and click Add Server.
- Enter the IP address/FQDN (Fully Qualified Domain Name or DNS name) of the MSSQL database server you wish to add.
- Enter the port number or the Instance name.
Select the server role from the drop-down list (see table below). The database service name appears at the end.
Option Description Read + Write
Setting for primary Servers. This setting tells ScaleArc that this server can take write operations.
Setting for secondary or backup Servers that can take read-only transactions at runtime.
Standby + Read
Setting for secondary machines that can take Read or Write transactions but ScaleArc only delivers Read queries to this server type. In the event of the Read+Write server becoming unavailable ScaleArc, automatically promotes servers with this type to be a Read+Write server and demotes the original server to Read+Standby. This is the most selected option for transactional replication sets.
Standby, No Traffic Warm standby server for ScaleArc. This server cannot or should not take transactions at runtime unless the Read+Write Server becomes unavailable, at which time ScaleArc demotes the Read+Write server and promotes the Standby Server to be Read+Write. Often used for other replication types for SQL Server, such as log shipping.
Click Add Server to load the server information. Repeat steps 4-8 to add more database servers as required.
- If you wish to clone (copy) the configurations of a specific cluster, including the database servers added to that cluster, select the cluster of choice from the drop-down in the ScaleArc Cluster Settings section.
- The Start Cluster after Setup setting determines if the cluster is ON or OFF immediately following a setup. Select the checkbox as appropriate.
- Click on Setup Cluster to complete the configuration.
- You may see an alert if you have incorrectly configured any of the settings. If this happens, Click OK and review the details in the log and address the error in the appropriate section of the screen.
- Click Finish to set up the cluster.
- When completed, the system posts a notification screen.
- The cluster appears in the CONTROL PANEL section of the dashboard along with the database servers that were added. The Cluster ID appears below the cluster name.
- If you had selected the checkbox to Start Cluster after Setup (this is selected by default), the newly created cluster's green icon indicates that the cluster is running. If you had unchecked this option, the cluster icon will be red, indicating that you need to start the cluster. Click START in the Status column to run the cluster. The icon should turn green indicating it is now running. You can stop the cluster using the STOP button.