The latest source code package based on the CentOS 6.8 Platform MARIADB Database Enterprise Edition installation

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M02/87/04/wKiom1fROZeT0kGbAABRgfYRGPs093.png "title=" Mariadb-foundation-vertical-small.png "alt=" Wkiom1frozet0kgbaabrgfyrgps093.png "/>

Installation Environment

System: CentOS 6.8 x86_64

Mariadb:enterprise 10.1.16

Resource acquisition

MARIADB Enterprise Download, access address https://mariadb.com/my_portal/download/mariadb-enterprise here need to login account to download, can register for free.

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M02/87/06/wKiom1fRdTDxTSK8AACZjQIW2kc283.png-wh_500x0-wm_3 -wmp_4-s_55652021.png "title=" Qq20160908222645.png "alt=" Wkiom1frdtdxtsk8aaczjqiw2kc283.png-wh_50 "/>

After successful login, enter the MARIADB Enterprise product download page, which provides a variety of binary and source code installation packages. Select version 10.1.16GA according to the actual needs, source code package download.

650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M01/87/06/wKiom1fRd1iD-5TEAABc-ZUlzl8769.png-wh_500x0-wm_3 -wmp_4-s_989972800.png "title=" Qq20160908223554.png "alt=" Wkiom1frd1id-5teaabc-zulzl8769.png-wh_50 "/>

Determine tar.gz package download

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M01/87/06/wKiom1fRd7uxIPClAAAOeNKp7xE748.png-wh_500x0-wm_3 -wmp_4-s_2272125205.png "title=" Qq20160908223709.png "alt=" Wkiom1frd7uxipclaaaoenkp7xe748.png-wh_50 "/>

Get, copy to the CentOS system using tools such as Wget/curl to download to the/USR/SRC directory.

Https://downloads.mariadb.com/enterprise/y21n-42b1/mariadb-enterprise/10.1.16/source/mariadb-enterprise-10.1.16.tar.gz

Download complete.

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M02/87/04/wKioL1fReH7wgqGzAAAqoDiOlIU159.png "title=" Qq20160908224053.png "alt=" Wkiol1freh7wgqgzaaaqodioliu159.png "/>

installation process

Installing the Epel Yum source

RPM-VIH http://mirrors.aliyun.com/epel/epel-release-latest-6.noarch.rpm

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M01/87/04/wKioL1fReXyjugeQAAA_km5vJ3o538.png "title=" Qq20160908224446.png "alt=" Wkiol1frexyjugeqaaa_km5vj3o538.png "/>

In the case of the Yum cache, a new cache is generated.

Yum Clean All

Yum Makecache

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M00/87/06/wKiom1fRegbxuf0FAAD2GqTLAc8976.png-wh_500x0-wm_3 -wmp_4-s_2459985373.png "title=" Qq20160908224722.png "alt=" Wkiom1fregbxuf0faad2gqtlac8976.png-wh_50 "/>

Install the necessary packages

Yum install-y ncurses-devel make CMake bison zlib zlib-devel OpenSSL openssl-devel jemalloc gcc gcc-c++

650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M01/87/04/wKioL1fRep6QoqW8AAB1uxYQzY0871.png-wh_500x0-wm_3 -wmp_4-s_681056335.png "title=" Qq20160908224956.png "alt=" Wkiol1frep6qoqw8aab1uxyqzy0871.png-wh_50 "/>

Unpack the installation package and use the CMake configuration

Tar zxf mariadb-enterprise-10.1.16.tar.gz

CD mariadb-10.1.16/

CMake. -dcmake_install_prefix=/usr/local/mysql-ddefault_sysconfdir=/usr/local/mysql/etc-dmysql_datadir=/usr/local/ Mysql/data-dmysql_tcp_port=3306-dmysql_unix_addr=/usr/local/mysql/mysql.sock-dmysql_user=mysql-denabled_local_ Infile=1-dextra_charsets=all-ddefault_charset=utf8-ddefault_collation=utf8_general_ci-dwith_readline=1-dwith_ Ssl=system-dwith_zlib=system-dwith_libwrap=0

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M02/87/06/wKiom1fRex_QiB4uAADBUoN1Hs8334.png "title=" Qq20160908225203.png "alt=" Wkiom1frex_qib4uaadbuon1hs8334.png "/>

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M02/87/06/wKiom1fRe4mAC5YEAACRi1ObCQM293.png "title=" Qq20160908225341.png "alt=" Wkiom1fre4mac5yeaacri1obcqm293.png "/>

Compile with make, because the normal compilation time is quite lengthy. In order to speed up the compilation, where the multi-CPU core is enabled to work simultaneously, the-J 4 supports the simultaneous compilation of 4 core CPUs, thus saving time.

Make-j 4

650) this.width=650; "Src=" Http://s3.51cto.com/wyfs02/M02/87/04/wKioL1fRfDKBYZWmAAD0cNPzz-k659.png-wh_500x0-wm_3 -wmp_4-s_686581297.png "title=" Qq20160908225631.png "alt=" Wkiol1frfdkbyzwmaad0cnpzz-k659.png-wh_50 "/>

Installation

Make install

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M01/87/06/wKiom1fRfbPyDnL5AACZ7CNNmbw393.png-wh_500x0-wm_3 -wmp_4-s_4239938319.png "title=" Qq20160908230250.png "alt=" Wkiom1frfbpydnl5aacz7cnnmbw393.png-wh_50 "/>

Create MARIADB users and their corresponding directories

Useradd-m-s/sbin/nologin MySQL

Mkdir-p/usr/local/mysql/etc

Mkdir-p/usr/local/mysql/log

Mkdir-p/usr/local/mysql/run

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/87/05/wKioL1fRflmybREXAAA7mv8TBYc307.png "title=" Qq20160908230551.png "alt=" Wkiol1frflmybrexaaa7mv8tbyc307.png "/>

If a/etc/my.cnf file exists, rename or delete it. and create a new configuration file

Rm-f/etc/my.cnf

CP SUPPORT-FILES/MY-LARGE.CNF.SH/USR/LOCAL/MYSQL/ETC/MY.CNF

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M02/87/05/wKioL1fRftKiBkw7AAAoM9fc8Jk679.png "title=" Qq20160908230753.png "alt=" Wkiol1frftkibkw7aaaom9fc8jk679.png "/>

Edit the configuration file vi/usr/local/mysql/etc/my.cnf modify the port and socket parameters and add them in the [Mysqld] section

Log-error =/usr/local/mysql/log/mysqld.log

Pid-file =/usr/local/mysql/run/mysqld.pid

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/87/05/wKioL1fRf6yyFyL8AADKh8H4jSQ127.png "title=" Qq20160908231124.png "alt=" Wkiol1frf6yyfyl8aadkh8h4jsq127.png "/>

Modify the MARIADB installation directory owner

Chown-r mysql.mysql/usr/local/mysql/

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M02/87/06/wKiom1fRgDDCUx_4AAAelhpFktw451.png "title=" Qq20160908231344.png "alt=" wkiom1frgddcux_4aaaelhpfktw451.png "/> Initialize Database

/usr/local/mysql/scripts/mysql_install_db--user=mysql--basedir=/usr/local/mysql/--datadir=/usr/local/mysql/ Data

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M00/87/06/wKiom1fRgIiT_bwmAABwVDArwcI334.png-wh_500x0-wm_3 -wmp_4-s_1751502212.png "title=" Qq20160908231513.png "alt=" Wkiom1frgiit_bwmaabwvdarwci334.png-wh_50 "/>

Start the database to see the progress.

/usr/local/mysql/bin/mysqld_safe &

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M01/87/06/wKiom1fRgP2BJn_XAACvB28OVTc288.png "title=" Qq20160908231705.png "alt=" Wkiom1frgp2bjn_xaacvb28ovtc288.png "/>

To create a startup script file

CP Support-files/mysql.server/etc/init.d/mysql

chmod 755/etc/init.d/mysql

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/87/05/wKioL1fRgZeiTB8hAAAlctDlMuY164.png "title=" Qq20160908231940.png "alt=" Wkiol1frgzeitb8haaalctdlmuy164.png "/>

Modify/etc/init.d/mysql

Basedir=/usr/local/mysql

Datadir=/usr/local/mysql/data

Mysqld_pid_file_path=/usr/local/mysql/run/mysqld.pid

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M02/87/05/wKioL1fRgjfA6YxGAACJ4sDPZo8433.png "title=" Qq20160908232158.png "alt=" Wkiol1frgjfa6yxgaacj4sdpzo8433.png "/>

Add to Chkconfig Management

Chkconfig--add MySQL

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M00/87/05/wKioL1fRgnuAfYXOAABBIA68v4g178.png "title=" Qq20160908232313.png "alt=" Wkiol1frgnuafyxoaabbia68v4g178.png "/>

Test Script Start Service condition

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M01/87/05/wKioL1fRgwLSQsiCAAEkfN8jHgc165.png "title=" Qq20160908232542.png "alt=" Wkiol1frgwlsqsicaaekfn8jhgc165.png "/>

Set the root account login password for the database

/usr/local/mysql/bin/mysqladmin-u root password ' 3d#d0l7 '

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M02/87/06/wKiom1fRhDbxy6cMAAAjyxf3Ujs379.png "title=" Qq20160908233054.png "alt=" Wkiom1frhdbxy6cmaaajyxf3ujs379.png "/>

Log in to Database

/usr/local/mysql/bin/mysql-u ' root '-P ' 3d#d0l7 '

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M02/87/05/wKioL1fRhMajAcT_AABjxr523L4000.png "title=" Qq20160908233244.png "alt=" Wkiol1frhmajact_aabjxr523l4000.png "/>

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M01/87/05/wKioL1fRhNXRLN2_AACFTwY2f2U298.png "title=" Qq20160908233309.png "alt=" Wkiol1frhnxrln2_aacftwy2f2u298.png "/>

This article is from the "Server System Communication" blog, so be sure to keep this source http://1130739.blog.51cto.com/1120739/1850810

The latest source code package based on the CentOS 6.8 Platform MARIADB Database Enterprise Edition installation