RE: RAC Interconnect

From: Hameed, Amir <Amir.Hameed_at_xerox.com>
Date: Fri, 24 Nov 2006 01:08:03 -0500
Message-ID: <77A4D80DB2ADD74EB5D7F1D31626F0C0038A7AE9@usa0300ms03.na.xerox.net>

Hello,
I have worked with LLT for over two years with DBE/AC 3.5 for 9i RAC and found no issues what-so-ever with it (LLT). It is a very reliable protocol, proprietary though, but reliable. The LMX driver does the multiplexing and de-multiplexing for LLT, so if you are using multiple interconnects, your traffic will be load-balanced without you doing/configuring anything special. I have not really seen any clear statement from Oracle for de-supporting LLT in the future even though they have been emphasizing on using UDP, which is very typical of Oracle.

---

        From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Anand Rao

	Sent: Friday, November 24, 2006 12:54 AM
	To: ax.mount_at_gmail.com
	Cc: oracle-l_at_freelists.org
	Subject: Re: RAC Interconnect
	
	
	Corrigendum
	
	"10g RAC CRS may allow load-balancing over the VIP".
	
	not talking of VIP here, typo error. load balancing is

definitely possible in 10g RAC. pls ignore the VIP comment.         

        also, i've got a whiff of the rumour that LLT could be de-supported by Oracle, so in any case, you are better off with UDP in terms of performance and reliability.         

	thanks
	anand
	
	
	
	On 24/11/06, Anand Rao <panandrao_at_gmail.com> wrote: 

		Alex,
		
		It would not a good idea to recommend a single

interconnect based on just the user count.                 

                i could have 5000 users, each generating only 10K of inter-node traffic. so, that about 50MB/s. so, user count is not the correct yardstick.                 

                you have to measure the interconnect traffic generated by each database (from the application) and then decide. for testing, don't run both the databases together, you won't see a "per application usage".                 

                measure the traffic generated from each database with the application going full throttle. if you cannot simulate that, then you have no choice but to run the production system with both databases and then measure.                 

                so, you could do with just 1 or maybe 2 but load-balancing between them will be a Veritas/Solaris responsibility. 10g RAC CRS may allow load-balancing over the VIP, not sure.

                Gopal?                 

                guess you are on Solaris 10, so the netstat command should help to capture the interconnect traffic. i guess there is another command introduced in Solaris 10. I haven't used it, but i hope the Solaris Management Suite will provide some good graphical detail of interconnect traffic.                 

                you will get ~90-95 MB/s sustained, depending on the card and the latency. i don't know how good LLT is compared to UDP. i would suggest UDP (life is easier) with some good tuning of UDP buffers at the OS layer. You should also look at tuning the TCP buffers, though it is not directly related to the interconnect.                 

                hope this helps.                 

		thanks
		anand 
		
		
		
		
		On 24/11/06, amonte < ax.mount_at_gmail.com

<mailto:ax.mount_at_gmail.com> > wrote:

                        Hi                          

                        As mentioned a few days ago I am installing a RAC with Verits SFRAC on Solaris 10.                          

                        I have to create 2 databases to for this RAC implementation. Both will share a single Gigabit connection (using Veritas GAB/LLT). The databases will be OLTP supporting around 400 users each. No chance to put them in same database. I was wondering if a single interconnect would be enough?                          

                        TIA                                                   Alex                          

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

Received on Fri Nov 24 2006 - 00:08:03 CST