下文給大家?guī)鞳racle 12c應(yīng)用如何實現(xiàn)連接VIP輪訓(xùn)負(fù)載均衡的，希望能夠給大家在實際運用中帶來一定的幫助，負(fù)載均衡涉及的東西比較多，理論也不多，網(wǎng)上有很多書籍，今天我們就用創(chuàng)新互聯(lián)在行業(yè)內(nèi)累計的經(jīng)驗來做一個解答。
站在用戶的角度思考問題，與客戶深入溝通，找到古藺網(wǎng)站設(shè)計與古藺網(wǎng)站推廣的解決方案，憑借多年的經(jīng)驗，讓設(shè)計與互聯(lián)網(wǎng)技術(shù)結(jié)合，創(chuàng)造個性化、用戶體驗好的作品，建站類型包括：成都網(wǎng)站建設(shè)、網(wǎng)站制作、企業(yè)官網(wǎng)、英文網(wǎng)站、手機端網(wǎng)站、網(wǎng)站推廣、域名注冊、雅安服務(wù)器托管、企業(yè)郵箱。業(yè)務(wù)覆蓋古藺地區(qū)。
目前很多生產(chǎn)數(shù)據(jù)庫都是兩節(jié)點RAC，應(yīng)用連接的數(shù)據(jù)庫通常會連接SCAN IP或者VIP,這里做一個小實驗，如果我們使用VIP連接，
應(yīng)該怎樣配置我們的客戶端，負(fù)載均衡是否是嚴(yán)格意義上的輪訓(xùn)機制，只有通過自己的測試才能得到準(zhǔn)備的答案。
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.測試腳本如下
#!/bin/bash
for i in {1..100}
do
echo $i
sqlplus -S system/oracle@vip <
select instance_name from v\$instance;
select count(*) from t1;
EOF
sleep 1
done
exit 0
3.開始測試，觀察
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
看了以上關(guān)于Oracle 12c應(yīng)用如何實現(xiàn)連接VIP輪訓(xùn)負(fù)載均衡的，如果大家還有什么地方需要了解的可以在創(chuàng)新互聯(lián)行業(yè)資訊里查找自己感興趣的或者找我們的專業(yè)技術(shù)工程師解答的，創(chuàng)新互聯(lián)技術(shù)工程師在行業(yè)內(nèi)擁有十幾年的經(jīng)驗了。
重慶分公司
重慶分公司
