i hope you can help me again :-)
We want to install HA (mirroring) on 3 server: IMS-02 (192.168.0.109), IMS-backup (192.168.0.103) and Pro-2 (192.168.10.164) This mirroring system should be running as service.
I had connected to the primarydb on IMS-02 and hat created this with Interactive SQL:
create mirror server PrimaryDB_primary as primary connection_string='SERVER=PrimaryDB_primary;HOST=IMS-02:46000,IMS-backup:46035';
create mirror server PrimaryDB_partner as partner connection_string='SERVER=PrimaryDB_partner;HOST=IMS-02:46000' state_file='G:\primary_db\server1.state' preferred='YES';
create mirror server PrimaryDB_mirror as mirror connection_string='SERVER=PrimaryDB_mirror;HOST=IMS-02:46000,IMS-backup:46035';
create mirror server PrimaryDB_mirror_partner as partner connection_string='SERVER=PrimaryDB_mirror_partner;HOST=IMS-backup:46035' state_file='\192.168.0.103\IMSTTEST_db\server2.state';
create mirror server PrimaryDB_Arbiter as arbiter connection_string='SERVER=PrimaryDB_Arbiter;HOST=PRO-2:46020';
set mirror option authentication_string='abc'; set mirror option synchronization_mode='synchronous';
Then i had defined a service on Pro2 for the Arbiter with the following config parameter: -n PrimaryDB_Arbiter -su sql23 -x "TCPIP(PORT=46020;DOBROAD=no)" -xf "c:\arbiter\arbiter.state" -xa "AUTH=abc;DBN=PrimaryDB"
2nd service on IMS-02 as primary server: -n PrimaryDB_Server -x tcpip(ServerPort=46000;doBroadcast=no) -xf "G:\primary_db\server1.state" G:\primary_db\primary.db -ek akira2468 -n PrimaryDB
3rd service on IMS-backup as mirror server: -n PrimaryDB_Mirror -x tcpip(PORT=46035;DOBROAD=no) -xf "F:\IMSTTEST_db\server2.state" -su sql23 F:\IMSTTEST_db\primary.db -oe "C:\error_sql_mirror.txt" -ek akira2468 -n PrimaryDB
The services will be started, but in the overview on Sybase Central (Health & Statistics), there will not shown the grafic for the functions Arbiter and Mirror. If i have a look to the state file for primary server, i find this:
[PrimaryDB] Owner=<partner> State=synchronizing Mode=synchronous Sequence=1 Yielding=No
But the file for the mirror server is empty!
I had also started the services with the following parameters for each server but the mirror system doesn't work: -xp partner=(ENG=PrimaryDB_partner;LINKS=tcpip(PORT=46000;TIMEOUT=1));auth=abc;arbiter=(ENG=PrimaryDB_Arbiter;LINKS=tcpip(PORT=46020;TIMEOUT=1));mode=synchronous
Can somebody tell me what goes wrong and how to fix?
thanks and best regards from germany Sabrina
asked 12 Mar '15, 07:26
I notice a few potential problems:
answered 12 Mar '15, 09:51
The SERVER=PrimaryDB_mirror_partner doesn't match anything else.
answered 12 Mar '15, 09:37