replication and high availability architecture

[Roshan]

Hi Erman,

I have finalized the architecture for replication and HA of my datawarehouse environment.

Hypermirror.pptx

I would like to know if the  architecture is ok? Should I implment Active dataguard if Hypermirror is being used?

Is it possible to create 2 data domains where one will contain SSD disks(Domain1) and another domain which will consist of SAS disks(Domain 2)? I am planning to create another DB on the Domain2   which will hold archive data(less accessed often).


Please advise.

Roshan

[ErmanArslansOracleBlog]

I checked your powerpoint. It seems this is a alternative solution for high availability.
It seems, there is software layer on top of storage systems, which mirrors data between storage space and/or storage devices.
As I see, you mirror the data between the storage spaces using Hypermirror, and you replicate the data between storages using Smartvirtualization.

Although I don't even know these products, this architecture reminds me my old Netapp Storage admin days.
In those times, we were implementing a similar architecture using Netapp snapshot and snapmirror techonologies.

Your architecture seems correct in theory. But I m not a hypermirror expert.
What domain are you talking about? This domain is a hypermirror related thing, I guess..
Using SAS disks for archive data and using SSD disks for  up-to-date/hot data is a good idea, but this domain thing is  another story.
So  I'm not the one who can answer your hypermirror related questions.

Still, I recommend you to have a dataguard configuration for DR. This is because you need to have your database vendor support when something fails during the replication, or when you encounter a problem while you are trying to switch over or fail over to the disaster site.

[Roshan]

Is there a big difference between SSD and Nvme disks in terms of performance and cost?

[ErmanArslansOracleBlog]

Yes.
But it is a long story.
Why don't you read this article? -> https://www.pcworld.com/article/2899351/everything-you-need-to-know-about-nvme.html

Also check this out -> https://ermanarslan.blogspot.com/2016/09/oda-x6-ssmall-and-mmedium-nvme-standard.html

NVMe improves database scability and performance.
->NVMe is the new standard for PCI Express (PCIe) SSDs
->Architected for Flash Storage with minimal CPU overhead
->Works directly with PCIe interface
->No SCSI protocol overhead resulting in very fast response
->5x to 10x IOPS improvement over SAS based SSDs
->Low latency of 100s of micro seconds