2021-01-15 MariaDB非yum安装-二进制安装

一定要注意版本！！！

MariaDB 下载

下载地址 https://mariadb.org/download/

MariaDB 安装

解压文件到/usr/local/ 此目录不能更改

tar

进入 /usr/local

cd

创建软链接

ln

创建mariadb目录并添加用户

mkdir -p /TRS/APP/mariadb
useradd

给mysql用户授权,进入/usr/local/mysql目录

chown -R mysql .
chgrp -R mysql .
chown

创建配置文件目录

mkdir

创建日志目录

mkdir

MariaDB 配置

创建配置文件

此处注意版本问题:10.3.7的conf文件应该放到/etc/my.conf

通过运行脚本查看当前版本配置文件应该存放的路径,或者可以修改脚本

脚本目录:/etc/init.d/mysqld 164行左右,如下图:

/usr/local/mysql/

vim /etc/my.cnf

[client]
port            = 3306
#mysql.sock目录
socket          = /TRS/APP/mariadb/mysql.sock

[mysqld]
user = mysql
port=3306
default-storage-engine         = InnoDB
#目录
socket    = /TRS/APP/mariadb/mysql.sock
skip-external-locking
character-set-server = utf8
max_allowed_packet = 16M
max_connect_errors=65535
skip_name_resolve = ON
sysdate-is-now                 = 1
innodb                         = FORCE
#数据库目录
datadir = /TRS/APP/mariadb
log-bin                        = /var/lib/mysql/mysql-bin
auto_increment_increment=2
auto_increment_offset=2
log-slave-updates=on
#relay_log_recovery             = 1
binlog_format=mixed             #row
max_binlog_size=1024M
binlog_cache_size             = 2M
expire-logs-days               = 14
server-id    = 189
sync-binlog                    = 1

query-cache-type               = 0
query-cache-size               = 0
max_connections=8192
thread-cache-size              = 1024
open_files_limit=8192
table-definition-cache         = 1024
table-definition-cache         = 1024
max_prepared_stmt_count=200000
slow_query_log=on
#日志慢加载
slow_query_log_file=/TRS/APP/mariadb/logs/mysql-slow.log
log-error                      = /TRS/APP/mariadb/logs/mysql.log
log-queries-not-using-indexes  = 1
long_query_time = 1
interactive_timeout            = 1728000
wait_timeout                   = 1728000
lower_case_table_names=1
innodb-log-file-size           = 512M
innodb-flush-log-at-trx-commit = 2
innodb-file-per-table          = 1
innodb-buffer-pool-size        = 
innodb_log_buffer_size = 8M
innodb_lock_wait_timeout = 150
replicate-ignore-db = mysql
replicate-ignore-db = information_schema
replicate-ignore-db = performance_schema
max_heap_table_size = 2048M
tmp_table_size = 2048M
#innodb-log-files-in-group      = 2

[mysqldump]
quick
max_allowed_packet = 512M

[mysql]
no-auto-rehash

[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]

启动脚本

运行生成数据库脚本

./bin/mysql_install_db --user=mysql

复制运行脚本

cp

启动mysqld

service

启动数据库

cd

运行mysql

./mysql -uroot -p

问题

1. 找不到在mysql 目录下找不到mariadb的conf配置文件
   自己创建配置文件并粘贴内容
   不同版本脚本指定的路径有些差异,需要进入脚本查看,脚本目录: cat /etc/init.d/mysqld

cat

两种解决方法:

1. 修改脚本文件文件为你的目录
2. 修改你的my.cnf路径为脚本指向文件

1. FATAL ERROR: Could not find ./bin/my_print_defaults的解决办法
   回到mysql目录执行脚本
2. /bin/mysqld: Can’t create file ‘/TRS/APP/mariadb/logs/mysql.log’ (errno: 13 “Permission denied”)
   权限问题c

chown

1. Installation of system tables failed! Examine the logs in
   /TRS/APP/mariadb/logs/mysql.log or /TRS/APP/mairadb/data for more information.
   查看日志发现异常:

mysqld: File ‘/var/lib/mysql/mysql-bin.index’ not found (Errcode: 2
“No such file or directory”)

1. 修改配置文件
2. InnoDB: mmap(137035776 bytes) failed; errno 12
   2021-01-15 11:14:49 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
   2021-01-15 11:14:49 0 [ERROR] InnoDB: Database creation was aborted with error Gener
   没有足够的内存,将内存的缓冲内存调低

innodb-buffer-pool-size =

1. PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
   未启动数据库,
2. etc/init.d/mysqld: line 264: kill: (6910) - No such process [FAILED]
   脚本指向的conf存在问题