mariadb-10.1.22 源码编译安装

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

1.安装开发环境

yumgroupinstall"DevelopmentTools"

安装需要包：

yuminstall-yncurses-developenssl-developenssl

2.安装cmake

tar-xfcmake-3.8.0.tar.gzcdcmake-3.8.0./bootstrapmakemakeinstall

3.安装前准备

3.1.准备目录

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

3.2.添加用户

groupaddmysqluseradd-s/sbin/nologin-gmysql-Mmysqlchownmysql:mysql/data/mysql/3306/-R

4.编译安装

#tar-xfmariadb-10.1.22.tar.gz#cdmariadb-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#makeinstall

5.安装完环境准备

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

6.拷贝配置文件并修改

#cpsupport-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.00000001ibdata1ib_logfile1mysql-bin.000001mysql-bin.000003mysql-bin.statetestaria_log_controlib_logfile0mysqlmysql-bin.000002mysql-bin.indexperformance_schema

8.启动服务

#cpsupport-files/mysql.server/etc/rc.d/init.d/mysqld#chmod+x/etc/rc.d/init.d/mysqld#chkconfig--addmysqld#servicemysqldstart

9.添加环境变量

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

重读环境变量

source/etc/profile

10.初始化数据库用户表

#mysqlWelcometotheMariaDBmonitor.Commandsendwith;or\g.YourMariaDBconnectionidis4Serverversion:10.1.22-MariaDBSourcedistributionCopyright(c)2000,2016,Oracle,MariaDBCorporationAbandothers.Type'help;'or'\h'forhelp.Type'\c'toclearthecurrentinputstatement.MariaDB[(none)]>usemysqlDatabasechangedMariaDB[mysql]>deletefromuserwherehost='localhost.localdomain'orhost='127.0.0.1'orhost='::1'oruser='';QueryOK,5rowsaffected(0.00sec)