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

Cd / usr/local/src

Wget https://downloads.mariadb.com/MariaDB/mariadb-10.2.6/bintar-linux-glibc_214-x86_64/mariadb-10.2.6-linux-glibc_214-x86_64.tar.gz

Tar zxvf mariadb-10.2.6-linux-glibc_214-x86_64.tar.gz

Mv mariadb-10.2.6-linux-glibc_214-x86_64 / usr/local/mariadb

Cd / usr/local/mariadb

. / scripts/mysql_install_db-- user=mysql-- basedir=/usr/local/mariadb/-- datadir=/data/mariadb

Cp support-files/my-small.cnf / usr/local/mariadb/my.cnf

Vi / usr/local/mariadb/my.cnf / / mysqld defines datadir / / changes tuning and master / slave here.

Cp support-files/mysql.server / etc/init.d/mariadb

Vim / etc/init.d/mariadb / / defines basedir, datadir, conf, and startup parameters

Conf specifies the path where the configuration file is located, conf=$basedir/my.cnf or conf=/usr/local/mariadb/my.cnf

If the server only has mariadb installed, then my.cnf can be installed under / etc, and the startup script does not need to define the conf variable.

Searching for start startup script

$bindir/mysqld_safe-defaults-file= "$conf"-datadir= "$datadir"-pid-file= "$mysqld_pid_file_path"$@" &

/ etc/init.d/mariadb start

Ps-aux | grep mariadb

Ls support-files/

Binary-configure my-large.cnf mysql-log-rotate wsrep_notify

Magic my-medium.cnf mysql.server

My-huge.cnf my-small.cnf policy

My-innodb-heavy-4G.cnf mysqld_multi.server wsrep.cnf

My-small.cnf / / choose according to the size of memory. The difference between them lies in the size of the cache.

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.