RE: SQL Server on Linux

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Fri, 11 Mar 2016 14:25:08 -0600
Message-ID: <0d9b01d17bd4$1ba052b0$52e0f810$_at_gmail.com>



NUMA may not be supplanting RAC, but private clouds are definitely making RAC less appealing. Why scale out with RAC, on an application that may or not be RAC friendly, when you can just throw more memory and CPU onto your virtual machine?

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Powell, Mark
Sent: Friday, March 11, 2016 2:19 PM
To: oracle-l_at_freelists.org
Subject: RE: SQL Server on Linux

NUMA does not supplant RAC. NUMA is a chip architecture parts of which has now been incorporated into SMP processors. We ran RAC on NUMA boxes from Sequent which IBM later purchased and hence we moved to AIX on Power. The hardware fault tolerance goes back to vendors like Tandem which I think Hewlett-Packard purchased.

SMP is a share everything type of design while NUMA shares everything only within the socket (for lack of a better technical description) and then has to talk to the other processors when outside resources are needed.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mladen Gogala
Sent: Thursday, March 10, 2016 11:51 PM
To: oracle-l_at_freelists.org
Subject: Re: SQL Server on Linux

On 03/10/2016 12:08 PM, Robert Freeman wrote:
> SQL Server still does not have anything like RAC though, does it?
Good question. There is a whole architecture which more or less supplants RAC. It's called "NUMA" and Oracle's high end T5 boxes use the technology. Other examples are HP SuperDome and IBM xSeries servers. You have a single system image, and a tolerance of a single point of failure, which is built into the NUMA machines. I am not sure on which technology would I place my bet.

--
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l



--
http://www.freelists.org/webpage/oracle-l
Received on Fri Mar 11 2016 - 21:25:08 CET

Original text of this message