Oracle RAC在社保数据中心的应用

发布时间：2018-06-12 23:00

本文选题：高可用性 + 负载均衡　；参考：《河北科技大学》2015年硕士论文

【摘要】：在“全民参保”的大背景下,随着社会保障覆盖人数不断增加,服务内容不断增多,服务地域不断扩大,管理服务资源、手段和工具不足的问题日益凸现出来,全民参保对数据中心支撑能力提出更高要求。为了保证阿克苏地区劳动和社会保障管理局的各项应用业务的顺利进行,实现应用业务间的信息数据的共享,建设了一个连接省、市的高可用性、共享的数据管理中心平台。在论文中提出了Oracle RAC的解决方案,利用了Oracle 11g R2的故障转移和均衡负载特性,建立了一个社保数据库集群,来满足用户的高可用性要求。通过对社保数据中心运行情况的分析和总结,了解用户的需求。根据用户的需求,对比Oracle RAC和主机HA、Data Guard等技术方案,提出了Oracle RAC解决方案。从数据中心的实际情况出发,进行了Oracle 11g R2数据库的硬件选型、网络规划、文件存放、存储设备选型等规划工作,并进行了系统安装部署。论文介绍了故障转移的配置方法,通过模拟数据库宕机对基于服务的故障转移,进行了测试,实现了没有用户干预的故障自动切换,满足了高可用性的需求。通过配置基于客户端负载均衡和服务器端的负载均衡,模拟大量用户的连接请求,对系统的负载均衡进行测试。Oracle RAC是实例级的冗余保障,不能对存储级别和网络级别的故障进行保护,这是Oracle RAC技术方案的不足之处。社保数据中心系统上线运行之后,系统的运行比较稳定,性能良好,除了计划内停机维护外,没有出现意外停机的故障。通过查看服务器的CPU使用率,系统日志,进程状态,基本上达到了负载均衡,提高了系统的性能。不仅满足了客户需求,而且创造了较好的经济效益和社会效益。此技术方案不仅可以满足当前系统的建设需求,而且保留了非常灵活的扩展性,可以随着业务量的增大可以增加节点数量,为未来系统的平台扩容提供保障。
[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.
【学位授予单位】：河北科技大学
【学位级别】：硕士
【学位授予年份】：2015
【分类号】：TP311.13

【参考文献】