LAMP+NFS installation of MARIADB

MariaDB is installed based on a two-mechanism package and does not require compilation

First, data disk preparation

we put another disk on the virtual machine, the size of their own, here is 2G

650) this.width=650; "src=" Http://l51cto.qiniudn.com/mariadb1.png "width=" 629 "height=" 407 "alt=" Mariadb1.png "/>

Creating partitions

To view the newly added disk location

[[email protected]~]# fdisk -l disk /dev/sda: 137.4 gb, 137438953472  bytes255 heads, 63 sectors/track, 16709 cylindersunits = cylinders  of 16065 * 512 = 8225280 bytesSector size  (logical/physical):  512 bytes / 512 bytesI/O size  (Minimum/optimal): 512 bytes  / 512 bytesdisk identifier: 0x000188e2    device boot       Start         End       Blocks  Id  System/dev/sda1   *            1          26       204800  83  LinuxPartition 1 does not  End on cylinder&nBsp;boundary./dev/sda2              26         7859   62914560   8e   linux lvm disk /dev/sdb: 2147 mb, 2147483648 bytes255 heads, 63  sectors/track, 261 cylindersunits = cylinders of 16065 * 512  = 8225280 bytesSector size  (logical/physical):  512 bytes / 512  bytesI/O size  (Minimum/optimal): 512 bytes / 512 bytesdisk  identifier: 0x00000000

650) this.width=650; "src=" Http://l51cto.qiniudn.com/mariadb2.png "width=" 660 "height=" 455 "alt=" Mariadb2.png "/>

we are using the LV logical volume, so to choose the type, most do not forget to save the partition 650) this.width=650; "Src=" http://l51cto.qiniudn.com/ Mariadb3.png "width=" 660 "height=", "alt=, Mariadb3.png"/>

Completed created

650) this.width=650; "src=" Http://l51cto.qiniudn.com/mariadb4.png "width=" 658 "height=" 235 "alt=" Mariadb4.png "/>

Create logical volume, size 2G hint space is not enough, perhaps the calculation method is different, you have to use 1.99G

Creating a file system

[[email protected]~]# mkfs.xfs /dev/myvg/mylvmeta-data=/dev/myvg/mylv          isize=256    agcount=4, agsize=130560 blks          =                        sectsz=512   attr =2, projid32bit=0data     =                        bsize=4096    blocks=522240, imaxpct=25         =                         sunit=0      swidth=0 blksnaming   = version 2   &Nbsp;          bsize=4096   ascii-ci=0log       =internal log            bsize=4096   blocks=2560, version=2          =                        sectsz=512   sunit=0 blks, lazy-count= 1realtime =none                    extsz=4096   blocks=0, rtextents=0

Modify The/etc/fstab file to automatically mount the boot

650) this.width=650; "width=" 660 "height=" 168 "src=" Http://l51cto.qiniudn.com/mariadb5.png "style=" border:1px Solid RGB (221,221,221); width:660px;height:168px;background:no-repeat 50% 50%; "alt=" spacer.gif "border=" 0 "hspace=" 0 " Vspace= "0" title= ""/>

Create mount Directory

[[Email protected]~]# mkdir/data

Test whether automatic mount is in effect

[[email protected] ~]# mount-a[[email protected] ~]# mount/dev/mapper/vg0-root on/type ext4 (rw) proc On/proc type proc (rw) Sysfs On/sys type SYSFS (rw) devpts on/dev/pts type devpts (rw,gid=5,mode=620) Tmpfs on/dev/shm type TMPFS (rw)/dev/ SDA1 on/boot type EXT4 (rw)/dev/mapper/vg0-usr on/usr type EXT4 (rw)/dev/mapper/vg0-var On/var type EXT4 (rw) None on/p Roc/sys/fs/binfmt_misc type Binfmt_misc (rw)/dev/mapper/myvg-mylv on/data type XFS (rw)//Mounted

Create a database directory

[Email protected] ~]# Mkdir/data/mysql

Create System user group MySQL, system user MySQL, and change/data/mysql/genera Group are MySQL

[Email protected]~]# groupadd-r mysql[[email protected]~]# useradd-r-G mysql-s/sbin/nologin Mysql[[email protected]~ ]# Chown-r mysql:mysql/data/

Installing the MARIADB binary program

[Email protected]~]# tar XF mariadb-5.5.36-linux-i686.tar.gz-c/usr/local///Unzip to installation directory [[email protected] ~]# CD   /usr/local/[[email protected] local]# Lsbin etc games include Lib Lib64 libexec mariadb-5.5.36-linux-i686 sbin Share Src[[email protected] local]# LN-SV mariadb-5.5.36-linux-i686/mysql//Create soft link ' MySQL '--' mariadb-5.5.36-linux-i686/'

Configure MARIADB

[Email protected] local]# cd/usr/local/mysql[[email protected] mysql]# scripts/mysql_install_db--user= Mysql--datadir=/data/mysql//Run initialization script, indicate run as user MySQL, database directory is/data/mysql

Provide a configuration file for mariadb, and modify the value of thread_concurrency in this file by multiplying your number of CPUs by 2, specifying the MySQL database to hold the data location, for example using the following line:

[email protected] mysql]# CP support-files/my-large.cnf/etc/mysql.cnf

650) this.width=650; "width=" 660 "height=" "src=" "Http://l51cto.qiniudn.com/mariadb6.png" alt= "Spacer.gif" border= " 0 "hspace=" 0 "vspace=" 0 "title=" "style=" border:1px solid rgb (221,221,221); width:660px;height:87px; background-position:50% 50%;background-repeat:no-repeat; "/>

Add a service script for MySQL

[[email protected] mysql]# CP support-files/mysql.server/etc/rc.d/init.d/mysqld[[email protected] mysql]# chmod +x/etc /rc.d/init.d/mysqld[[email protected] mysql]# chkconfig--add mysqld

and follow the modified installation path, data path, and configuration file path 650) this.width=650; "width=" 660 "height=" "src=" Http://l51cto.qiniudn.com/mariadb7.png " alt= "Spacer.gif" border= "0" hspace= "0" vspace= "0" title= "style=" border:1px solid rgb (221,221,221); width:660px; height:45px;background-position:50% 50%;background-repeat:no-repeat; "/>650) this.width=650; width=" 660 "height = "src=" "Http://l51cto.qiniudn.com/mariadb8.png" alt= "spacer.gif" border= "0" hspace= "0" vspace= "0" title= "" style= " border:1px solid RGB (221,221,221); width:660px;height:92px;background-position:50% 50%;background-repeat:no-repeat ; "/>

Export MySQL Environment variables

[Email protected] ~]# vim/etc/profile.d/mysql.sh

650) this.width=650; "width=" 660 "height=" "src=" Http://l51cto.qiniudn.com/mariadb9.png "alt=" Spacer.gif "border=" 0 "hspace=" 0 "vspace=" 0 "title=" "style=" border:1px solid rgb (221,221,221); width:660px;height:50px; background-position:50% 50%;background-repeat:no-repeat; "/>

Make environment variables effective

[Email protected] mysql]#. /etc/profile.d/mysql.sh

At this point the configuration is complete, you can use the service script to start the 650) this.width=650; "width=" 660 "height=" "src=" alt= "Spacer.gif" border= "0" hspace= "0" vspace= "0" title= "style=" text-indent:28px;border:1px solid rgb (221,221,221); width:660px;height:63px;background-position:50% 50%;background-repeat:no-repeat; "/>

Startup success

Enter database command line

650) this.width=650; "src=" Http://l51cto.qiniudn.com/mariadb11.png "width=" 660 "height=" 206 "alt=" Mariadb11.png "/ >

This article is from the "Linux Learning path" blog, so be sure to keep this source http://linuxu.blog.51cto.com/9471357/1596998

LAMP+NFS installation of MARIADB