System Platform:
CentOS Release 6.9 (Final)
Kernel 2.6.32-696.el6.x86_64
1. Go to the official website to download the appropriate source package
http://mariadb.org/
Mariadb-10.2.12.tar.gz
Check that the database is installed in the system.
#rpm -qa|grep MariaDB#rpm -qa|grep mysql
CMake The latest version requires C++11 support, gcc4.8 is not included below, and the CentOS 6.9 version is as follows
#rpm -qa|grep gccgcc-4.4.7-18.el6.x86_64libgcc-4.4.7-18.el6.x86_64gcc-gfortran-4.4.7-18.el6.x86_64gcc-c++-4.4.7-18.el6.x86_64
2. Compiling with the clang compiler
Clang advantages over the GCC compiler:
编译速度更快编译产出更小出错提示更友好
3. Installing dependent Packages
# yum install cmake ncurses-devel libaio-devel openssl-devel clang -y #其中clang需要EPEL源,请自行参考https://mirrors.aliyun.com/help/centos#cmake --versioncmake version 2.8.12.2
4. Unzip the MARIADB package to any temporary directory
#tar xvf mariadb-10.2.12.tar.gz -C /app/sdb/
5. Compile and install MARIADB
#mkdir /app/sdb/db-build#cd /app/sdb/db-build/以下的编译参数,根据自己的需求定制#cmake /app/sdb/mariadb-10.2.12 -DCMAKE_INSTALL_PREFIX=/usr/local/mariadb-10.2.12 -DSYSCONFDIR=/etc -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_EXTRA_CHARSETS=all -DWITH_READLINE=1 -DWITH_SSL=system -DWITH_ZLIB=system -DWITH_EMBEDDED_SERVER=1 -DENABLED_LOCAL_INFILE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_DEBUG=0我使用的AUSU笔记本是 I5 1CPU 4核,4GB内存,20分钟编译安装完成。# make -j 8 && make install编译完成占用空间为3.3GB
6. Create a soft link MySQL point to the extracted directory
#cd /usr/local/#ln -s mariadb-10.2.12 mysql
7. Create a group and account for MySQL
#groupadd -g 500 mysql#useradd -g 500 -u 500 -s /sbin/nologin -M mysql
8. Modify the MySQL folder owner and owning group
#chown -R mysql.mysql /usr/local/mysql/
9. Add path to environment variable
#echo ‘PATH=/usr/local/mysql/bin:$PATH‘ >> /etc/profile.d/mysql.sh检查文件#cat /etc/profile.d/mysql.sh加载环境变量文件 并检查#source /etc/profile.d/mysql.sh#echo $PATH#mysql -Vmysql Ver 15.1 Distrib 10.2.12-MariaDB, for Linux (x86_64) using readline 5.1
10. Create a database Hosting folder and Modify permissions
#mkdir -pv /data/sqldb/3306/{log,data,pid,socket,tmp}#chown -R mysql.mysql /data/sqldb/#chmod -R 770 /data/sqldb/
11. Copy the Master profile my.cnf
This is the first to confirm how much memory is in the machine so that you can use a reference template.
#grep memory support-files/*
Find a template for native memory
The native memory is 512M, so the my-large.cnf configuration file is selected
#\cp /usr/local/mysql/support-files/my-large.cnf /etc/my.cnf
12. Modify the configuration file
# vim /etc/my.cnf[mysqld]port = 3306socket = /tmp/mysql.sockpid-file = /data/sqldb/3306/pid/mysql.piddatadir = /data/sqldb/3306/datatmpdir = /data/sqldb/3306/tmpinnodb_file_per_table = 1skip_name_resolve = 1log-error = /data/sqldb/3306/log/error.log
13. Installing database-related files
#cd /usr/local/mysql/
To view the installation parameters for the installation program
#/usr/local/mysql/scripts/mysql_install_db --help#./scripts/mysql_install_db --defaults-file=/etc/my.cnf --user=mysql
14. Copy start service script to/etc/init.d directory
#cp support-files/mysql.server /etc/init.d/mysqld
15. Add the boot service and start the MYSQLD service
#chkconfig --add mysqld#service mysqld startStarting MySQL.180128 23:54:38 mysqld_safe Logging to ‘/data/sqldb/3306/log/error.log‘.180128 23:54:38 mysqld_safe Starting mysqld daemon with databases from /data/sqldb/3306/data [ OK ]#lsof -i:3306COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAMEmysqld 2067 mysql 21u IPv6 12603 0t0 TCP *:mysql (LISTEN)
16. Make the Security Configuration
#/usr/local/mysql/bin/mysql_secure_installationEnter current password for root 默认为空Set root password 设置mysql root密码Remove anonymous users 是否移除匿名用户登录Disallow root login remotely 是否禁止root远程登录Remove test database and access to it? 是否移除test数据和test账号Reload privilege tables now? 是否立即更新权限Thanks for using MariaDB!
17. Testing
#mysql -u root -pEnter password: Welcome to the MariaDB monitor. Commands end with ; or \g.Your MariaDB connection id is 19Server version: 10.2.12-MariaDB-log Source distributionCopyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.Type ‘help;‘ or ‘\h‘ for help. Type ‘\c‘ to clear the current input statement.MariaDB [(none)]> use mysql;
Set up an account to test Telnet
MariaDB [mysql]> grant all on *.* to ‘hunk‘@‘%‘ identified by ‘123456‘;Query OK, 0 rows affected (0.00 sec)MariaDB [mysql]> flush privileges;Query OK, 0 rows affected (0.00 sec)#mysql -uhunk -p123456 -h192.168.5.128Welcome to the MariaDB monitor. Commands end with ; or \g.Your MariaDB connection id is 21Server version: 10.2.12-MariaDB-log Source distributionCopyright (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)]>
CentOS 6.9 clang3.4-based compilation installation mariadb-10.2.12