Call for Paper - March 2023 Edition
IJCA solicits original research papers for the March 2023 Edition. Last date of manuscript submission is February 20, 2023. Read More

Load Balance Monitoring in Oracle RAC

Print
PDF
International Journal of Computer Applications
© 2014 by IJCA Journal
Volume 100 - Number 1
Year of Publication: 2014
Authors:
Neha Chandrima
Sunil Phulre
Vineet Richhariya
10.5120/17493-8013

Neha Chandrima, Sunil Phulre and Vineet Richhariya. Article: Load Balance Monitoring in Oracle RAC. International Journal of Computer Applications 100(1):46-49, August 2014. Full text available. BibTeX

@article{key:article,
	author = {Neha Chandrima and Sunil Phulre and Vineet Richhariya},
	title = {Article: Load Balance Monitoring in Oracle RAC},
	journal = {International Journal of Computer Applications},
	year = {2014},
	volume = {100},
	number = {1},
	pages = {46-49},
	month = {August},
	note = {Full text available}
}

Abstract

Oracle RAC offers and provides very attractive and promising features for today's challenging market scenario, where safety and availability of database is the basic need and demand of clients who are working on mission critical databases. The two most alluring features which RAC provides are high availability and load balancing. Load balancing is performed by the load balancer which most of the time works as desired; but it is noticed that failure of load balancer could be a single point of failure for the entire RAC system. In the present research work our aim is to monitor the load balancing feature of Oracle RAC in order to keep a close watch on whether switchover between nodes is happening correctly and smoothly or not. The concept of relative entropy is taken as inspiration, which helps us compare the randomness of the nodes and also the entire RAC system. A script is designed to monitor the number of sessions in each node which should run at the expected peak hours. These peak hours are discovered by extensive monitoring of sessions in each node for 30 days continuously. A threshold limit for number of sessions in each respective node is to be defined in prior, which should be near about but less than maximum session limit defined for the load balancer. As soon as the number of sessions in a particular node reaches its threshold limit, an email is sent to the DBA team which in turn alerts the team to keep a close watch on the switchover. In the proposed scheme the motto is to provide the client with a better service with the help of proper monitoring. To insure an even workload distribution, a clustered database must employ methods to distribute incoming sessions evenly and effectively across the various components of its cluster. As soon as the DBA gets email showing the threshold limit is reached, the DBA must become alert. If he notices that switchover or in other words load balancing is not happening properly, he can do a manual switchover to prevent the client from suffering with rejection of server. In present work Relative Entropy calculation technique is used as an inspiration to calculate the randomness of the RAC system based on its load balancing feature. Proposed scheme can minimize the cost as we can tune up the memory or SGA/PGA based on our result reducing the time to fetch as well. The Relative Entropy calculation scheme of detecting the randomness of Oracle RAC system is a truly new approach based on which we can monitor as well as forecast the behavior of its load balancing act. Proposed method also could help to detect any upcoming issue related to load balancing which could interrupt the client services. The proposed mechanism has overcome some of the limitations like it can be automated without any prior installation.

References

  • docs. oracle. com/cd/E11882_01/rac. 112/e41960/admcon. htm
  • Gong Weihua and Wang Yuanzhen, Jan, 2006 "A new load balancing scheme on heterogeneous database cluster" Geo-spatial information science; 9(3):216-222. DOI:10. 1007/BF02826771
  • Stephane Ganc, Arski and Hubert Naacke "Load Balancing of Autonomous Applications and Databases in a Cluster System" Distributed data and structure 4, 162-164 -169.
  • Zin Chen, Gokul Soundrajan,Madlin Mihaailescu 2007, "Outlier Detection for Fine-grained Load Balancing in Database Clusters" Proceeding ICDEW 07, Proceedings of 2007 IEEE International Conference on Data Engineering workshop, IEEE Computer Society Washington, DC, USA, 404-413
  • Don MacVittie "Load Balancing Oracle Database Traffic" F5 Networks, Inc. White paper, 8-10, 888-882-4447
  • Gia- Khanh Nguyen and Tim Read, July 2011 "Running oracle® real application clusters on oracle solaris zone clusters" An Oracle White Paper
  • Deepali Kadam, Nandan Bhalwarkar, Rahul Neware, Rajesh Sapkale, Raunika Lamge, June-2011, "Oracle Real Application Clusters" Int. J of Sc. & Engg Research , 2, (6), 01-05, ISSN 2229-5518
  • Rene Kundersma, 2012, "11gR2 Oracle Real Application Clusters Grid Infrastructure N. F. " otn. oracle. com/rac
  • Howard Karlof and Kenneth Shirley, 2013, "Maximum Entropy Summary Trees" Eurographics Conference on Visualization (EuroVis) Vol 32, No. 3
  • Markus Michalewic, June 2013, "Oracle Database 12c Real Application Clusters (RAC)" An Oracle White Paper,15-17