Re: Simple Informix Database HA on Solaris

From: Richard Kofler (richard.kofler_at_chello.at)
Date: 10/07/03 

Date: Tue, 07 Oct 2003 21:34:39 GMT

Sting wrote:
>
> We have two Informix Dynamic Server 9.21 systems running on Solaris 9
> upon which a clustering database proposed. Though the content
> synchronization between seems easier to implement, the failover
> mechanism remains rather hard to choose.
>
> Sun offers Cluster 3.0 software purpose requiring shared diskraid and
> special software packages which I think a small project not need. Does
> anyone know certain alternatives would help to do VRRP like of HA?
> Say, two servers would be assigned into one active and one standby.
> Each database server with two NICs, a primary and a backup. The
> primaries are both bundled with the VIP but the standby server with
> the corresponding NIC disabled until the link to primary NIC on active
> server die out. Both use the backup NIC to monitor each other's
> health?

Check INFORMIX Enterprise Replication (has own manual) or even HDR
in the admin guide.

Also consider upgrading to V9.40.*C2 with UC3 coming soon now.

Read about the sqlhost file and the exaples using '*' in the address
field.

Why have one machine eating power doing nothing when you always
can use it (at least) as a readonly server, and thus distributing all
queries, which don't ask for update or insert?

With clustering you waste the power of one machine ....

dic_k 

-- 
Richard Kofler
SOLID STATE EDV
Dienstleistungen GmbH
Vienna/Austria/Europe

Relevant Pages

  • Re: SBS 2k3 and Additional Servers
    ... Clustering DOES need domain joined servers as the clustering service uses AD for failover configuration and authentication. ... But since SBS doesn't support federated trusts, you'd be screwed even with the 2 nics. ... In my opinion setting up a server cluster is *serious* overkill for your application. ...
    (microsoft.public.windows.server.sbs)
  • Re: Simple Informix Database HA on Solaris
    ... > upon which a clustering database proposed. ... > Each database server with two NICs, ... > primaries are both bundled with the VIP but the standby server with ...
    (comp.unix.solaris)
  • Re: Web NLB
    ... If you are using the recommended two NICs here are ... Add as many IPs as are needed to the machines on the NLB NIC. ... MVP - Windows Server - Clustering ...
    (microsoft.public.windows.server.clustering)
  • Re: How many Quorum Disk are required?
    ... I am running the two servers in Virutal Server 2005. ... The Quorum disk is a SCSI drive with the Share SCSI bus for clustering ... The two servers have two NICs installed. ... MVP - Windows Server - Clustering ...
    (microsoft.public.windows.server.clustering)
  • Simple Informix Database HA on Solaris
    ... Each database server with two NICs, ... primaries are both bundled with the VIP but the standby server with ...
    (comp.unix.solaris)