Oracle GoldenGate Veridata 23c安装（一）

在前面的文章中我们已经介绍过如何安装veridata12c，这次新版本发布后，我们发现在安装上有做很多简化，时间上大大缩减，还有一点要注意的是，管理库的类型有所变更，换成了mysql库，更加轻量化。下面我们具体看下安装步骤。 一、安装前准备 1.1 JDK17 https://download.oracle.com/java/17/archive/jdk-17.0.12_linux-x64_bin.tar.gz 1.2 Veridata 23c https://www.oracle.com/middleware/technologies/goldengate-downloads.html# 1.3 MySQL 8.0 https://downloads.mysql.com/archives/community/ 1.3 关闭防火墙 # systemctl stop firewalld # systemctl disable firewalld # systemctl status firewalld 1.4 关闭NetworkManager # systemctl stop NetworkManager.service # systemctl disable NetworkManager.service # systemctl status NetworkManager.service 1.5 关闭SELINUX # sed -i "s/SELINUX=.*/SELINUX=disabled/g" /etc/selinux/config # setenforce 0 1.6 安装RPM包 # mount  /dev/cdrom  /mnt 配置操作系统YUM源 # vi /etc/yum.repos.d/dvd.repo [dvd] name=dvd baseurl=file:///mnt gpgcheck=0 安装所需依赖包 # yum -y install gcc* gcc-c++ ncurses* ncurses-devel* cmake* make* perl* bison* libaio-devel* libgcrypt 安装常用故障与性能诊断工具等 # yum install -y unzip man screen tigervnc-server iotop dstat openssl make sysstat vsftpd ftp 二、安装JDK 2.1 创建安装用户 # useradd veridata23 2.2 上传安装包 # mkdir -p /tmp/veridata23_medias 上传jdk-17.0.12_linux-x64_bin.tar.gz、Oracle GoldenGate Veridata 23.1.0.0.0 for (Linux x86-64).zip以及mysql-8.0.39-linux-glibc2.17-x86_64.tar.xz # chown -R veridata23:veridata23 /tmp/veridata23_medias # chmod -R 777 /tmp/veridata23_medias 2.3 解压JDK # mkdir -p /usr/java # tar -xzvf jdk-17.0.12_linux-x64_bin.tar.gz -C /usr/java 2.4 配置环境变量 # su - veridata23 $ vi ~/.bash_profile export JAVA_HOME=/usr/java/jdk-17.0.12 export PATH=$JAVA_HOME/bin:$PATH 2.5 确认JDK信息 $ which java /usr/java/jdk-17.0.12/bin/java $ java -version java version "17.0.12" 2024-07-16 LTS Java(TM) SE Runtime Environment (build 17.0.12+8-LTS-286) Java HotSpot(TM) 64-Bit Server VM (build 17.0.12+8-LTS-286, mixed mode, sharing) 三、安装MySQL 3.1 创建安装目录 # mkdir -p /mysql/app # mkdir -p /mysql/product/data # chown -R veridata23:veridata23 /mysql # chmod -R 755 /mysql 3.2 解压MySQL8.0 # su - veridata23 $ cd /tmp/veridata23_medias $ tar -xvf mysql-8.0.39-linux-glibc2.17-x86_64.tar.xz -C /mysql/app --strip-components=1 3.3 创建配置文件 # vi /etc/my.cnf [mysqld] user=veridata23 port=3306 basedir=/mysql/app  datadir=/mysql/product/data  log_error=/mysql/product/data/myerror.log #会话参数 max_connections=4532 max_user_connections=4000 max_connect_errors=50000 wait_timeout=7200 interactive_timeout=7200 thread_cache_size=256 #binlog日志参数 log-bin=mysql-bin binlog_cache_size=131072 binlog_error_action=ABORT_SERVER server_id=1 gtid_mode=on enforce_gtid_consistency=on binlog_expire_logs_seconds=2592000 sync_binlog=1 #慢日志参数 slow_query_log=0 long_query_time=1 log_output=FILE #Redo日志参数 innodb_log_file_size=1048576000 innodb_log_files_in_group=3 #缓存参数 sort_buffer_size=720896 read_buffer_size=720896 read_rnd_buffer_size=360448 join_buffer_size=360448 max_allowed_packet=1073741824 max_heap_table_size=16777216 tmp_table_size=2097152 #innodb参数 innodb_buffer_pool_size=4194304 innodb_data_file_path=ibdata1:200M:autoextend  innodb_file_per_table=ON innodb_log_buffer_size=16777216 innodb_flush_method=O_DIRECT #事务隔离级别 transaction-isolation=READ-COMMITTED #字符集 character_set_server=utf8mb4 #设置时区 default_time_zone='+8:00' log_timestamps=SYSTEM #大小写不敏感 lower_case_table_names=1 3.4 初始化MySQL # cd /mysql/app # ./bin/mysqld --defaults-file=/etc/my.cnf --initialize  # grep 'temporary password' /mysql/product/data/myerror.log 2025-01-09T20:20:22.152366-05:00 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: pWtO-u<tG8<s 3.5 配置环境变量 # vi /root/.bash_profile PATH=/mysql/app/bin:$PATH # source /root/.bash_profile 3.6 配置数据库服务 # cp /mysql/app/support-files/mysql.server /etc/init.d/mysqld # vi /etc/init.d/mysqld basedir=/mysql/app datadir=/mysql/product/data 3.7 启停MySQL # service mysqld start     //启动mysql # service mysqld status    //查看启动状态 # service mysqld stop      //停止mysql 3.8 修改root密码 # mysqladmin -uroot -p password "Hzmc321#" Enter password:pWtO-u<tG8<s # mysql -uroot -pHzmc321# 3.9 设置远程登录 mysql> create user root@'%' identified by 'Hzmc321#'; mysql> grant all privileges on *.* to root@'%'; 3.10 创建veridata用户 mysql> CREATE USER 'vdt23'@'%' IDENTIFIED BY 'Hzmc321#';  mysql> GRANT ALL PRIVILEGES ON *.* TO 'vdt23'@'%' WITH GRANT OPTION;  mysql> FLUSH PRIVILEGES; mysql> SHOW GRANTS FOR 'vdt23'@'%'; 至此前面的准备工作基本做完，由于图文结合介绍，篇幅较长，后半部分的server以及agent安装请看下边文章。