阿里云-云小站(无限量代金券发放中)
【腾讯云】云服务器、云数据库、COS、CDN、短信等热卖云产品特惠抢购

CentOS 7源码编译安装MySQL 8.0

191次阅读
没有评论

共计 5489 个字符,预计需要花费 14 分钟才能阅读完成。

0. 前期准备条件

•查看 linux 的版本

[root@mysql etc]# cat /etc/RedHat-release
CentOS Linux release 7.3.1611 (Core)

•Could NOT find Curses

yum install ncurses-devel

•Bison executable not found in PATH

yum install bison

备注:
 安装过程中会缺少基础包,本实例环境缺少上述包,先提前安装相应的包

1.cmake 的源编译安装

[root@db software]# nohup tar zxvf cmake-3.11.1.tar.gz &
[root@db software]# cd cmake-3.11.1
[root@db cmake-3.11.1]# ./configure
[root@localhost cmake-3.0.1]# gmake && make install

2.wolfssl 包的部署安装 [可选项]

*. 从 wolfssl.com 网站下载 wolfssl-3.13.0.zip 压缩包
*. 解压至 /data/software/mysql-8.0.11/extra/wolfssl-3.13.0 目录中。
*. cd extra/wolfssl-3.13.0/IDE/MYSQL
*. 执行 do.sh 脚本
*. use -DWITH_SSL=wolfssl for CMake

3.openssl 和 openssl-devel[本实验使用的是 system ssl]

yum install –y openssl openssl-devel

4.mysql 的编译安装

[root@mysql software]#tar zxvf mysql-8.0.11.tar.gz
[root@mysql software]# cd mysql-8.0.11/
[root@mysql software]# mkdir Zdebug
[root@mysql software]# cd Zdebug

cmake .. -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DENABLED_LOCAL_INFILE=ON \
-DWITH_INNODB_MEMCACHED=ON \
-DWITH_SSL=system \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 \
-DWITH_PERFSCHEMA_STORAGE_ENGINE=1 \
-DCOMPILATION_COMMENT=”zsd edition” \
-DDOWNLOAD_BOOST=1 \
-DWITH_BOOST=/tmp \
-DMYSQL_UNIX_ADDR=/data/mysqldata/3306/mysql.sock \
-DSYSCONFDIR=/data/mysqldata/3306 > /data/software/mysql-8.0.11/Zdebug/mysql_cmake80.log 2>&1

出现下列日志:

…………
— Configuring done
— Generating done
— Build files have been written to: /data/software/mysql-8.0.11/Zdebug
…………

说明编译成功,其中 -DWITH_SSL=system 用的是 linux 操作系统的 openssl,需要安装 openssl 和 openssl-devel 包,才可以被编译

如果需要编译安装快速,可以运用多线程加快编译安装,命令如下:

make -j 12
make install

•MySQL 8.0 的软件目录结构

[root@mysql Zdebug]# cd /usr/local/mysql/
[root@mysql mysql]# ls -l
total 612
drwxr-xr-x.  2 root root  4096 May 16 14:20 bin
drwxr-xr-x.  2 root root    55 May 16 14:20 docs
drwxr-xr-x.  3 root root    266 May 16 14:20 include
drwxr-xr-x.  4 root root    173 May 16 14:20 lib
-rw-r–r–.  1 root root 301518 Apr  8 14:44 LICENSE
-rw-r–r–.  1 root root 301518 Apr  8 14:44 LICENSE-test
drwxr-xr-x.  4 root root    30 May 16 14:20 man
drwxr-xr-x. 10 root root  4096 May 16 14:21 mysql-test
-rw-r–r–.  1 root root    687 Apr  8 14:44 README
-rw-r–r–.  1 root root    687 Apr  8 14:44 README-test
drwxr-xr-x. 28 root root  4096 May 16 14:21 share
drwxr-xr-x.  2 root root    90 May 16 14:21 support-files

5. 创建 mysql 用户 & 并修改相关文件

[root@mysql mysql]# groupadd mysql
[root@mysql mysql]# useradd -g mysql mysql

6. 设置用户操作系统资源的限制

[root@localhost cmake-3.0.1]# vi /etc/security/limits.conf
mysql soft nproc 65536
mysql hard nproc 65536
mysql soft nofile 65536
mysql hard nofile 65536

验证 limit 是否生效

[root@mysql ~]# su – mysql
[mysql@mysql ~]$ ulimit -a

日志如下:
…………
open files                      (-n) 65536
max user processes              (-u) 65536

7. 创建 MySQL 数据目录及赋予相应权限

#cd /data/
#mkdir -p /data/mysqldata/{3306/{data,tmp,binlog,innodb_ts,innodb_log},backup,scripts}
#chown -R mysql:mysql mysqldata
#su – mysql

8. 配置 my.cnf 文件

$vi /data/mysqldata/3306/my.cnf

[client]
port = 3306
socket = /data/mysqldata/3306/mysql.sock
# The MySQL server
[mysqld]
port = 3306
user = mysql
socket = /data/mysqldata/3306/mysql.sock
pid-file = /data/mysqldata/3306/mysql.pid
basedir = /usr/local/mysql
datadir = /data/mysqldata/3306/data
tmpdir = /data/mysqldata/3306/tmp
open_files_limit = 60000
explicit_defaults_for_timestamp
server-id = 1203306
lower_case_table_names = 1
character-set-server = utf8
federated
#sql_mode=STRICT_TRANS_TABLES
max_connections = 1000
max_connect_errors = 100000
interactive_timeout = 86400
wait_timeout = 86400
sync_binlog=0
back_log=100
default-storage-engine = InnoDB
log_slave_updates = 1

#*********** Logs related settings ***********
log-bin = /data/mysqldata/3306/binlog/mysql-bin
binlog_format= mixed
binlog_cache_size=32m
max_binlog_cache_size=64m
max_binlog_size=512m
long_query_time = 1
log_output = FILE
log-error = /data/mysqldata/3306/mysql-error.log
slow_query_log = 1
slow_query_log_file = /data/mysqldata/3306/slow_statement.log
#log_queries_not_using_indexes
general_log = 0
general_log_file = /data/mysqldata/3306/general_statement.log
#expire-logs-days = 14
binlog_expire_logs_seconds = 1728000
relay-log = /data/mysqldata/3306/binlog/relay-bin
relay-log-index = /data/mysqldata/3306/binlog/relay-bin.index
#****** MySQL Replication New Feature*********
master-info-repository=TABLE
relay-log-info-repository=TABLE
relay-log-recovery
#*********** INNODB Specific options ***********
innodb_buffer_pool_size = 2048M
transaction-isolation=REPEATABLE-READ
innodb_buffer_pool_instances = 8
innodb_file_per_table = 1
innodb_data_home_dir = /data/mysqldata/3306/innodb_ts
innodb_data_file_path = ibdata1:2048M:autoextend
innodb_thread_concurrency = 8
innodb_log_buffer_size = 16M
innodb_log_file_size = 128M
innodb_log_files_in_group = 3
innodb_log_group_home_dir = /data/mysqldata/3306/innodb_log
innodb_flush_log_at_trx_commit = 2
innodb_max_dirty_pages_pct = 70
innodb_flush_method=O_DIRECT
[mysql]
no-auto-rehash
default-character-set=gbk
prompt = (\u@\h) [\d]>\_

9. 初始化 MySQL 数据库

$/usr/local/mysql/bin/mysqld –defaults-file=/data/mysqldata/3306/my.cnf –initialize –user=mysql

10. 启动 mysql 服务

$/usr/local/mysql/bin/mysqld_safe –defaults-file=/data/mysqldata/3306/my.cnf –user=mysql &

11. 登陆数据库

备注: 密码来自于 error log 日志,明细如下:
2018-05-16T07:17:57.335486Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: j<ds.k;9j8ra

$/usr/local/mysql/bin/mysql -uroot -p’j<ds.k;9j8ra’

12. 数据库一些基本权限配置

•修改 root 账号密码:

ALTER USER ‘root’@’localhost’ IDENTIFIED WITH sha256_password BY ‘zsd@7101’ PASSWORD EXPIRE INTERVAL 360 DAY;

•查看目前的用户账号

(root@localhost) [(none)]> select user,host from mysql.user;
+——————+———–+
| user            | host      |
+——————+———–+
| mysql.infoschema | localhost |
| mysql.session    | localhost |
| mysql.sys        | localhost |
| root            | localhost |
+——————+———–+

正文完
星哥玩云-微信公众号
post-qrcode
 0
星锅
版权声明:本站原创文章,由 星锅 于2022-01-22发表,共计5489字。
转载说明:除特殊说明外本站文章皆由CC-4.0协议发布,转载请注明出处。
【腾讯云】推广者专属福利,新客户无门槛领取总价值高达2860元代金券,每种代金券限量500张,先到先得。
阿里云-最新活动爆款每日限量供应
评论(没有评论)
验证码
【腾讯云】云服务器、云数据库、COS、CDN、短信等云产品特惠热卖中