Centos7 编译安装mariadb-10.1.22

mariadb-10.1.22 源码编译安装

下载文件https://mariadb.com/

1.安装开发环境

yum groupinstall "Development Tools"

安装需要包：

yum install -y ncurses-devel openssl-devel openssl

2.安装cmake

tar -xf cmake-3.8.0.tar.gzcd cmake-3.8.0./bootstrapmakemake install

3.安装前准备

3.1.准备目录

mkdir -pv /data/mysql/3306/{data,logs/{binlog,relaylog}}

3.2.添加用户

groupadd mysqluseradd -s /sbin/nologin -g mysql -M mysqlchown mysql:mysql /data/mysql/3306/ -R

4.编译安装

# tar -xf mariadb-10.1.22.tar.gz # cd mariadb-10.1.22# cmake \-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \-DMYSQL_DATADIR=/data/mysql/3306/data \-DSYSCONFDIR=/etc \-DMYSQL_USER=mysql \-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# make# make install

5.安装完环境准备

# chmod +w /usr/local/mysql/# chown -R mysql:mysql /usr/local/mysql/

6.拷贝配置文件并修改

# cp support-files/my-large.cnf /etc/my.cnf

# vim /etc/my.cnf

增加如下：

datadir = /data/mysql/3306/datainnodb_flush_log_at_trx_commit = 2innodb_file_per_table = ONskip_name_resolve = ON

查看配置文件：

vim /etc/my.cnf[client]port            = 3306socket          = /tmp/mysql.sock[mysqld]port            = 3306socket          = /tmp/mysql.sockskip-external-lockingkey_buffer_size = 256Mmax_allowed_packet = 1Mtable_open_cache = 256sort_buffer_size = 1Mread_buffer_size = 1Mread_rnd_buffer_size = 4Mmyisam_sort_buffer_size = 64Mthread_cache_size = 8query_cache_size= 16Mthread_concurrency = 8log-bin=mysql-binbinlog_format=mixedserver-id       = 1datadir = /data/mysql/3306/datainnodb_data_home_dir = /data/mysql/3306/datainnodb_data_file_path = ibdata1:10M:autoextendinnodb_log_group_home_dir = /data/mysql/3306/datainnodb_buffer_pool_size = 256Minnodb_additional_mem_pool_size = 20Minnodb_log_file_size = 64Minnodb_log_buffer_size = 8Minnodb_flush_log_at_trx_commit = 2innodb_lock_wait_timeout = 50innodb_file_per_table = ONskip_name_resolve = ON[mysqldump]quickmax_allowed_packet = 16M[mysql]no-auto-rehash[myisamchk]key_buffer_size = 128Msort_buffer_size = 128Mread_buffer = 2Mwrite_buffer = 2M[mysqlhotcopy]interactive-timeout

7.初始化mysql

# scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/data/mysql/3306/data/ --defaults-file=/etc/my.cnf

查看初始化结果：

# ls /data/mysql/3306/data/aria_log.00000001  ibdata1      ib_logfile1  mysql-bin.000001  mysql-bin.000003  mysql-bin.state     testaria_log_control   ib_logfile0  mysql        mysql-bin.000002  mysql-bin.index   performance_schema

8.启动服务

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

9.添加环境变量

# vim /etc/profileexport PATH=$PATH:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin:/usr/local/mysql/bin

重读环境变量

source /etc/profile

10.初始化数据库用户表

# mysqlWelcome to the MariaDB monitor.  Commands end with ; or \g.Your MariaDB connection id is 4Server version: 10.1.22-MariaDB Source distributionCopyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.MariaDB [(none)]> use mysqlDatabase changedMariaDB [mysql]> delete from user where host='localhost.localdomain' or host='127.0.0.1' or host='::1' or user='';Query OK, 5 rows affected (0.00 sec)