cancel
Showing results for 
Search instead for 
Did you mean: 

Approaches to do HA with IQ

Former Member
0 Kudos

I'm looking for approaches to do high availability for IQ -- well, pretty much the question: How to ensure maybe 24/7 availability of an IQ service.

On SQLAnywhere databases mirroring is one alternative as the Replication Server is for ASE.

Even IQ is related to SQLAnywhere, the CREATE MIRROR SERVER seems not to be included.

Accepted Solutions (1)

Accepted Solutions (1)

tayeb_hadjou
Advisor
Advisor
0 Kudos

Hi Frank,

This can be managed by IQ multiplex. It requires Multiplex Grid licensed opton (IQ_MPXNODE).

http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc01839.1604/doc/html/jan1358457614697...

Regards,

Tayeb.

Former Member
0 Kudos

Ok I see. Do I understand it correctly, that at minimum for an IQ HA setup via Multiplex these servers

  1. SCC-server
  2. Coordinator Node
  3. Backup coordinator Node

are needed?

tayeb_hadjou
Advisor
Advisor
0 Kudos

SCC is web based system which helps administrate and monitor IQ System. It is included in IQ installation components.

IQ Multiplex system consists of 2 or many IQ servers called nodes. One of them has coordinator role.

Coordinator is a mandatory node in IQ Multiplex system. Other nodes are called secondary nodes.

Failover scenario covers Coordinator failures and secondary nodes failures.

http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc01839.1604/doc/html/san1278444290497...

Regards,

Tayeb.

Answers (1)

Answers (1)

markmumy
Advisor
Advisor
0 Kudos

Can you be a bit clearer?  Most of the time when we speak of HA we really mean covering a localized outage and shifting to something else in the same data center.  For Disaster Recovery, we really mean having to fail over all operations for IQ from one data center to another.

When it comes to HA for IQ we can design solutions to protect the data and the hardware nodes separately.  As mentioned, using multiplex is one way to provide redundancy should a node fail.  We can also use OS/hardware level HA solutions from the likes of Veritas, Linux, IBM, HP, etc.  These are much simpler from an IQ perspective because all the important bits (names, ip addresses, file locations, etc) all stay the same.  No changes to upstream ETL or query tools since everything has the same address.  But it is software that must be purchased so the up front cost is higher than building something yourself.

For HA, do you want to concern yourself with storage or just assume that your storage vendor will have it covered?

Mark

Former Member
0 Kudos

Thanks for your hints. Actually it's really about failover inside same datacenter e.g. in case of a server is getting down for hardware defect.

Can you provide some whitepaper or similar for 3rd party failover setups with IQ?