[root@hf-01 ~]# cd /usr/local/src
[root@hf-01 src]#
[root@hf-01 src]# ls
mariadb-10.2.6-linux-glibc_214-x86_64.tar.gz mysql-5.6.35-linux-glibc2.5-x86_64.tar.gz
[root@hf-01 src]# tar zxvf mariadb-10.2.6-linux-glibc_214-x86_64.tar.gz
[root@hf-01 src]# ls
mariadb-10.2.6-linux-glibc_214-x86_64 mysql-5.6.35-linux-glibc2.5-x86_64.tar.gz
mariadb-10.2.6-linux-glibc_214-x86_64.tar.gz
[root@hf-01 src]#
[root@hf-01 src]# mv mariadb-10.2.6-linux-glibc_214-x86_64 /usr/local/mariadb
[root@hf-01 src]#
[root@hf-01 src]# cd !$
cd /usr/local/mariadb
[root@hf-01 mariadb]#
[root@hf-01 mysql]# useradd mysql
[root@hf-01 mysql]# mkdir /data/
[root@hf-01 mariadb]# ./scripts/mysql_install_db --user=mysql --basedir=/usr/local/mariadb/ --datadir=/data/mariadb
[root@hf-01 mariadb]# echo $?
0
[root@hf-01 mariadb]#
[root@hf-01 mariadb]# ls /data/mariadb/
aria_log.00000001 aria_log_control ib_buffer_pool ibdata1 ib_logfile0 ib_logfile1 mysql performance_schema test
[root@hf-01 mariadb]#
[root@hf-01 mariadb]# cd /usr/local/mariadb/
[root@hf-01 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
[root@hf-01 mariadb]#
[root@hf-01 mariadb]# vim support-files/my-small.cnf
其中下面的配置文件
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-external-locking
key_buffer_size = 16K
max_allowed_packet = 1M
table_open_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 240K
[root@hf-01 mariadb]# cp support-files/my-small.cnf /usr/local/mariadb/my.cnf
[root@hf-01 mariadb]#
[root@hf-01 mariadb]# vim /usr/local/mariadb/my.cnf
配置参数在[mysqld]这一块
server-id = 1 //这是做主从复制的
[root@hf-01 mariadb]# cp support-files/mysql.server /etc/init.d/mariadb
[root@hf-01 mariadb]#
[root@hf-01 mariadb]# vim /etc/init.d/mariadb
定义 basedir=/usr/local/mariadb
定义 datadir=/data/mariadb
自定义参数 conf=$basedir/my.cnf
在定义conf后,还需要在 启动命令下面指定下——>在一般模式下,搜索 /start 启动命令
在 $bindir/mysqld_safe --datadir="$datadir" --pid-file="$mysqld_pid_file_path" "$@" &
中,增加--defaults-file="$conf",最后为 $bindir/mysqld_safe --defaults-file="$conf" --datadir="$datadir" --pid-file="$mysqld_pid_file_path" "$@" &
并保存退出
[root@hf-01 mariadb]# ps aux |grep mysql
root 2526 0.0 0.0 112656 992 pts/0 R+ 00:10 0:00 grep --color=auto mysq
[root@hf-01 mariadb]#
[root@hf-01 mariadb]# /etc/init.d/mariadb start
Reloading systemd: [ 确定 ]
Starting mariadb (via systemctl): [ 确定 ]
[root@hf-01 mariadb]# ps aux |grep mariadb
root 2543 0.0 0.1 115348 1748 ? S 00:11 0:00 /bin/sh /usr/local/mariadb/bin/mysqld_safe --defaults-file=/usr/local/mariadb/my.cnf --datadir=/data/mysql --pid-file=/data/mysql/hanfeng.pid
mysql 2659 5.5 5.7 1125580 58008 ? Sl 00:11 0:01 /usr/local/mariadb/bin/mysqld --defaults-file=/usr/local/mariadb/my.cnf --basedir=/usr/local/mariadb --datadir=/data/mysql --plugin-dir=/usr/local/mariadb/lib/plugin --user=mysql --log-error=/data/mysql/hanfeng.err --pid-file=/data/mysql/hanfeng.pid --socket=/tmp/mysql.sock --port=3306
root 2708 0.0 0.0 112656 992 pts/0 R+ 00:11 0:00 grep --color=auto mariadb
[root@hf-01 mariadb]# netstat -lntp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 127.0.0.1:25 0.0.0.0:* LISTEN 2246/master
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 1147/sshd
tcp6 0 0 ::1:25 :::* LISTEN 2246/master
tcp6 0 0 :::3306 :::* LISTEN 2659/mysqld
tcp6 0 0 :::22 :::* LISTEN 1147/sshd
[root@hf-01 mariadb]#
[root@hf-01 mariadb]# ps aux |grep mysql
root 3123 0.0 0.1 115392 1740 ? S 04:52 0:00 /bin/sh /usr/local/mariadb/bin/mysqld_safe --defaults-file=/usr/local/mariadb/my.cnf --datadir=/data/mariadb --pid-file=/data/mariadb/hf-01.pid
mysql 3242 3.6 6.2 1125520 62780 ? Sl 04:52 0:00 /usr/local/mariadb/bin/mysqld --defaults-file=/usr/local/mariadb/my.cnf --basedir=/usr/local/mariadb --datadir=/data/mariadb --plugin-dir=/usr/local/mariadb/lib/plugin --user=mysql --log-error=/data/mariadb/hf-01.err --pid-file=/data/mariadb/hf-01.pid --socket=/tmp/mysql.sock --port=3306
root 3278 0.0 0.0 112672 984 pts/0 R+ 04:53 0:00 grep --color=auto mysql
[root@hf-01 mariadb]#