[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

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

Posted on 2017-08-06
7
Low Priority
?
82 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
  • 4
  • 3
7 Comments
 
LVL 26

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 new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
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 26

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

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Question has a verified solution.

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

This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses

612 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