在前面的文章中我们已经介绍过如何安装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安装请看下边文章。