solidDB Help : solidDB reference : SQL: Statements : SET : SET SYNC : SET SYNC CONNECT
  
SET SYNC CONNECT
Note Applies to only solidDB Advanced Replication configurations.
SET SYNC CONNECT 'connect‑string [, connect‑string]' TO MASTER master‑name
SET SYNC CONNECT 'connect‑string' TO REPLICA replica‑name
Access requirements
In replica: SYS_SYNC_ADMIN_ROLE role
Usage
Use the SET SYNC CONNECT statement to change the network name that is associated with the database name.
Use this statement in a replica or master database whenever you have changed network names in databases that the database connects to. Network names are defined in the Com.Listen parameter of the solid.ini configuration file, see .
The second connect string in SET SYNC CONNECT ... TO MASTER facilitates transparent failover of a replica server to a standby master server, should the main master server fail. The order of the connect strings is not significant. The connection is automatically maintained to the currently active main master server.
Return values
For details on each error code, see Error codes.
 
Error code
Description
13047
No privilege for operation
13107
Illegal set operation
21300
Illegal network protocol
25007
Master master‑name not found
25019
Database is not a replica database
Example
SET SYNC CONNECT 'tcp server.company.com 1313' TO MASTER hq_master;
Go up to
SET SYNC