solidDB Help : Programming : Deploying SMA and LLA applications : Deploying SMA applications : Using SMA applications with HotStandby : Configuring SMA TC with HotStandby
  
Configuring SMA TC with HotStandby
When using Shared Memory Access (SMA) with Transparent Connectivity (TC), the applications on the primary server and the secondary server must connect to the databases by using SMA-specific syntax in the TC connection string (for ODBC connections) or by setting the non-standard property solid_shared_memory to yes (for JDBC connections).
Additionally, you need to set the load balancing method to LOCAL_READ.
To configure an SMA environment that uses HSB, complete the following steps:
1 Set up the two HSB servers.
2 Set up SMA on both servers.
3 For both applications:
a define the SMA TC connection, see Defining the Transparent Connectivity connection,
b define the load balancing attribute, LOCAL_READ, see Load balancing in Transparent Connectivity.
4 Compile and start the applications.
For example, the following diagram shows two SMA servers connected as an HSB pair.
Diagram that shows an SMA configuration that uses HotStandby
On host1, where solidDB is listening on port 1964, the application uses the following information in the ODBC connect string:
PREFERRED_ACCESS=LOCAL_READ SERVERS=sma tcp 1964, tcp host2 2315
On host2, where solidDB is listening at port 2315, the application uses the following information in the ODBC connect string:
PREFERRED_ACCESS=LOCAL_READ SERVERS=sma tcp 2315, tcp host1 1964
Go up to
Using SMA applications with HotStandby