Shulou(Shulou.com)06/01 Report--

The content of this chapter

There are three ways to install Mariadb:

1. Packages managed by the package manager

2. Package in binary format: expand to a specific path and use it after simple configuration

3. Source code: compile and install

Multi-instance implementation of MariaDB on one machine

Native environment

System version: take CentOS_7.5_x86_64 as an example

MariaDB version: take MariaDB 10.2.15 Stable as an example

Install MariaDB in package Manager (yum) mode

1. After configuring the yum source, type yum-y install mariadb-server, but the mariadb version is 5.5, not newer.

2. If you want to install a newer version of mariadb with yum, go to the MariaDB official website to check the source of the newer version of yum. The official website address is http://mariadb.org/. Click Download after opening the web page, and then click Download.

3. Take version 10.2.15 as an example, click Download 10.2.15 Stable Now!

4. Pull to the bottom and click Repository Configuration Tool.

5. Click CentOS-- > CentOS 7 (x86: 64)-- > 10.2 [Stable]. You can see the Yum source information below. Copy this information, and you can configure the yum repository in CentOS.

After matching, lose the order:

Yum clean all

Yum repolist

Yum-y install mariadb-server

You can install the newer version 10.2.15 of MariaDB

Installation package preparation

Prepare the MariaDB source installation package, as well as the binary installation package

A binary program installation package is actually a compiled package that no longer needs to be compiled.

1. To download the installation package on the official website, still click Download, then click Download, and then click Download 10.2.15 Stable Now

2. Download two packages. Mariadb-10.2.15.tar.gz is the source package and mariadb-10.2.15-linux-x86_64.tar.gz is the package in binary format.

3. Use Linux's rz tool or Xshell's xftp tool to transfer two packages to two virtual machines

Binary package installation MariaDB

(1) prepare users

Groupadd-r-g 306 mysql

Useradd-r-g 306-u 306-m-d / data/mysqldb mysql

(2) prepare the data directory

Using / data/mysqldb as an example, logical volumes are recommended

Chown mysql:mysql / data/mysqldb

Chmod 700 / data/mysqldb

(3) prepare the binary program

Tar xf mariadb-10.2.15-linux-x86_64.tar.gz-C / usr/local # / usr/local is the directory specified by the package and must be extracted here

Cd / usr/local;ln-sv mariadb-10.2.15 mysql

Chown-R mysql:mysql / usr/local/mysql/

(4) prepare the configuration file

Mkdir / etc/mysql/

Cp support-files/my-huge.cnf / etc/mysql/my.cnf

There are many my-*.cnf files under # / usr/local/mysql/support-files, which correspond to different memory sizes. You can open them and choose the copy of your own machine.

Vim / etc/mysql/my.cnf

Add three options to [mysqld]:

Datadir = / data/mysqldb

Innodb_file_per_table = on but not added

Skip_name_resolve = on prohibits hostname resolution. It is recommended to use it without adding it.

(5) create a database file

Cd / usr/local/mysql/

. / scripts/mysql_install_db-datadir=/data/mysqldb-user=mysql

(6) prepare log files

Touch / var/log/mysqld.log

Chown mysql:mysql / var/log/mysqld.log

(7) prepare the service script and start the service

Cp. / support-files/mysql.server / etc/rc.d/init.d/mysqld

Chkconfig-add mysqld

Service mysqld start

(8) Security initialization

/ user/local/mysql/bin/mysql_secure_installation

(9) add environment variables

Echo PATH=/usr/local/mysql/bin:$PATH > / etc/profile.d/mysql.sh

. / etc/profile.d/mysql.sh

Source code compilation and installation of MariaDB

(1) install the package

Yum install bison bison-devel zlib-devel libcurl-devel libarchive-devel boost-devel gcc gcc-c++ cmake libevent-devel gnutls-devel libaio-devel openssl-devel ncurses-devel libxml2-devel

(2) prepare user and data directories

Mkdir / data

Useradd-r-s / sbin/nologin-m-d / data/mysqldb/ mysql

Tar xvf mariadb-10.2.15.tar.gz

(3) cmake compilation and installation

Cd mariadb-10.2.15/

For compilation options, please refer to:

Https://dev.mysql.com/doc/refman/5.7/en/source-configuration-options.html

Directly enter the order here.

Cmake. \

-DCMAKE_INSTALL_PREFIX=/app/mysql\

-DMYSQL_DATADIR=/data/mysqldb/\

-DSYSCONFDIR=/etc\

-DMYSQL_USER=mysql\

-DWITH_INNOBASE_STORAGE_ENGINE=1\

-DWITH_ARCHIVE_STORAGE_ENGINE=1\

-DWITH_BLACKHOLE_STORAGE_ENGINE=1\

-DWITH_PARTITION_STORAGE_ENGINE=1\

-DWITHOUT_MROONGA_STORAGE_ENGINE=1\

-DWITH_DEBUG=0\

-DWITH_READLINE=1\

-DWITH_SSL=system\

-DWITH_ZLIB=system\

-DWITH_LIBWRAP=0\

-DENABLED_LOCAL_INFILE=1\

-DMYSQL_UNIX_ADDR=/app/mysql/mysql.sock\

-DDEFAULT_CHARSET=utf8\

-DDEFAULT_COLLATION=utf8_general_ci

Make & & make install

(4) prepare environment variables

Echo 'PATH=/app/mysql/bin:$PATH' > / etc/profile.d/mysql.sh

. / etc/profile.d/mysql.sh

(5) generate database files

Chmod 700 / data/mysqldb

Cd / app/mysql/

Scripts/mysql_install_db-datadir=/data/mysqldb/-user=mysql

(6) prepare the configuration file

Cp / app/mysql/support-files/my-huge.cnf / etc/my.cnf

Vim / etc/mysql/my.cnf

[mysqld] add:

Datadir = / data/mysqldb

Chown-R mysql:mysql / app/mysql/

(7) prepare the startup script

Cp / app/mysql/support-files/mysql.server / etc/init.d/mysqld

(8) start the service

Chkconfig-add mysqld

Service mysqld start

Multi-instance implementation of MariaDB on one machine

(1) install MariaDB, which is installed with yum here.

Yum install mariadb-server

(2) create a multi-instance directory

Three instances are created here, and the last three instances will use port 3306 and 3307 respectively.

Mkdir / mysqldb/ {3306, 3307, 3308} / {etc,socket,pid,log,data}-pv

Chown-R mysql.mysql / mysqldb/

(3) generate database files

Mysql_install_db-datadir=/mysqldb/3306/data-user=mysql

Mysql_install_db-datadir=/mysqldb/3307/data-user=mysql

Mysql_install_db-datadir=/mysqldb/3308/data-user=mysql

(4) prepare the configuration file

Cp / etc/my.cnf / mysqldb/3306/etc/

Vim / mysqldb/3306/etc/my.cnf

[mysqld]

Port=3306

Datadir=/mysqldb/3306/data

Socket=/mysqldb/3306/socket/mysql.sock

[mysqld_safe]

Log-error=/mysqldb/3306/log/mariadb.log

Pid-file=/mysqldb/3306/pid/mariadb.pid

#! includedir / etc/my.cnf.d

Cp / mysqldb/3306/etc/my.cnf / mysqldb/3307/etc/my.cnf # copy configuration files to 3307 and 3308

Cp / mysqldb/3306/etc/my.cnf / mysqldb/3308/etc/my.cnf

Vim / mysqldb/3307/etc/my.cnf

:% sswap 3306 Universe 3307 / # replace all port numbers from 3306 to 3307

: wq

Vim / mysqldb/3308/etc/my.cnf

:% sswap 3306 Universe 3308 / # replace all port numbers from 3306 to 3308

: wq

(5) prepare the service script

Here is a service script that is glued into an empty file and named mysqld:

#! / bin/bash#FileName: mysqldport=3306mysql_user= "root" mysql_pwd= "cmd_path=" / usr/bin "mysql_basedir=" / mysqldb "mysql_sock=" ${mysql_basedir} / ${port} / socket/mysql.sock "function_start_mysql () {if [!-e" $mysql_sock "] Then printf "Starting MySQL...\ n" ${cmd_path} / mysqld_safe-- defaults-file=$ {mysql_basedir} / ${port} / etc/my.cnf & > / dev/null & else printf "MySQL is running...\ n" exit fi} function_stop_mysql () {if [!-e "$mysql_sock"] Then printf "MySQL is stopped...\ n" exit else printf "Stoping MySQL...\ n" ${cmd_path} / mysqladmin-u ${mysql_user}-p$ {mysql_pwd}-S ${mysql_sock} shutdown fi} function_restart_mysql () {printf "Restarting MySQL...\ n" function_stop_mysql sleep 2 function_start_mysql} case $1 instart) function_start_mysql Stop) function_stop_mysql;;restart) function_restart_mysql;;*) printf "Usage: ${mysql_basedir} / ${port} / bin/mysqld {start | stop | restart}\ n" esac # End of file

Chmod 700 mysqld

Cp mysqld / mysqldb/3306/

Cp mysqld / mysqldb/3307/

Cp mysqld / mysqldb/3308/

# modify the port number of each instance configuration file

Vim / mysqldb/3306/mysqld

Vim / mysqldb/3307/mysqld

Vim / mysqldb/3308/mysqld

(6) start three instances

/ mysqldb/3306/mysqld start

/ mysqldb/3307/mysqld start

/ mysqldb/3308/mysqld start

(7) Connect three instances

Mysql-S / mysqldb/3306/socket/mysql.sock

Mysql-S / mysqldb/3307/socket/mysql.sock

Mysql-S / mysqldb/3308/socket/mysql.sock

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.