请教 linux下配置orcale的双机,负载均衡? 越详细越好,本人实在不通。如果有文档请发我邮箱 [email protected] 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 负载均衡有两种:1.客户端负载均衡 主要是通过tnsnames.ora配置2.服务器端负载均衡 主要是通过修改参数REMOTE_LISTENER为服务器端的tnsnames.ora 中的名称即可通过以上两种方案,可能并达不到理想的负载均衡 这2句方法,我看RAC也是这样的哇,难道有更好的方案? 除了F5之类的硬件之外 , 软件级别的balance是不可能做到非常好的.rac中基本就是这么配置了,不可能达到1:1的balance, 在tnsnames.ora中增加类似下面的代码:Orcl1 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = Node1-vip)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = Node2-vip)(PORT = 1521)) (LOAD_BALANCE = yes) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = Orcl1) (FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) (RETRIES = 180) (DELAY = 5) ) ) ) 在tnsnames.ora中增加类似下面的代码:Orcl1 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = Node1-vip)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = Node2-vip)(PORT = 1521)) (LOAD_BALANCE = yes) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = Orcl1) (FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) (RETRIES = 180) (DELAY = 5) ) ) ) http://www.oracle.com/technology/global/cn/pub/articles/smiley_rac10g_install.html 数据库的经典书目是什么 求字符拼接SQL Oracle 10g BI Discoverer 培训 oracle 中有像sqlserver的临时表吗? 找不到oramts.dll 怎样写段SQL,在PL/SQL里修改ORACLE的游标 ---以下查询语句在ORACLE中应该如何写----- 数据库还原问题?? 100分求一个SQL语句 求大神指点 Oracle语句优化帮帮忙 数据库定时器
1.客户端负载均衡
主要是通过tnsnames.ora配置2.服务器端负载均衡
主要是通过修改参数REMOTE_LISTENER为服务器端的tnsnames.ora 中的名称即可通过以上两种方案,可能并达不到理想的负载均衡
这2句方法,我看RAC也是这样的哇,难道有更好的方案?
Orcl1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Node1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = Node2-vip)(PORT = 1521))
(LOAD_BALANCE = yes)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = Orcl1)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 180)
(DELAY = 5)
)
)
)
Orcl1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Node1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = Node2-vip)(PORT = 1521))
(LOAD_BALANCE = yes)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = Orcl1)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 180)
(DELAY = 5)
)
)
)