读写分离搭建实操

读写分离搭建实操

读写分离搭建实操
1.1停止服务
./DmServiceDMSERVER stop
1.2 A机器：实例、启服务
–初始化实例
[dmdba@bin]# ./dminit PATH=/opt/dmdbms/data/ PAGE_SIZE=16 LOG_SIZE=2048 charset=1

–启动服务
[dmdba@bin]# ./dmserver /opt/dmdbms/data/DAMENG/dm.ini

[dmdba@bin]# exit

1配置A机器
1.1注册服务
①复制数据库和守护进程服务文件到/etc/rc.d/init.d目录
cp /opt/dmdbms/bin/service_template/DmService /etc/rc.d/init.d/DmServiceRWC1_01
cp /opt/dmdbms/bin/service_template/DmWatcherService /etc/rc.d/init.d/DmServiceWatcher
②vi /etc/rc.d/init.d/DmServiceRWC1_01文件
START_MODE=mount
DM_HOME="/opt/dmdbms"
INI_PATH="/opt/dmdbms/data/DAMENG/dm.ini"

③vi /etc/rc.d/init.d/DmServiceWatcher文件
DM_HOME="/opt/dmdbms"
INI_PATH="/opt/dmdbms/data/DAMENG/dmwatcher.ini"

④修改启动服务的等级连接
ln -s /etc/rc.d/init.d/DmServiceRWC1_01 /etc/rc.d/rc0.d/K02DmServiceRWC1_01
ln -s /etc/rc.d/init.d/DmServiceRWC1_01 /etc/rc.d/rc2.d/S98DmServiceRWC1_01
ln -s /etc/rc.d/init.d/DmServiceRWC1_01 /etc/rc.d/rc3.d/S98DmServiceRWC1_01
ln -s /etc/rc.d/init.d/DmServiceRWC1_01 /etc/rc.d/rc5.d/S98DmServiceRWC1_01
ln -s /etc/rc.d/init.d/DmServiceRWC1_01 /etc/rc.d/rc6.d/K02DmServiceRWC1_01
chown dmdba.dmdba /etc/rc.d/init.d/DmServiceRWC1_01
ln -s /etc/rc.d/init.d/DmServiceWatcher /etc/rc.d/rc0.d/K02DmServiceWatcher
ln -s /etc/rc.d/init.d/DmServiceWatcher /etc/rc.d/rc2.d/S98DmServiceWatcher
ln -s /etc/rc.d/init.d/DmServiceWatcher /etc/rc.d/rc3.d/S98DmServiceWatcher
ln -s /etc/rc.d/init.d/DmServiceWatcher /etc/rc.d/rc5.d/S98DmServiceWatcher
ln -s /etc/rc.d/init.d/DmServiceWatcher /etc/rc.d/rc6.d/K02DmServiceWatcher
chown dmdba.dmdba /etc/rc.d/init.d/DmServiceWatcher
chmod 777 /etc/rc.d/init.d/DmServiceRWC1_01
chmod 777 /etc/rc.d/init.d/DmServiceWatcher
备注：删除自启
rm -rf /etc/rc.d/init.d/DmServiceRWC1_01
rm -rf /etc/rc.d/rc0.d/K02DmServiceRWC1_01
rm -rf /etc/rc.d/rc2.d/S98DmServiceRWC1_01
rm -rf /etc/rc.d/rc3.d/S98DmServiceRWC1_01
rm -rf /etc/rc.d/rc5.d/S98DmServiceRWC1_01
rm -rf /etc/rc.d/rc6.d/K02DmServiceRWC1_01
rm -rf /etc/rc.d/init.d/DmServiceWatcher
rm -rf /etc/rc.d/rc0.d/K02DmServiceWatcher
rm -rf /etc/rc.d/rc2.d/S98DmServiceWatcher
rm -rf /etc/rc.d/rc3.d/S98DmServiceWatcher
rm -rf /etc/rc.d/rc5.d/S98DmServiceWatcher
rm -rf /etc/rc.d/rc6.d/K02DmServiceWatcher

1.2配置 dm.ini
INSTANCE_NAME = RWC1_01 #数据库实例名
PORT_NUM = 5236 #数据库实例监听端口
DW_PORT = 5536 #守护环境下，监听守护进程连接端口
DW_ERROR_TIME = 60 #接收守护进程消息超时时间
ALTER_MODE_STATUS = 0 #不允许手工方式修改实例模式/状态
MAL_INI = 1 #打开MAL系统
ARCH_INI = 1 #打开归档配置
HA_INST_CHECK_FLAG = 1 #检测是否多个实例进程同时启动

1.3配置 dmarch.ini
[ARCHIVE_TIMELY1]
ARCH_TYPE = TIMELY #即时归档类型
ARCH_DEST = RWC1_01B #即时归档目标实例名
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL #本地归档类型
ARCH_DEST = /opt/dmdbms/data/DAMENG/arch/ #本地归档文件存放路径
ARCH_FILE_SIZE = 2048 #单位MB，本地单个归档文件最大值
ARCH_SPACE_LIMIT = 10240 #单位MB，0表示无限制，范围1024~4294967294MB

1.4配置 dmmal.ini
MAL_CHECK_INTERVAL = 30 #MAL链路检测时间间隔
MAL_CONN_FAIL_INTERVAL = 60 #判定MAL链路断开的时间
MAL_TEMP_PATH = /opt/dmdbms/data/malpath/ #临时文件目录
MAL_BUF_SIZE = 512 #单个MAL缓存大小限制，单位MB
MAL_SYS_BUF_SIZE = 2048 #MAL系统总内存大小限制，单位MB
MAL_COMPRESS_LEVEL = 0 #MAL消息压缩等级，0表示不压缩

[MAL_INST1]
MAL_INST_NAME = RWC1_01 #实例名，和 dm.ini中的INSTANCE_NAME一致
MAL_HOST = 192.168.1.12 #MAL系统监听TCP连接的IP地址
MAL_PORT = 5336 #MAL系统监听TCP连接的端口
MAL_INST_HOST = 192.168.1.12 #实例的对外服务IP地址
MAL_INST_PORT = 5236 #实例的对外服务端口，和dm.ini中的PORT_NUM一致
MAL_DW_PORT = 5436 #实例对应的守护进程监听TCP连接的端口
[MAL_INST2]
MAL_INST_NAME = RWC1_01B
MAL_HOST = 192.168.1.13
MAL_PORT = 5336
MAL_INST_HOST = 192.168.1.13
MAL_INST_PORT = 5236
MAL_DW_PORT = 5436

1.5配置 dmwatcher.ini
[GRWC1_01]
DW_TYPE = GLOBAL #全局守护类型
DW_MODE = MANUAL #故障手动切换模式
DW_ERROR_TIME = 30 #远程守护进程故障认定时间
INST_ERROR_TIME = 30 #本地实例故障认定时间
INST_RECOVER_TIME = 60 #主库守护进程启动恢复的间隔时间
INST_OGUID = 45331 #守护系统唯一OGUID值
INST_INI = /opt/dmdbms/data/DAMENG/dm.ini #dm.ini配置文件路径
INST_AUTO_RESTART = 1 #打开实例的自动启动功能
INST_STARTUP_CMD = /opt/dmdbms/bin/dmserver #命令行方式启动

1.6配置 dmwatcher.c