温馨提示×

温馨提示×

您好,登录后才能下订单哦!

密码登录×
登录注册×
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》

Oracle 12c应用如何实现连接VIP轮训负载均衡的

发布时间:2020-04-16 16:31:42 阅读:323 作者:三月 栏目:关系型数据库
开发者测试专用服务器限时活动,0元免费领,库存有限,领完即止! 点击查看>>

下文给大家带来Oracle 12c应用如何实现连接VIP轮训负载均衡的,希望能够给大家在实际运用中带来一定的帮助,负载均衡涉及的东西比较多,理论也不多,网上有很多书籍,今天我们就用亿速云在行业内累计的经验来做一个解答。

目前很多生产数据库都是两节点RAC,应用连接的数据库通常会连接SCAN IP或者VIP,这里做一个小实验,如果我们使用VIP连接,

应该怎样配置我们的客户端,负载均衡是否是严格意义上的轮训机制,只有通过自己的测试才能得到准备的答案。

Oracle 12c应用如何实现连接VIP轮训负载均衡的

  1. tnsnames.ora配置

<rac01:orcl1:/u01/app/oracle/product/12.1.0/dbhome_1/network/admin>$less tnsnames.ora 

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

orcl =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orcl)

    )

  )

vip =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.203)(PORT = 1521))

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.204)(PORT = 1521))

    (LOAD_BALANCE = yes) 

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orcl)

    )

  )

2.测试脚本如下

<rac01:orcl1:/u01/app/oracle/product/12.1.0/dbhome_1/network/admin>$

<rac01:orcl1:/u01/app/oracle/product/12.1.0/dbhome_1/network/admin>$less load_balance.sh 

#!/bin/bash  

for i in {1..100}  

do  

echo $i

sqlplus -S system/oracle@vip <<EOF

select instance_name from v\$instance;

select count(*) from t1;

EOF

sleep 1  

done  

exit 0 

3.开始测试,观察

<rac01:orcl1:/u01/app/oracle/product/12.1.0/dbhome_1/network/admin>$sh load_balance.sh 

1

INSTANCE_NAME

----------------

orcl1

  COUNT(*)

----------

   2910624

2

INSTANCE_NAME

----------------

orcl2

  COUNT(*)

----------

   2910624

3

INSTANCE_NAME

----------------

orcl2

  COUNT(*)

----------

   2910624

4

INSTANCE_NAME

----------------

orcl1

  COUNT(*)

----------

   2910624

5

INSTANCE_NAME

----------------

orcl1

  COUNT(*)

----------

   2910624

6

INSTANCE_NAME

----------------

orcl1

  COUNT(*)

----------

   2910624

7

INSTANCE_NAME

----------------

orcl1

  COUNT(*)

----------

   2910624

8

INSTANCE_NAME

----------------

orcl2

  COUNT(*)

----------

   2910624

9

INSTANCE_NAME

----------------

orcl1

  COUNT(*)

----------

   2910624

10

INSTANCE_NAME

----------------

orcl2

  COUNT(*)

----------

   2910624

11

INSTANCE_NAME

----------------

orcl1

  COUNT(*)

----------

   2910624

12

INSTANCE_NAME

----------------

orcl2

  COUNT(*)

----------

   2910624

13

INSTANCE_NAME

----------------

orcl2

  COUNT(*)

----------

   2910624

14

INSTANCE_NAME

----------------

orcl2

  COUNT(*)

----------

   2910624

15

INSTANCE_NAME

----------------

orcl2

  COUNT(*)

----------

   2910624

16

INSTANCE_NAME

----------------

orcl2

  COUNT(*)

----------

   2910624

17

INSTANCE_NAME

----------------

orcl2

  COUNT(*)

----------

   2910624

18

INSTANCE_NAME

----------------

orcl2

  COUNT(*)

----------

   2910624

19

INSTANCE_NAME

----------------

orcl2

  COUNT(*)

----------

   2910624

20

INSTANCE_NAME

----------------

orcl1

  COUNT(*)

----------

   2910624

21

INSTANCE_NAME

----------------

orcl2

  COUNT(*)

----------

   2910624

22

INSTANCE_NAME

----------------

orcl1

  COUNT(*)

----------

   2910624

23

INSTANCE_NAME

----------------

orcl2

  COUNT(*)

----------

   2910624

24

INSTANCE_NAME

----------------

orcl2

  COUNT(*)

----------

   2910624

25

INSTANCE_NAME

----------------

orcl2

  COUNT(*)

----------

   2910624

26

INSTANCE_NAME

----------------

orcl1

  COUNT(*)

----------

   2910624

27

INSTANCE_NAME

----------------

orcl2

  COUNT(*)

----------

   2910624

28

INSTANCE_NAME

----------------

orcl2

  COUNT(*)

----------

   2910624

29

INSTANCE_NAME

----------------

orcl2

  COUNT(*)

----------

   2910624

30

INSTANCE_NAME

----------------

orcl2

  COUNT(*)

----------

   2910624

31

INSTANCE_NAME

----------------

orcl2

  COUNT(*)

----------

   2910624

32

INSTANCE_NAME

----------------

orcl2

  COUNT(*)

----------

   2910624

33

INSTANCE_NAME

----------------

orcl2

  COUNT(*)

----------

   2910624

34

INSTANCE_NAME

----------------

orcl2

  COUNT(*)

----------

   2910624

35

INSTANCE_NAME

----------------

orcl2

  COUNT(*)

----------

   2910624

36

INSTANCE_NAME

----------------

orcl2

  COUNT(*)

----------

   2910624

37

INSTANCE_NAME

----------------

orcl2

  COUNT(*)

----------

   2910624

38

INSTANCE_NAME

----------------

orcl2

  COUNT(*)

----------

   2910624

39

INSTANCE_NAME

----------------

orcl2

  COUNT(*)

----------

   2910624

40

INSTANCE_NAME

----------------

orcl2

  COUNT(*)

----------

   2910624

41

INSTANCE_NAME

----------------

orcl2

  COUNT(*)

----------

   2910624

42

INSTANCE_NAME

----------------

orcl1

  COUNT(*)

----------

   2910624

43

INSTANCE_NAME

----------------

orcl2

  COUNT(*)

----------

   2910624

44

INSTANCE_NAME

----------------

orcl2

  COUNT(*)

----------

   2910624

45

INSTANCE_NAME

----------------

orcl2

  COUNT(*)

----------

   2910624

46

INSTANCE_NAME

----------------

orcl2

  COUNT(*)

----------

   2910624

47

INSTANCE_NAME

----------------

orcl2

  COUNT(*)

----------

   2910624

48

INSTANCE_NAME

----------------

orcl2

  COUNT(*)

----------

   2910624

49

INSTANCE_NAME

----------------

orcl1

  COUNT(*)

----------

   2910624

50

INSTANCE_N

....省略...............

  COUNT(*)

----------

   2910624

100

INSTANCE_NAME

----------------

orcl1

  COUNT(*)

----------

   2910624

看了以上关于Oracle 12c应用如何实现连接VIP轮训负载均衡的,如果大家还有什么地方需要了解的可以在亿速云行业资讯里查找自己感兴趣的或者找我们的专业技术工程师解答的,亿速云技术工程师在行业内拥有十几年的经验了。

亿速云「云服务器」,即开即用、新一代英特尔至强铂金CPU、三副本存储NVMe SSD云盘,价格低至29元/月。点击查看>>

向AI问一下细节

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。

AI

开发者交流群×