1 说明
1.1 软件版本
Mysql:5.7.26 下载地址
Mysql Ogg:12.2.0.2 下载地址
BigData Ogg:12.3.2.1.1 下载地址
2 安装
2.1 Mysql
(1) 解压并重命名
tar -zxvf mysql-5.7.26-1.el6.x86_64.rpm-bundle.tar.gz
mv mysql-5.7.26-linux-glibc2.12-x86_64 /usr/local/mysql5.7
(2) Mysql配置文件(/etc/my.cnf)
[mysqld]
datadir=/usr/local/mysql5.7/data
socket=/var/lib/mysql/mysql.sock
user=mysql
symbolic-links=0
#######数据库超时时间
connect_timeout=388000
#######wait_timeout=388000
interactive_timeout=388000
##########默认存储引擎
default-storage-engine=INNODB
innodb_buffer_pool_size=1073741824
########ogg配置
log-bin=mysql-bin #添加这一行就ok
binlog-format=ROW #选择row模式
server_id=1 #配置mysql replaction需要定义,不能和canal的slaveId重复
[mysqld_safe]
log-error=/var/log/mysqld5.7.log
pid-file=/var/run/mysqld/mysqld5.7.pid
[client]
default-character-set=utf8
(3) Mysql.server(/usr/local/mysql5.7/support-files/mysql.server
basedir=/usr/local/mysql5.7
datadir=/usr/local/mysql5.7/data
(4) 初始化
cd /usr/local/mysql5.7/bin
./mysqld --initialize -> 这一步会输出root初始密码,请复制下来
(5) 启动文件配置
cp /usr/local/mysql5.7/support-files/mysql.server /etc/init.d/mysql5.7
(6) 启动数据库
services mysqld5.7 start
(7) 可能出现sock异常
解决
ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
(8) Mysql的path
先将旧版本的备份
cd /usr/bin
mkdir mysql_bak
mv mysql* mysql_bak;
建立5.7版本的PATH
vim /etc/profile
export MYSQL_HOME=/usr/local/mysql5.7
export PATH=
MYSQL_HOME/bin
(9) Mysql用root登录
mysql -uroot
输入之前复制的密码
alter user root identified by ‘root’; -> 修改r