mysql5.7.24编译安装_MYSQL5.7.24编译安装

1.解压源代码包

#tar zxvf mysql-boost-8.0.17.tar.gz

2.安装依赖包

#yum -y install gcc gcc-c++ ncurses ncurses-devel bison libgcrypt perl make cmake

3.建立用户组和用户

#groupadd mysql

#useradd mysql

4.建立文件夹，并赋权

mkdir /usr/local/mysql

mkdir /data

mkdir -r /data/mysql

chown -R mysql /usr/local/mysql

chown -R mysql /data

chmod -R 577 /usr/local/mysql

chmod -R 577 /data

5.编译MYSQL

#cmake -DDOWNLOAD_BOOST=1 \

-DWITH_BOOST=/usr/local \

-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \

-DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock \

-DDEFAULT_CHARSET=utf8 \

-DDEFAULT_COLLATION=utf8_general_ci \

-DWITH_MYISAM_STORAGE_ENGINE=1 \

-DWITH_INNOBASE_STORAGE_ENGINE=1 \

-DENABLED_LOCAL_INFILE=1 \

-DMYSQL_DATADIR=/data \

-DMYSQL_TCP_PORT=3306

# make && make install

配置MY.CNF

$vi /etc/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初始化MYSQL

$/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf --initialize --user=mysql.

启动MYSQL

$/usr/local/mysql/bin/mysqld_safe --defaults-file=/etc/my.cnf --user=mysql &登陆MYSQL

usr/local/mysql/bin/mysql -uroot -p$PASSWORD