本文選題：高可用性 + 負(fù)載均衡�。� 參考：《河北科技大學(xué)》2015年碩士論文

【摘要】：在“全民參�！钡拇蟊尘跋�,隨著社會(huì)保障覆蓋人數(shù)不斷增加,服務(wù)內(nèi)容不斷增多,服務(wù)地域不斷擴(kuò)大,管理服務(wù)資源、手段和工具不足的問(wèn)題日益凸現(xiàn)出來(lái),全民參保對(duì)數(shù)據(jù)中心支撐能力提出更高要求。為了保證阿克蘇地區(qū)勞動(dòng)和社會(huì)保障管理局的各項(xiàng)應(yīng)用業(yè)務(wù)的順利進(jìn)行,實(shí)現(xiàn)應(yīng)用業(yè)務(wù)間的信息數(shù)據(jù)的共享,建設(shè)了一個(gè)連接省、市的高可用性、共享的數(shù)據(jù)管理中心平臺(tái)。在論文中提出了Oracle RAC的解決方案,利用了Oracle 11g R2的故障轉(zhuǎn)移和均衡負(fù)載特性,建立了一個(gè)社保數(shù)據(jù)庫(kù)集群,來(lái)滿足用戶的高可用性要求。通過(guò)對(duì)社保數(shù)據(jù)中心運(yùn)行情況的分析和總結(jié),了解用戶的需求。根據(jù)用戶的需求,對(duì)比Oracle RAC和主機(jī)HA、Data Guard等技術(shù)方案,提出了Oracle RAC解決方案。從數(shù)據(jù)中心的實(shí)際情況出發(fā),進(jìn)行了Oracle 11g R2數(shù)據(jù)庫(kù)的硬件選型、網(wǎng)絡(luò)規(guī)劃、文件存放、存儲(chǔ)設(shè)備選型等規(guī)劃工作,并進(jìn)行了系統(tǒng)安裝部署。論文介紹了故障轉(zhuǎn)移的配置方法,通過(guò)模擬數(shù)據(jù)庫(kù)宕機(jī)對(duì)基于服務(wù)的故障轉(zhuǎn)移,進(jìn)行了測(cè)試,實(shí)現(xiàn)了沒(méi)有用戶干預(yù)的故障自動(dòng)切換,滿足了高可用性的需求。通過(guò)配置基于客戶端負(fù)載均衡和服務(wù)器端的負(fù)載均衡,模擬大量用戶的連接請(qǐng)求,對(duì)系統(tǒng)的負(fù)載均衡進(jìn)行測(cè)試。Oracle RAC是實(shí)例級(jí)的冗余保障,不能對(duì)存儲(chǔ)級(jí)別和網(wǎng)絡(luò)級(jí)別的故障進(jìn)行保護(hù),這是Oracle RAC技術(shù)方案的不足之處。社保數(shù)據(jù)中心系統(tǒng)上線運(yùn)行之后,系統(tǒng)的運(yùn)行比較穩(wěn)定,性能良好,除了計(jì)劃內(nèi)停機(jī)維護(hù)外,沒(méi)有出現(xiàn)意外停機(jī)的故障。通過(guò)查看服務(wù)器的CPU使用率,系統(tǒng)日志,進(jìn)程狀態(tài),基本上達(dá)到了負(fù)載均衡,提高了系統(tǒng)的性能。不僅滿足了客戶需求,而且創(chuàng)造了較好的經(jīng)濟(jì)效益和社會(huì)效益。此技術(shù)方案不僅可以滿足當(dāng)前系統(tǒng)的建設(shè)需求,而且保留了非常靈活的擴(kuò)展性,可以隨著業(yè)務(wù)量的增大可以增加節(jié)點(diǎn)數(shù)量,為未來(lái)系統(tǒng)的平臺(tái)擴(kuò)容提供保障。
[Abstract]:Against the background of "universal participation", with the increasing number of people covered by social security, the increasing number of services, the expansion of service regions and the shortage of management services resources, means and tools, the problems have become increasingly apparent. Universal participation in the data center to support the ability to put forward higher requirements. In order to ensure the smooth progress of the application business of the Bureau of Labor and Social Security in Aksu area and to realize the information and data sharing among the application businesses, a data management center platform connecting the provinces and cities with high availability and sharing was built. In this paper, an Oracle RAC solution is proposed, and a social security database cluster is established to meet the high availability requirements of users by taking advantage of the failover and load balancing characteristics of Oracle 11g R2. Through the social security data center operation analysis and summary, understand the needs of users. According to the requirements of users, the Oracle RAC solution is put forward by comparing Oracle RAC and host HAX data Guard. Based on the actual situation of the data center, the hardware selection, network planning, file storage and storage equipment selection of Oracle 11g R2 database are carried out, and the system installation and deployment are carried out. This paper introduces the configuration method of failover, tests the failover based on service by simulating database outage, realizes automatic failover without user intervention, and meets the requirement of high availability. By configuring load balancing based on client and server, simulating a large number of users' connection requests, the system load balancing is tested. Oracle RAC is the redundancy guarantee of instance level. The failure of storage level and network level can not be protected, which is the disadvantage of Oracle RAC technology scheme. After the social security data center system goes on line, the system runs stably, the performance is good, except the planned downtime maintenance, does not appear the unexpected downtime breakdown. By checking the CPU usage, system log and process status of the server, the load balance is basically achieved and the system performance is improved. Not only to meet customer needs, but also to create better economic and social benefits. This scheme can not only meet the needs of the current system construction, but also retain a very flexible expansibility. It can increase the number of nodes with the increase of traffic, and provide a guarantee for the future system platform expansion.
【學(xué)位授予單位】：河北科技大學(xué)
【學(xué)位級(jí)別】：碩士
【學(xué)位授予年份】：2015
【分類(lèi)號(hào)】：TP311.13

【參考文獻(xiàn)】

相關(guān)期刊論文 前1條

1 顧偉濤;方鈺;;Oracle RAC 10g高可用系統(tǒng)負(fù)載均衡測(cè)試與分析[J];電腦知識(shí)與技術(shù);2010年19期

，

本文編號(hào)：2011408