percona-server-5.7.11-4源码安装手册-创新互联

MySQL5.7出来有段时间了，一直没时间玩玩，这两天有时间下了percona的装了下，发现还是有很多好玩的东西，下面是简单的源码安装记录（二进制安装比较简单，源码安装对OS包的依赖比较严重，尤其是zlib包，建议用RHEL6.5以上版本，本实验用的是centos7）
环境描述：

安装软件

成都创新互联公司长期为上千家客户提供的网站建设服务，团队从业经验10年，关注不同地域、不同群体，并针对不同对象提供差异化的产品和服务；打造开放共赢平台，与合作伙伴共同营造健康的互联网生态环境。为庐山企业提供专业的成都网站制作、做网站、外贸营销网站建设，庐山网站改版等技术服务。拥有十多年丰富建站经验和众多成功案例,为您定制开发。

描述

操作系统

CentOS7_x86_64 (CentOS Linux release 7.2.1511 (Core))

数据库软件

percona-server-5.7.11-4.tar.gz（源码安装包）

Percona-Server-5.7.11-4-Linux.x86_64.ssl101.tar.gz(二进制安装包)

软件下载：

/tupian/20230522/percona-server />
依赖包安装：
rpm -q gcc gcc-c++ ncurses-devel cmake libaio bison zlib-devel
利用Yum安装依赖包 yum install package_name -y
[root@localhost home]# cat /etc/yum.repos.d/CentOS-Base.repo
[Base]
name=CentOS7 ISO Base
baseurl=file:///mnt/cdrom
enabled=1
gpgcheck=0

上传并解压安装包：
[root@localhost soft]# cd /tools/soft/MySQL/
[root@localhost MySQL]# tar -xzvf percona-server-5.7.11-4.tar.gz

创建授权用户：
/usr/sbin/groupadd mysql
/usr/sbin/useradd mysql -g mysql -d /home/mysql -s /sbin/nologin
mkdir /home/mysql/data
mkdir /home/mysql/log
mkdir /home/mysql/tmp
mkdir /home/mysql/binlog
mkdir /usr/local/mysql

chown -R mysql.mysql /usr/local/mysql

chown -R mysql.mysql /home/mysql

源码包编译安装：
cd /tools/soft/
tar -xzvf boost_1_59_0.tar.gz

mv boost_1_59_0 /usr/local/boost

cd percona-server-5.7.11-4
cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_UNIX_ADDR=/home/mysql/mysql.sock \
-DWITH_BOOST=/usr/local/boost \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_EDITLINE=bundled \
-DENABLED_LOCAL_INFILE=1 \
-DMYSQL_DATADIR=/home/mysql/data \
-DMYSQL_TCP_PORT=3306 \
-DZLIB_INCLUDE_DIR:PATH=/usr/include \
-DENABLE_DOWNLOADS=1

make -j 8
make install

初始化数据库：
cd /usr/local/mysql/
./bin/mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/home/mysql/data
./bin/mysql_ssl_rsa_setup --user=mysql --basedir=/usr/local/mysql --datadir=/home/mysql/data

配置数据库：
cd /usr/local/mysql/
cp support-files/my-default.cnf /etc/my.cnf
>/etc/my.cnf
vi /etc/my.cnf
[client]
socket=/home/mysql/mysql.sock
[mysqld]
symbolic-links=0
server_id                  = 120
default_storage_engine     = Innodb
user                       = mysql
port                       = 3306
basedir                    = /usr/local/mysql
datadir                    = /home/mysql/data
tmpdir                     = /home/mysql/tmp
socket                     = /home/mysql/mysql.sock
pid_file                   = /home/mysql/mysql.pid

# Character Sets & Collations
character_set_server       = utf8
collation_server           = utf8_general_ci

open_files_limit           = 10240
explicit_defaults_for_timestamp

# Buffer
max_allowed_packet         = 256M
max_heap_table_size        = 256M
net_buffer_length          = 8K
sort_buffer_size           = 2M
join_buffer_size           = 4M
read_buffer_size           = 2M
read_rnd_buffer_size       = 16M

#log_error
log_error                  = /home/mysql/log/error.log

#binlog
log_bin                    = /home/mysql/binlog/mysql-bin
binlog_cache_size          = 32M
max_binlog_cache_size      = 2G
max_binlog_size            = 500M
binlog_format              = mixed
log_output                 = FILE
expire_logs_days           = 5

# Slow Query Parameter
slow_query_log             = 1
long_query_time            = 3
slow_query_log_file        = /home/mysql/log/slow-query.log

# General Log
#general_log                = 0
#general_log_file           = /data/mysqldata/3307/general-query.log

# Innodb Engine Parameter
#innodb_data_file_path     = ibdata1:1G:autoextend
innodb_buffer_pool_size    = 500M
innodb_log_file_size       = 200M
innodb_log_files_in_group = 3
#innodb_flush_log_at_trx_commit = 2
innodb_lock_wait_timeout   = 20

[mysql]
no_auto_rehash

[mysqld_safe]
log-error=/home/mysql/log/error.log

配置mysql系统服务：
cd /usr/local/mysql
cp support-files/mysql.server /etc/init.d/mysql
chkconfig --add mysql
chkconfig mysql on
启动数据库：
service mysql start

本文名称：percona-server-5.7.11-4源码安装手册-创新互联
文章地址：http://cdweb.net/article/dcdeig.html

NEWS

网站建设资讯

percona-server-5.7.11-4源码安装手册-创新互联

其他资讯