如何進(jìn)行Mysql5.6或Centos6.5源碼編譯安裝

發(fā)布時(shí)間：2021-11-08 10:08:01 來(lái)源：億速云閱讀：108 作者：柒染欄目：建站服務(wù)器

這篇文章給大家介紹如何進(jìn)行Mysql5.6或Centos6.5源碼編譯安裝，內(nèi)容非常詳細(xì)，感興趣的小伙伴們可以參考借鑒，希望對(duì)大家能有所幫助。

## 說(shuō)明不同服務(wù)器需要改變 server_id ,同一臺(tái)機(jī)器上需要改變 port

1. 關(guān)閉防火墻
[root@mysql ~]# service iptables status --查看防火墻狀態(tài)
[root@mysql ~]# service iptables stop --關(guān)閉防火墻
[root@mysql ~]# chkconfig iptables off --永久關(guān)閉
[root@mysql ~]# vim /etc/sysconfig/selinux
SELINUX=disabled

2. 配置sysctl.conf
生產(chǎn)環(huán)境下建議根據(jù)情況配置，虛擬機(jī)安裝可以不設(shè)置

3. 檢查操作系統(tǒng)上是否已經(jīng)安裝了mysql，如果有進(jìn)行卸載
[root@mysql yum.repos.d]# rpm -qa |grep mysql
[root@mysql yum.repos.d]# yum remove mysql

4. 下載mysql源碼包
https://dev.mysql.com/downloads/file/?id=469012

5. 添加用戶和組
[root@mysql u01]# userdel -r mysql --刪除原先的mysql用戶 -r會(huì)刪掉附帶的group
[root@mysql u01]# groupadd mysql
[root@mysql u01]# useradd -d /home/mysql -g mysql -m mysql
[root@mysql u01]# passwd mysql
Changing password for user mysql.
New password:
BAD PASSWORD: it is based on a dictionary word
Retype new password:
passwd: all authentication tokens updated successfully.
[root@mysql u01]# id mysql
uid=500(mysql) gid=500(mysql) groups=500(mysql)

6. 配置mysql環(huán)境變量
[mysql@mysql ~]$ vim .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:/u01/my3306/bin

export PATH
[mysql@mysql ~]$ source .bash_profile

7. 創(chuàng)建目錄及授權(quán)
[root@mysql u01]# cd /u01
[root@mysql u01]# mkdir -p /u01/my3306/data
[root@mysql u01]# mkdir -p /u01/my3306/log/iblog
[root@mysql u01]# mkdir -p /u01/my3306/log/binlog
[root@mysql u01]# mkdir -p /u01/my3306/run
[root@mysql u01]# mkdir -p /u01/my3306/tmp
[root@mysql u01]# chown -R mysql:mysql /u01/my3306
[root@mysql u01]# chmod 755 /u01/my3306

8. 解壓mysql
[root@mysql u01]# tar -xzvf mysql-5.6.36.tar.gz

9. 配置yum源，安裝cmakle及一些必備的包，要求2.6版本及以上
yum install -y cmake gcc gcc-c++ ncurses-devel bison zlib libxml openssl

10. 編譯并安裝
cmake \
-DCMAKE_INSTALL_PREFIX=/u01/my3306 \
-DINSTALL_DATADIR=/u01/my3306/data \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DEXTRA_CHARSETS=all \ --
-DWITH_SSL=yes \ --安全套接字
-DWITH_EMBEDDED_SERVER=1 \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DMYSQL_UNIX_ADDR=/u01/my3306/run/mysql.sock \
-DMYSQL_TCP_PORT=3306 \
-DENABLED_LOCAL_INFILE=1 \
-DSYSCONFDIR=/etc \
-DWITH_READLINE=on

[root@mysql mysql-5.6.36]# cd mysql-5.6.36
[root@mysql mysql-5.6.36]# cmake -DCMAKE_INSTALL_PREFIX=/u01/my3306 -DINSTALL_DATADIR=/u01/my3306/data -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all -DWITH_SSL=yes -DWITH_EMBEDDED_SERVER=1 -DENABLED_LOCAL_INFILE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DMYSQL_UNIX_ADDR=/u01/my3306/run/mysql.sock -DMYSQL_TCP_PORT=3306 -DENABLED_LOCAL_INFILE=1 -DSYSCONFDIR=/etc -DWITH_READLINE=on
[root@mysql mysql-5.6.36]# make
[root@mysql mysql-5.6.36]# make install

11. 配置mysql參數(shù)
[root@mysql my3306]# pwd
/u01/my3306
[root@mysql my3306]# cat my.cnf
[client]
port=3306
socket=/u01/my3306/mysql.sock

[mysql]
pid_file=/u01/my3306/run/mysqld.pid

[mysqld]
autocommit=1
general_log=off
explicit_defaults_for_timestamp=true

# system
basedir=/u01/my3306
datadir=/u01/my3306/data
max_allowed_packet=1g
max_connections=3000
max_user_connections=2800
open_files_limit=65535
pid_file=/u01/my3306/run/mysqld.pid
port=3306
server_id=101
skip_name_resolve=ON
socket=/u01/my3306/run/mysql.sock
tmpdir=/u01/my3306/tmp

#binlog
log_bin=/u01/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=/u01/my3306/log/error.log
slow_query_log_file=/u01/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=/u01/my3306/log/relaylog
relay_log_index=/u01/my3306/log/relay.index
relay_log_info_file=/u01/my3306/log/relay-log.info

#slave
slave_load_tmpdir=/u01/my3306/tmp
slave_skip_errors=OFF #innodb
innodb_data_home_dir=/u01/my3306/log/iblog
innodb_log_group_home_dir=/u01/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=67108864
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]
[root@mysql my3306]# chown -R mysql:mysql /u01/my3306

12. 初始化mysql腳本
[root@mysql my3306]# ./scripts/mysql_install_db --defaults-file=/u01/my3306/my.cnf --datadir=/u01/my3306/data --user=mysql

13. 啟動(dòng)mysql
[mysql@mysql bin]$ ./mysqld_safe --defaults-file=/u01/my3306/my.cnf --user=mysql &
[1] 17237
[mysql@mysql bin]$ 170612 06:37:02 mysqld_safe Logging to '/u01/my3306/log/error.log'.
170612 06:37:02 mysqld_safe Starting mysqld daemon with databases from /u01/my3306/data

[mysql@mysql bin]$ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.6.36-log Source distribution

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
4 rows in set (0.10 sec)

## 說(shuō)明不同服務(wù)器需要改變 server_id ,同一臺(tái)機(jī)器上需要改變 port

2. 配置sysctl.conf
生產(chǎn)環(huán)境下建議根據(jù)情況配置，虛擬機(jī)安裝可以不設(shè)置

3. 檢查操作系統(tǒng)上是否已經(jīng)安裝了mysql，如果有進(jìn)行卸載
[root@mysql yum.repos.d]# rpm -qa |grep mysql
[root@mysql yum.repos.d]# yum remove mysql

4. 下載mysql源碼包
https://dev.mysql.com/downloads/file/?id=469012

8. 解壓mysql
[root@mysql u01]# tar -xzvf mysql-5.6.36.tar.gz

9. 配置yum源，安裝cmakle及一些必備的包，要求2.6版本及以上
yum install -y cmake gcc gcc-c++ ncurses-devel bison zlib libxml openssl

12. 初始化mysql腳本
[root@mysql my3306]# ./scripts/mysql_install_db --defaults-file=/u01/my3306/my.cnf --datadir=/u01/my3306/data --user=mysql

關(guān)于如何進(jìn)行Mysql5.6或Centos6.5源碼編譯安裝就分享到這里了，希望以上內(nèi)容可以對(duì)大家有一定的幫助，可以學(xué)到更多知識(shí)。如果覺(jué)得文章不錯(cuò)，可以把它分享出去讓更多的人看到。

向AI問(wèn)一下細(xì)節(jié)

如何進(jìn)行Mysql5.6或Centos6.5源碼編譯安裝

猜你喜歡

最新資訊

相關(guān)推薦

相關(guān)標(biāo)簽