<pa************ *****@gmail.com wrote in message
news:20******** *************** ***********@d21 g2000prf.google groups.com...
Dale can correct me if I'm wrong, but although it might be possible to
come up with a solution using HA/DR, this isn't really what HA/DR was
designed for.
GRIDSCALE would probably be a much better fit here. It would allow you
to use your standby database fully active, so you get scale as well as
availability out of your first two database servers. It would allow
you to keep your reporting server up to date in real time with no
additional configuration or scripting.
You can email in**@xkoto.com, or go to www.xkoto.com if you are
interested. Or talk to your IBM sales rep.
Regards,
-Paul
Paul, I am very familiar with Xkoto and I met you several times when I
worked at Travelport.
I don't think it is fair to say that HADR is not "designed" to do read-only
on the standby. True, the DB2 implementation does not now allow that, but
the Informix technology from where it came does allow that to the best of my
understanding. IBM has it as an accepted requirement to provide that in DB2
HADR also. Oracle provides that in Data Guard, so I think everyone
understands the requirement.
My guess is that IBM has been delayed because they are trying to develop a
solution that is more than most people need (which is probably just UR
isolation level), instead of providing UR now and then providing the other
isolation levels later.
Regarding Xkoto, I think it works well as a load balancer in an environment
where there are a lot of selects, but I don't think it is quite ready for
prime time as a high volume disaster recovery solution where there are a lot
of inserts and updates in a mission critical application. When I say mission
critical, I don't mean "very important," I mean the whole enchilada (if the
database is down for more than 5 minutes there are severe financial
consequences and if it is down for a day then my company is out of business
permanently).
I am still trying to figure out why there were so many rumors about IBM
buying Xkoto and then apparently the deal fell through. That is not exactly
confidence inspiring IMO.