[Q]RAC的负载均衡问题

显示全部楼层 · 2005-10-30 17:05:33

做了一个试验，开2000个SESSION
一开始，A机器先连了500，B机器一个也没有。
大概500个后，ORACLE自动转到B机器上，B上也连了500了，A没动。
接着A再连到1000个左右。B没动。
最近，剩下的500全连到B上了，两边都达到1000左右。
我想问的是，为什么每次都是以500为阶段的呢？而不是一个A一个B这样呢？

千问 · 2005-10-30 17:05:33

你总共做了哪些设置？
tnsnames.ora 如何设置的
remote_listener ?

千问 · 2005-10-30 17:05:33

負載均衡與客戶端的設置有關

千问 · 2005-10-30 17:05:33

服务器端的TNSNAMES
LISTENER_HERO2 =
(ADDRESS = (PROTOCOL = TCP)(HOST = kylin2)(PORT = 1521))

LISTENER_HERO1 =
(ADDRESS = (PROTOCOL = TCP)(HOST = kylin1)(PORT = 1521))

LISTENERS_HERO =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = kylin1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = kylin2)(PORT = 1521))
)
HERO =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = kylin1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = kylin2)(PORT = 1521))
(LOAD_BALANCE = yes)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = HERO)
)
)
HERO2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = kylin2)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = HERO)
(INSTANCE_NAME = HERO2)
)
)
HERO1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = kylin1)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = HERO)
(INSTANCE_NAME = HERO1)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

remote_listener：LISTENERS_HERO

千问 · 2005-10-30 17:05:33

remote_listener：LISTENERS_HERO
-------在不同 node上分别设置指向其他node的 listener 而不是用这个看看？
连接数据库的时候使用 HERO

千问 · 2005-10-30 17:05:33

连接数据库的时候,使用HERO来连,
我做测试时,连10次,连接二个节点是4:6,基本实现负载均衡了,

千问 · 2005-10-30 17:05:33

最最直观的
1： sqlnet.ora 设置 traceconnect
2: trcasst分析 tracefile

千问 · 2005-10-30 17:05:33

按biti_rainy的做法，修改remote_listener的设置，连10次，结果都连到同一个节点上了　：（

千问 · 2005-10-30 17:05:33

客户端设置：
两个我都试过，都一样连到同一个节点去。
winy =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = kylin1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = kylin2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = HERO)
)
)
winy1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = kylin1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = HERO)
)
)

千问 · 2005-10-30 17:05:33

1： sqlnet.ora 设置 trace connect
2: trcasst 分析 trace file
没做过，不懂。能说得明白一点吗？