on 03-02-2015 3:23 PM
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.
Hi Frank,
This can be managed by IQ multiplex. It requires Multiplex Grid licensed opton (IQ_MPXNODE).
Regards,
Tayeb.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
Regards,
Tayeb.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.