Last modified Feb, 23, 2017
ScaleArc deployment checklist
Review the following information before you start the deployment and network configuration process. Use the ScaleArc MSSQL Implementation Worksheet v1.xlsx  to get started (right-click on the link and select Download Linked File to open and complete in Microsoft Excel). Then, use the following tables for any additional settings.
 

 

Fields in bold font and marked with an asterisk * are mandatory. 

Configuring the network
 

 

Field name

Value

Comments

*Hostname

Primary

Default value: ScaleArcha1, valid characters: a-z 0-9 _ - . 

Make sure you specify different hostname and IP address for each ScaleArc appliance if you are planning to configure in HA. For HA the Secondary ScaleArc appliance has to be configured the same as Primary ScaleArc, with the same timezone and user access credentials.

If you plan to integrate with Windows AD, make sure you observe the maximum length recommended by Microsoft


Secondary

*Interface

Primary

Default: eth0, in case of multiple network cards, you can select any one of them.

Secondary

*IP Address

Primary

Default value: 192.168.1.10, using this you can access ScaleArc UI. Also referred as Management IP.

Secondary

*Subnet

Primary

 

Secondary

Gateway

   

Primary DNS

   

Secondary DNS

   

Time Zone

 

Default value: (GMT -12:00) Eniwetok, Kwajalein

Configuring ScaleArc user access credentials

By default, ScaleArc has a single user, with admin privileges, who can make changes to the configuration. If you are a first-time user and are logging into ScaleArc, use the admin username and password to start the configuration. 

When you configure HA, the username and password(s) of primary ScaleArc appliance get overwritten on to the secondary ScaleArc appliance. 


Field name Value Comments
*Username   Default value: admin
*Admin password   Default value: admin@123

Configuring High Availability (HA) 

This step is required only when you want to configure HA between two ScaleArc appliances. DATE/TIME should be synced on both the ScaleArc appliances before configuring HA. Similarly, HA VIP should be configured on the same network interface (for example, eth0 or eth1) on which individual Management IP is configured. 

Field name Value Comments
*Floating Virtual IP  

VIP will always point to Primary ScaleArc server once HA is configured. (Also referred to as HA Management IP.

HA keepalive interval (adjust for VM)    
HA deadtime (adjust for VM)    
HA warning interval (must be at least half of deadtime; adjust for VM)    
Rackspace HA   See https://support.scalearc.com/kb/articles/3527
AWS HA   See https://support.scalearc.com/kb/articles/2230
Azure HA   See https://support.scalearc.com/kb/articles/3882


Configuring extra network interface(s)

You can use any one or more network interfaces to configure a cluster. Eth0 is the most commonly used default interface and can also be used for configuring a cluster. If you are planning to use any network interface mentioned below, make sure you change the IP address and subnet for the same, based on your network topology.

If you want to configure bonding link aggregation, please contact the ScaleArc sales team (1-855-800-7225). 


Field name

Value

Comments

Eth1

IP

Default IP: 192.168.1.11, Subnet: 255.255.255.0 

 

Subnet

Eth2

IP 

Default IP: 192.168.1.12, Subnet: 255.255.255.0 

Subnet

Eth3

IP

Default IP: 192.168.1.13, Subnet: 255.255.255.0 

Subnet

Eth4

IP

Default IP: 192.168.1.14, Subnet: 255.255.255.0

Subnet

Configuring the cluster

You need at least one IP address to create a cluster. The IP address can either be a physical IP address or a floating VIP. (HA requires a floating IP). Inbound IP address & Port are used by the application to connect to the ScaleArc cluster, while Outbound IP address is used by the ScaleArc server to connect to the backend database server(s) in that cluster. Inbound & Outbound IP address can be on same or different network interfaces. 

Field Value Comment

*Cluster Name     

   
*Instance Name   Applicable only for MS SQL.
Default MSSQLSERVER.
*Inbound Network Interface  

Any network interface on which the physical IP address is configured. 

*Inbound IP Address  

The existing physical IP address or create a new floating VIP. 

*Inbound Subnet Address  

Required only when you want to create a new VIP for the cluster. 

*Cluster Port  

Default value: 1433 (MS SQL) 

*Outbound Network Interface  

Can be the same as or different from the Inbound NIC. 

*Outbound IP Address  

Can be the same as the Inbound IP address or any other existing VIP; alternatively you can create a new floating VIP. 

*Outbound Subnet Address  

Required only when you want to create new VIP for the cluster. 

Database user credentials

In order for ScaleArc to access the database server(s), you need to provide database user credentials and the necessary permissions for the cluster's outbound IP address and management IP address. ScaleArc uses this information to monitor database server health and the slave replication lag time. See here for minimally required ScaleArc cluster root user privileges.

Field Value Comment
User Name   Database server username.
Password   The password for the above user.

Database server (s)

Specify the database server details needed to define the clusters. 

Tip

Use the checklist below for each database server you add to the cluster.

Field Value Comment
 *DB Server IP   IP address of database server.  
 *Port   Default value: 1433 (MS SQL)
 *Server Type   Read/Write (Principal) or Read Only (Slave)  
 Version    Database server version; for example, MS SQL Server 2008 R2, etc.

 

Some additional questions

The following questions allow to you correctly prepare for ScaleArc deployment:

Question Response

Are the application server(s) & database server(s) at the same location? This will help us determine a possible latency. 

 

What is the platform and version for application server(s), Linux / MS Windows / UNIX, etc.? 

 

What is the platform and version for database server(s), Linux / MS Windows / UNIX, etc.? 

 

Are you using client-side connection pooling from application? 

 

What type of replication have you configured for multiple servers, if any?

 

Are you using any memory data caching technology like memcache? 

 

What type of ScaleArc deployment platform, appliance / VM / Xen / Custom HW / etc. do you use?

 

 

 

 





 


 

On this page

 

 

Comments

    Add new comment