Mariadb 10.2.30 安裝（二進(jìn)制、源碼編譯）

----------Mariadb 10.2.30 安裝-----------

一、源碼編譯安裝

1、安裝依賴

#mkdir?-pv?/data_linux/mysql/3306/{data,logs/{binlog,relaylog}}
#yum?-y?install?libaio?libaio-devel?\
bison?bison-devel?zlib-devel?openssl?\
openssl-devel?ncurses?ncurses-devel?\
libcurl-devel?libarchive-devel?boost?\
boost-devel?lsof?wget?gcc?gcc-c++?make?\
cmake?perl?kernel-headers?kernel-devel?pcre-devel

2、下載源碼包

#wget?http://mirror.rackspace.com/mariadb//mariadb-10.2.30/source/mariadb-10.2.30.tar.gz

3、編譯安裝

#cmake??\
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql?\
-DMYSQL_DATADIR=/data_linux/mysql/3306/data?\
-DSYSCONFDIR=/etc?\
-DWITH_INNOBASE_STORAGE_ENGINE=1?\
-DWITH_ARCHIVE_STORAGE_ENGINE=1?\
-DWITH_BLACKHOLE_STORAGE_ENGINE=1?\
-DWITH_READLINE=1?\
-DWITH_SSL=system?\
-DWITH_ZLIB=system?\
-DWITH_LIBWRAP=0?\
-DMYSQL_UNIX_ADDR=/tmp/mysql.sock?\
-DDEFAULT_CHARSET=utf8?\
-DDEFAULT_COLLATION=utf8_general_ci?\
-DMYSQL_UNIX_ADDR=/tmp/mysql.sock?\
-DENABLED_LOCAL_INFILE=1?\
-DWITH_PARTITION_STORAGE_ENGINE=1?\
-DWITH_DEBUG=0?\
-DWITHOUT_MROONGA_STORAGE_ENGINE=1
如果報錯，按照報錯提示安裝相應(yīng)的依賴，然后刪除當(dāng)前目錄下的CMakeCache.txt文件后，重新編譯，直到無error報錯。
#make
#make?install

4、安裝完環(huán)境準(zhǔn)備

#chown?-R?mysql:mysql?/usr/local/mysql/
#cp?support-files/my-large.cnf?/etc/my.cnf
#[root@deploy?mariadb-10.2.30]#?cat?/etc/my.cnf
[client]
port????????????????????=?3306
socket????????????????????=?/tmp/mysql.sock
[mysqld]
port????????????????????=?3306
socket????????????????????=?/tmp/mysql.sock
skip-external-locking
key_buffer_size????????????????=?256M
max_allowed_packet?????????????=?1M
table_open_cache???????????????=?256
sort_buffer_size???????????????=?1M
read_buffer_size???????????????=?1M
read_rnd_buffer_size???????????=?4M
myisam_sort_buffer_size????????=?64M
thread_cache_size??????????????=?8
query_cache_size????????????????=?16M
thread_concurrency?????????????=?8
log-bin=mysql-bin
binlog_format???????????????????=?mixed
server-id????????????????????=?1
datadir????????????????????????=?/data_linux/mysql/3306/data
innodb_data_home_dir???????????=?/data_linux/mysql/3306/data?
innodb_data_file_path??????????=?ibdata1:10M:autoextend?
innodb_log_group_home_dir??????=?/data_linux/mysql/3306/data?
innodb_buffer_pool_size????????=?256M?
innodb_log_file_size???????????=?64M?
innodb_log_buffer_size?????????=?8M?
innodb_flush_log_at_trx_commit?=?2
innodb_lock_wait_timeout???????=?50
innodb_file_per_table??????????=?ON?
skip_name_resolve??????????????=?ON?
[mysqldump]
quick
max_allowed_packet?????????????=?16M
[mysql]
no-auto-rehash
[myisamchk]
key_buffer_size????????????????=?128M
sort_buffer_size???????????????=?128M
read_buffer????????????????????=?2M
write_buffer???????????????????=?2M
[mysqlhotcopy]
interactive-timeout

5、初始化服務(wù)

#cp?support-files/mysql.server?/etc/rc.d/init.d/mysqld
#chmod?+x?/etc/rc.d/init.d/mysqld
#/etc/init.d/mysqld?start

二、二進(jìn)制安裝

? 二進(jìn)制包下載地址：

wget?https://downloads.mariadb.org/interstitial/mariadb-10.2.30/bintar-linux-systemd-x86_64/mariadb-10.2.30-linux-systemd-x86_64.tar.gz/from/http%3A//mirror.rackspace.com/mariadb/

1.規(guī)劃：

數(shù)據(jù)文件存儲位置 /data/mysql/data

日志文件存儲位置 /home/logs/mysql

binlog文件存儲位置 /data/mysql

2.創(chuàng)建目錄和授權(quán)：

mkdir?-p?/data/mysql/data
mkdir?-p?/home/logs/mysql
useradd?mysql
chown?-R?mysql:mysql?/data/mysql
chown?-R?mysql:mysql?/home/logs

3、解壓文件

#tar?-xzvf?mariadb-10.2.30-linux-systemd-x86_64.tar.gz?-C?/usr/local
#mv?/usr/local/mariadb-10.2.30-linux-systemd-x86_64?/usr/local/mysql

4、配置文件

#cat?/etc/my.cnf
[client]
socket?????????????????=?/tmp/mysql.sock
[mysqld]
user??????????????????=?mysql
datadir?????????????????=?/data/mysql/data
port???????????????????=?3306
pid-file????????????????=?/tmp/mysql.pid
socket?????????????????=?/tmp/mysql.sock
server-id????????????????=?2
default-storage-engine?????????=?InnoDB
character-set-client-handshake?????????=?FALSE
character-set-server???????????=?utf8mb4
collation-server????????????=?utf8mb4_unicode_ci
init_connect??????????????=?'SET?NAMES?utf8mb4'
performance-schema-instrument??????????=?'memory/%=COUNTED'
interactive_timeout???????????=?172800
wait_timeout??????????????=?172800
tmp-table-size?????????????=?8M
max-heap-table-size???????????=?4M
query-cache-type????????????=?0
query-cache-size????????????=?64M
max-connections?????????????=?80
thread-cache-size????????????=?50
open-files-limit????????????=?65535
table-definition-cache?????????=?4096
table-open-cache????????????=?10
innodb-flush-method???????????=?O_DIRECT
innodb-log-files-in-group?????????=?2
innodb-log-file-size??????????=?256M
innodb-flush-log-at-trx-commit?????????=?1
innodb-file-per-table??????????=?1
innodb-buffer-pool-size?????????=?3G
log-error????????????????=?/home/logs/mysql/mysql_error.log
slow-query-log?????????????=?1
slow-query-log-file???????????=?/home/logs/mysql/mysql_slow.log
long_query_time?????????????=?0.2
min_examined_row_limit?????????=?100
max-allowed-packet????????????=?16M
max-connect-errors???????????=?1000000
#skip-name-resolve
sql-mode????????????????=?ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
sysdate-is-now?????????????=?1
innodb-strict-mode???????????=?1
sort_buffer_size????????????=?2M
join_buffer_size????????????=?2M
key_buffer_size?????????????=?64M
read_buffer_size????????????=?512K
read_rnd_buffer_size??????????=?256K
binlog_cache_size????????????=?2M
thread_stack??????????????=?256K
bulk_insert_buffer_size??????????=?64M
lower_case_table_names??????????=?1
relay-log????????????????=?/home/logs/mysql/mysql_relay.log
relay_log_recovery???????????=?1
slave-net-timeout????????????=?60
relay_log_purge?????????????=?0
sync_binlog???????????????=?1
log-bin?????????????????=?/data/mysql/mysql_bin.log
binlog_format??????????????=?ROW
expire-logs-days????????????=?2
relay_log_recovery???????????=?1
slave_skip_errors????????????=?ddl_exist_errors
explicit_defaults_for_timestamp????????=?true

5、數(shù)據(jù)初始化

#/usr/local/mysql/scripts/mysql_install_db?--basedir=/usr/local/mysql??--datadir=/data/mysql/data?--user=mysql

6、設(shè)置啟動文件

#?cp?/usr/local/mysql/support-files/mysql.server??/etc/init.d/mysql

7、啟動

#/etc/init.d/mysql?start

8、連接

explicit_defaults_for_timestamp?=?true
[root@deploy?local]#?mysql
Welcome?to?the?MariaDB?monitor.??Commands?end?with?;?or?\g.
Your?MariaDB?connection?id?is?12
Server?version:?10.2.30-MariaDB-log?Source?distribution
Copyright?(c)?2000,?2018,?Oracle,?MariaDB?Corporation?Ab?and?others.
Type?'help;'?or?'\h'?for?help.?Type?'\c'?to?clear?the?current?input?statement.
MariaDB?[(none)]>