跨物理集群访问-DBLINK配置

源集群(想要访问的集群) 
本地集群配置dblink

在本地集群安装透明网关
[gbase@hw-01 ~]$ cd /opt/
[gbase@hw-01 opt]$ tar xvf GBase8a_MPP_Cluster_Gateway_8.5.1.2_build4.14.tar
启动透明网关
sh gbaseGatewayServer.sh start
看状态：
sh gbaseGatewayServer.sh status

--如果是arm机器安装要替换jre，否则网关启动不了。咱版本是x86的，装在ARM上要替换JRE
注意赋权 chown -R +x jre
find / -name jre

配置DBlink（本地集群）
增加以下配置项
vi /opt/192.168.5.5/gcluster/config/gbase_8a_gcluster.cnf

gbase_dblink_gateway_ip=32.43.0.11 #这里写透明网关的IP,写的是外网IP，对应的内网IP是192.168.192.192
gbase_dblink_gateway_port=9898
gcluster_dblink_direct_data_exchange = 0
_t_gcluster_dblink_insert_select_optimization = 0

重启服务
gcluster_services all restart
gcware_services all restart
show variables like '%dblink%';

cd /home/gbase/GBase8a_MPP_Cluster_Gateway_8.5.1.2_build4.22/conf/gcluster
vi gbase8a_gcluster.properties  
只写本地集群的内网IP

[gc]
gcluster_IP=192.168.192.192
gcluster_port=5258
gcluster_user=gbase
gcluster_pwd=gbase20110531
gcluster_encode=gbk

--好像只需要配置gc，不要配gn
[gn1]
gcluster_IP=192.168.192.191
gcluster_port=5050
gcluster_user=gbase
gcluster_pwd=gbase20110531
gcluster_encode=gbk

[gn2]
gcluster_IP=192.168.192.192
gcluster_port=5050
gcluster_user=gbase
gcluster_pwd=gbase20110531
gcluster_encode=gbk
------------这部分不用做！

cd /home/gbase/GBase8a_MPP_Cluster_Gateway_8.5.1.2_build4.22/conf/dataSource
vi gbase_east2022.properties

[gbase8a cluster]
dataSource_IP=32.12.227.203            #这里写源集群的IP 也就是想要访问的集群
dataSource_port=5258
dataSource_dbname=east2022             #这里写想要访问的数据库
dataSource_dbtype=gcluster
dataSource_user=gbase
dataSource_pwd=gbase20110531
dataSource_charset=gbk

gccli -ugbase -pgbase20110531
USE vc vc2;
create database link dblink_east2022  connect to '' identified by '' using 'gbase_east2022';
using用的跟配置文件的前缀要一样  
create database link dblink_zxbs  connect to '' identified by '' using 'gbase_zxbs';  
create database link dblink_aml  connect to '' identified by '' using 'gbase_aml';  
create database link dblink_ods  connect to '' identified by '' using 'gbase_ods';  
create database link dblink_ybt  connect to '' identified by '' using 'gbase_ybt';  

select * from gbase.db_links;
drop database link dblink_east;

源集群设置默认vc否则报错 ERROR 1105 (HY000): The message from gateway is invalid.
set default_vc for gbase=vc1;
--到库下
use vc_sjsys.east2022;
--看源表
select * from t1@dblink_east limit 10;
往目标表插入数据
insert into  t2 select * from t1@dblink_db1 limit 10;

不能往源集群的表里入数
gbase> insert into t1@dblink_db1 values (1000);
ERROR 1235 (42000): This version of GBase doesn't yet support 'insert into remote table'