Step by Step for MySQL8.0 Installation

晃荡萝卜DBs 2021-09-26

929

MySQL8.0.18 & 8.0.19用的比较多，和5.7部署基本一致。下面是8.0.26单机部署简单步骤，摒除Master/Slave启用source/replica术语。

下载并解压：

tar -zxvf mysql-commercial-8.0.26-linux-glibc2.12-x86_64.tar.xz

xz -d mysql-commercial-8.0.26-linux-glibc2.12-x86_64.tar.xz

主要的配置文件，replica部分示例

[mysqld]

log_replica_updates = 1

replica_parallel_type = LOGICAL_CLOCK

replica_parallel_workers = 8

log_slow_replica_statements = 1

初始化

./bin/mysqld --defaults-file=/app/mysql/mysql_8026/my.cnf --initialize --user=mysql --basedir=/home/mysql/mysql_8026/ --datadir=/app/mysql/mysql_8026/data

初始化log日志

这里显示了陈旧slave参数改用replica之后的日志信息：

2021-09-20T20:16:40.150623+08:00 0 [Warning] [MY-013746] [Server] cs enabled for channel mysql_main

2021-09-20T20:16:40.151158+08:00 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main

2021-09-20T20:16:40.316682+08:00 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: lpCVy<ADr3tL

启动数据库

./bin/mysqld_safe --defaults-file=/app/mysql/mysql_8026/my.cnf --user=mysql

术语变化

#1: slave statements are deprecated

Start/Stop REPLICA

show replica status;

show replicas

#2: database read only

alter database rbt read only=1;

#3：error_log table

select * from performance_schema.error_log;

后面有空将奉上innodb cluster部署步骤和简易使用

mysql

文章转载自晃荡萝卜DBs，如果涉嫌侵权，请发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。

Step by Step for MySQL8.0 Installation

评论