Sybase SQL Anywhere (v12 and higher) supports database mirroring through the use of mirror servers. PowerDesigner models mirror servers as extended objects with a stereotype of <<MirrorServer>>.
You can modify an object's properties from its property sheet. To open a mirror server property sheet, double-click its diagram symbol or its Browser entry in the Mirror Servers folder.
The following extended attributes are available on the Options tab:
Name |
Description |
---|---|
Type |
Specifies the type of mirror server to create. You can choose between:
Scripting name: Type |
Using auto parent |
[copy only] Specifies that the primary server will assign a parent for this server. Scripting name: UsingAutoParent |
Parent |
[copy only] Specifies a tree of servers for a mirroring or scale-out system and indicates the servers from which the non-participating nodes obtain transaction log pages. Scripting name: ParentServer |
Alternate parent |
[copy only] Specifies an alternate parent for the copy node. Scripting name: AlternateParentServer |
Primary |
[copy only] Specifies that the parent server is the primary server. Scripting name: PrimaryParentServer |
Connection string |
Specifies the connection string to be used to connect to the server. Scripting name: ConnectionString |
Log file |
Specifies the location of the log file that is sent between mirror servers. Scripting name: LogFile |
Preferred |
[partner only] Specifies whether the server is the preferred server in the mirroring system, which assumes the role of primary server whenever possible. Scripting name: Preferred |
State file |
[arbiter, partner] Specifies the location of the file used for maintaining state information about the mirroring system. Scripting name: StateFile |