Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Oracle golengate replication and MS SQL AOG and DB2 active active solution

Posted on 2017-08-06
7
Low Priority
?
54 Views
Last Modified: 2017-08-29
Hi,

right  now need a study on any limitation on Oracle Golengate replication and MS SQL AOG for business case that need to setup 2 x site,  active active (not multi master). Then we try to POC on which one is better to use in terms of stability.

how about DB2's active active solution? any idea?

please present your idea.
0
Comment
Question by:marrowyung
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 25

Expert Comment

by:Tomas Helgi Johannsson
ID: 42245897
Hi!

The DB2 active active solution that is best suited for OLTP is called DB2 PureScale and requires paid license.

Regards,
    Tomas Helgi
0
 
LVL 1

Author Comment

by:marrowyung
ID: 42246768
Tomas,

any architecture design diagram, use case doc ?

also please help to answer the MysQL cluster quetsion.

KV seems  telling me MySQL active active , which is multi master, is diff from NDB cluster.

if I want to test active active , multi master on how stable it is , then which LATEST package should I dl and install?

please suggest.  I need a step by step guide for MySQL package to set the whole thing up.
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
LVL 1

Author Comment

by:marrowyung
ID: 42250614
hi,

you keep talking about  pureScale. this is for DB2 but is a third party.

but how about comparsion of oracle, MSSQL and DB2's multi site configuration?
0
 
LVL 25

Accepted Solution

by:
Tomas Helgi Johannsson earned 1000 total points
ID: 42250824
Hi!

DB2 PureScale is a database cluster architecture feature included in DB2 Enterprise Server Edition, DB2 Workgroup Server Edition, and DB2 Advanced Enterprise Server Edition and not a third party solution.

Sorry, I don't have any experience in MS SQL AOG so I can't cover difference between Oracle RAC, DB2 PureScale and MS SQL AOG.
Oracle RAC and DB2 PureScale have many things in common but as always there are several different features that you can read about in the corresponding online manuals and that needs to be evaluated according to your business needs.

From my point of view I favor DB2 PureScale ( although Oracle  RAC has advantage in some areas)  mostly for performance reasons regarding some workload scenarios I have seen and worked with.

Regards,
     Tomas Helgi
0
 
LVL 1

Author Comment

by:marrowyung
ID: 42253339
you seems very good at DB2 and MySQL, isn't it ?
0
 
LVL 1

Author Closing Comment

by:marrowyung
ID: 42273317
tks.
0

Featured Post

Enroll in September's Course of the Month

This month’s featured course covers 16 hours of training in installation, management, and deployment of VMware vSphere virtualization environments. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
This video shows how to recover a database from a user managed backup
Via a live example, show how to shrink a transaction log file down to a reasonable size.

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question