使用DMHS同步mysql5.7

使用DMHS同步mysql5.7

使用DMHS同步mysql5.7. 1

1.      安装MYSQL5.7.37. 1

1.1        卸载mariadb. 1

1.2        关闭selinux. 2

1.3        关闭防火墙... 2

1.4        安装相关的RPM包... 2

1.5        RPM安装MYSQL. 2

1.6        配置MYSQL. 3

1.7        开启binlog. 4

2       部署DMHS相关环境... 6

2.1        安装unixODBC. 6

2.2        安装ODBC驱动... 7

2.3        配置odbc.ini 8

2.4        安装DMHS. 8

2.5        源端配置dmhs.hs. 11

2.6        目标端配置dmhs.hs. 12

2.7        源端创建测试数据... 13

2.8        启动dmhs_server(源端与目的端) 13

2.9        目的端启动执行器... 14

2.10          装载数据... 14

2.11          查看数据装载情况... 15

2.12          源端设置日志起始LSN.. 16

2.13          启动源端日志捕获模块... 17

2.14          测试同步... 17

2.15      dmhs监控... 20

2.16          日志监控... 21

1. 安装MYSQL5.7.37
   1. 卸载mariadb

1. 这里是centos7默认安装了mariadb,为避免后续安装冲突，先卸载mariadb

[root@mysql57 tmp]# rpm -qa | grep -i mariadb

1. 卸载mariadb

[root@mysql57 tmp]# rpm -e --nodeps mariadb-libs-5.5.68-1.el7.x86_64

1. 1. 关闭selinux

setenforce  0  && sed -i 's/SELINUX\=enforcing/SELINUX\=disabled/' /etc/selinux/config

1. 1. 关闭防火墙

[root@mysql57 tmp]# systemctl stop firewalld && systemctl disable firewalld

1. 1. 安装相关的RPM包

[root@mysql57 tmp]# yum -y install autoconf  libaio net-tools numactl

1. 1. RPM安装MYSQL
2. 解压安装介质

[root@mysql57 tmp]# tar -xvf mysql-5.7.37-1.el7.x86_64.rpm-bundle.tar

1. RPM安装, 安装顺序common→libs→client→server

[root@mysql57 tmp]# rpm -ivh mysql-community-common-5.7.37-1.el7.x86_64.rpm mysql-community-libs-5.7.37-1.el7.x86_64.rpm mysql-community-client-5.7.37-1.el7.x86_64.rpm mysql-community-server-5.7.37-1.el7.x86_64.rpm mysql-community-libs-compat-5.7.37-1.el7.x86_64.rpm

1. 1. 配置MYSQL
2. 启动MYSQL

安装完mysql-community-server-5.7.37-1.el7.x86_64.rpm后,会生成mysql配置文件/etc/my.cnf

[root@mysql57 tmp]# systemctl start mysqld

1. 搜索临时密码

[root@mysql57 tmp]# grep -i password /var/log/mysqld.log

1. 通过临时密码登录MYSQL

[root@mysql57 tmp]# mysql -uroot -p

1. 修改初始密码

mysql> alter user 'root'@'localhost' identified with mysql_native_password by 'Root123456!';

Query OK, 0 rows affected (0.00 sec)

1. 创建root@'%'用户并授权

mysql> create user 'root'@'%' identified with mysql_native_password by 'Root123456!';

Query OK, 0 rows affected (0.00 sec)

mysql> grant all on *.* to 'root'@'%';

Query OK, 0 rows affected (0.00 sec)

1. 创建userdmhs@'%'用户并授权

mysql> create user 'userdmhs'@'%' identified with mysql_native_password by 'Root123456!';

Query OK, 0 rows affected (0.00 sec)

mysql> grant all on *.* to 'userdmhs'@'%';

Query OK, 0 rows affected (0.00 sec)

1. 刷新权限

mysql> flush privileges;

1. 创建数据库datadmhs 源库字符集utf8mb3 目的库utf8mb4

1. mysql> create database datadmhs charset utf8mb3;

Query OK, 1 row affected (0.01 sec)

1. mysql> create database datadmhs charset utf8mb4;

Query OK, 1 row affected (0.00 sec)