MySQL 5.6源码编译安装流程

冷不防 2024-04-18 00:45 60阅读 0赞

(1) 关闭防火墙和Selinux  
\[root@localhost ~\]\# service iptables status  
iptables: Firewall is not running.  
\[root@localhost ~\]\# cat /etc/selinux/config   
  
\# This file controls the state of SELinux on the system.  
\# SELINUX= can take one of these three values:  
\#     enforcing - SELinux security policy is enforced.  
\#     permissive - SELinux prints warnings instead of enforcing.  
\#     disabled - No SELinux policy is loaded.  
SELINUX=disabled  
\[root@localhost ~\]\# chkconfig iptables off  
  
(2) 下载MySQL 5.6源码包  
https://dev.mysql.com/downloads/mysql/5.6.html\#downloads   
下载完毕后，上传源码包到服务器上  
  
(3) 添加用户和组  
\[root@localhost ~\]\# groupadd mysql  
\[root@localhost ~\]\# useradd -d /home/mysql -g mysql -m mysql  
\[root@localhost ~\]\# passwd mysql  
  
配置环境变量  
\[root@localhost ~\]\# su - mysql  
\[mysql@localhost ~\]$ vim .bash\_profile   
\[mysql@localhost ~\]$ cat .bash\_profile   
\# .bash\_profile  
  
\# Get the aliases and functions  
if \[ -f ~/.bashrc \]; then  
. ~/.bashrc  
fi  
  
\# User specific environment and startup programs  
  
PATH=$PATH:$HOME/bin:/mysql\_software\_56/bin  
  
export PATH  
  
(4) 创建相关目录  
创建软件目录  
\[root@localhost ~\]\# mkdir  /mysql\_software\_56  
  
创建数据文件目录和日志目录  
\[root@localhost ~\]\# mkdir -p /my3306/data  
\[root@localhost ~\]\# mkdir -p /my3306/log/iblog  
\[root@localhost ~\]\# mkdir -p /my3306/log/binlog  
  
创建存放Pid和临时文件目录  
\[root@localhost ~\]\# mkdir -p /my3306/run  
\[root@localhost ~\]\# mkdir -p /my3306/tmp  
  
更改权限  
\[root@localhost ~\]\# chown -R mysql:mysql /my3306  
\[root@localhost ~\]\# chmod -R 755 /my3306  
  
(5) 解压MySQL 5.6安装包并安装cmake  
\[root@localhost ~\]\# cd /install/  
\[root@localhost install\]\# tar xvfz mysql-5.6.37.tar.gz  
  
\[root@localhost install\]\# yum install -y cmake gcc gcc-c++ ncurses-devel zlib libxml openssl  
  
(6) 编译并安装  
\[root@localhost install\]\# cd mysql-5.6.37  
\[root@localhost mysql-5.6.37\]\# cmake . -DCMAKE\_INSTALL\_PREFIX=/mysql\_software\_56 \\  
> -DINSTALL\_DATADIR=/my3306/data \\  
> -DDEFAULT\_CHARSET=utf8 \\  
> -DDEFAULT\_COLLATION=utf8\_general\_ci \\  
> -DEXTRA\_CHARSETS=all \\  
> -DWITH\_SSL=yes \\  
> -DWITH\_EMBEDDED\_SERVER=1 \\  
> -DWITH\_MYISAM\_STORAGE\_ENGINE=1 \\  
> -DWITH\_INNOBASE\_STORAGE\_ENGINE=1 \\  
> -DWITH\_FEDERATED\_STORAGE\_ENGINE=1 \\  
> -DWITH\_ARCHIVE\_STORAGE\_ENGINE=1 \\  
> -DWITH\_BLACKHOLE\_STORAGE\_ENGINE=1 \\  
> -DWITHOUT\_EXAMPLE\_STORAGE\_ENGINE=1 \\  
> -DWITH\_PARTITION\_STORAGE\_ENGINE=1 \\  
> -DWITH\_PERFSCHEMA\_STORAGE\_ENGINE=1 \\  
> -DMYSQL\_UNIX\_ADDR=/my3306/run/mysql.sock \\  
> -DMYSQL\_TCP\_PORT=3306 \\  
> -DSYSCONFDIR=/etc \\  
> -DENABLED\_LOCAL\_INFILE=ON \\  
> -DCOMPILATION\_COMMENT='MySQL 5.6 production environment' \\  
> -DWITH\_READLINE=ON  
  
\[root@localhost mysql-5.6.37\]\# make  
\[root@localhost mysql-5.6.37\]\# make install  
  
(7) 配置MySQL参数文件  
\[root@localhost tmp\]\# cat /etc/my\_5.6\_3306.cnf   
\[client\]  
port=3306  
socket=/my3306/run/mysql.sock  
  
\[mysql\]  
pid\_file=/my3306/run/mysqld.pid  
  
\[mysqld\]  
autocommit=1  
general\_log=off  
explicit\_defaults\_for\_timestamp=true  
  
\# system  
basedir=/mysql\_software\_56  
datadir=/my3306/data  
max\_allowed\_packet=1g  
max\_connections=3000  
max\_user\_connections=2800  
open\_files\_limit=65535  
pid\_file=/my3306/run/mysqld.pid  
port=3306  
server\_id=101  
skip\_name\_resolve=ON  
socket=/my3306/run/mysql.sock  
tmpdir=/my3306/tmp  
  
\#binlog  
log\_bin=/my3306/log/binlog/binlog  
binlog\_cache\_size=32768  
binlog\_format=row  
expire\_logs\_days=7  
log\_slave\_updates=ON  
max\_binlog\_cache\_size=2147483648  
max\_binlog\_size=524288000  
sync\_binlog=100  
  
\#logging  
log\_error=/my3306/log/error.log  
slow\_query\_log\_file=/my3306/log/slow.log  
log\_queries\_not\_using\_indexes=0  
slow\_query\_log=1  
log\_slave\_updates=ON  
log\_slow\_admin\_statements=1  
long\_query\_time=1  
  
\#relay  
relay\_log=/my3306/log/relaylog  
relay\_log\_index=/my3306/log/relay.index  
relay\_log\_info\_file=/my3306/log/relay-log.info  
  
\#slave  
slave\_load\_tmpdir= /my3306/tmp  
slave\_skip\_errors=OFF  
  
\#innodb  
innodb\_data\_home\_dir=/my3306/log/iblog  
innodb\_log\_group\_home\_dir=/my3306/log/iblog  
innodb\_adaptive\_flushing=ON  
innodb\_adaptive\_hash\_index=ON  
innodb\_autoinc\_lock\_mode=1  
innodb\_buffer\_pool\_instances=8  
  
\#default  
innodb\_change\_buffering=inserts  
innodb\_checksums=ON  
innodb\_buffer\_pool\_size= 128M  
innodb\_data\_file\_path=ibdata1:32M;ibdata2:16M:autoextend  
innodb\_doublewrite=ON  
innodb\_file\_format=Barracuda  
innodb\_file\_per\_table=ON  
innodb\_flush\_log\_at\_trx\_commit=1  
innodb\_flush\_method=O\_DIRECT  
innodb\_io\_capacity=1000  
innodb\_lock\_wait\_timeout=10  
innodb\_log\_buffer\_size=100M  
innodb\_log\_file\_size=1048576000  
innodb\_log\_files\_in\_group=4  
innodb\_max\_dirty\_pages\_pct=60  
innodb\_open\_files=60000  
innodb\_purge\_threads=1  
innodb\_read\_io\_threads=4  
innodb\_stats\_on\_metadata=OFF  
innodb\_support\_xa=ON  
innodb\_use\_native\_aio=OFF  
innodb\_write\_io\_threads=10  
  
\[mysqld\_safe\]  
datadir=/my3306/data  
  
(8) 初始化MySQL  
\[root@localhost mysql\_software\_56\]\# /mysql\_software\_56/scripts/mysql\_install\_db  --defaults-file=/etc/my\_5.6\_3306.cnf --datadir=/my3306/data/ --user=mysql  
Installing MySQL system tables...2017-07-29 02:01:18 0 \[Note\] Ignoring --secure-file-priv value as server is running with --bootstrap.  
2017-07-29 02:01:18 0 \[Note\] ./bin/mysqld (mysqld 5.6.37-log) starting as process 50198 ...  
  
OK  
  
Filling help tables...2017-07-29 02:03:47 0 \[Note\] Ignoring --secure-file-priv value as server is running with --bootstrap.  
2017-07-29 02:03:47 0 \[Note\] ./bin/mysqld (mysqld 5.6.37-log) starting as process 50239 ...  
OK  
  
To start mysqld at boot time you have to copy  
support-files/mysql.server to the right place for your system  
  
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !  
To do so, start the server, then issue the following commands:  
  
  /mysql\_software\_56/bin/mysqladmin -u root password 'new-password'  
  /mysql\_software\_56/bin/mysqladmin -u root -h localhost.localdomain password 'new-password'  
  
Alternatively you can run:  
  
  /mysql\_software\_56/bin/mysql\_secure\_installation  
  
which will also give you the option of removing the test  
databases and anonymous user created by default.  This is  
strongly recommended for production servers.  
  
See the manual for more instructions.  
  
You can start the MySQL daemon with:  
  
  cd . ; /mysql\_software\_56/bin/mysqld\_safe &  
  
You can test the MySQL daemon with mysql-test-run.pl  
  
  cd mysql-test ; perl mysql-test-run.pl  
  
Please report any problems at http://bugs.mysql.com/  
  
The latest information about MySQL is available on the web at  
  
  http://www.mysql.com  
  
Support MySQL by buying support/licenses at http://shop.mysql.com  
  
New default config file was created as ./my.cnf and  
will be used by default by the server when you start it.  
You may edit this file to change server settings  
  
WARNING: Default config file /etc/my.cnf exists on the system  
This file will be read by default by the MySQL server  
If you do not want to use this, either remove it, or use the  
\--defaults-file argument to mysqld\_safe when starting the server  
  
启动数据库  
\[root@localhost mysql\_software\_56\]\# /mysql\_software\_56/bin/mysqld\_safe --defaults-file=/etc/my\_5.6\_3306.cnf --user=mysql &  
\[1\] 50284  
\[root@localhost mysql\_software\_56\]\# 170729 02:07:56 mysqld\_safe Logging to '/my3306/log/error.log'.  
170729 02:07:56 mysqld\_safe Starting mysqld daemon with databases from /my3306/data

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26506993/viewspace-2142773/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26506993/viewspace-2142773/