编译安装mariadb10.11

maraidb10.11开始支持openssl3.0了同时也支持openssl1.1,也是最后一版的10
自行安装支持组件
这两个组件编译安装
fmt库
安装pcre2-10版本
创建用户

groupadd mysql -g 5001;
useradd -s /sbin/nologin mysql -u 5001 -g 5001;

创建数据库保存目录

mkdir -p /home/mysql/data
chown mysql:mysql /home/mysql -R

可以到这里下载最新版本
https://mariadb.org/download/

wget https://mariadb.mirror.liquidtelecom.com//mariadb-10.11.2/source/mariadb-10.11.2.tar.gz
tar zxf mariadb-10.11.2.tar.gz
cd mariadb-10.11.2
cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/home/mysql/data -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DWITH_SSL=system -DWITH_ZLIB=system -DWITH_LIBWRAP=0 -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DSYSCONFDIR=/etc
make -j4&&make install
cd ..&&rm -rf mariadb-10.11.2.tar.gz mariadb-10.11.2

创建/etc/my.cnf文件，并录入以下内容

[client]
port = 3306
socket = /tmp/mysql.sock
[mysqld]
port = 3306
socket = /tmp/mysql.sock
datadir = /home/mysql/data
skip-external-locking
back_log = 50
max_connections = 500
max_connect_errors = 1000
table_open_cache = 256
open_files_limit = 16384
max_allowed_packet = 16M
read_buffer_size = 8M
read_rnd_buffer_size = 32M
sort_buffer_size = 2M
join_buffer_size = 2M
thread_cache_size = 64
query_cache_size = 64M
query_cache_limit = 4M
slow_query_log = 1
long_query_time = 2
lower_case_table_names = 1
innodb_file_per_table = 1
max_allowed_packet = 1G
table_definition_cache = 400
server-id = 1
log-bin = mysql-bin
expire_logs_days = 7
binlog_format = ROW
performance_schema_max_table_instances = 500
innodb_data_file_path = ibdata1:12M:autoextend
innodb_buffer_pool_size = 2G
innodb_write_io_threads = 12
innodb_read_io_threads = 8
innodb_flush_log_at_trx_commit = 2
innodb_log_buffer_size = 16M
innodb_log_file_size = 170M
innodb_lock_wait_timeout = 60

初始化

/usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/home/mysql/data
chmod 775 /usr/local/mysql/support-files/mysql.server;
/usr/local/mysql/support-files/mysql.server start;
ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql;
ln -s /usr/local/mysql/bin/mysqladmin /usr/bin/mysqladmin;
ln -s /usr/local/mysql/bin/mysqldump /usr/bin/mysqldump;
ln -s /usr/local/mysql/bin/myisamchk /usr/bin/myisamchk;
ln -s /usr/local/mysql/bin/mysqld_safe /usr/bin/mysqld_safe;
rm -rf /usr/local/mysql/data/test;

测试登录

mysql -uroot -p

密码为空

加入系统启动

创建/lib/systemd/system/mysql.service文件

并录入以下内容

[Unit]
Description=mysql server Service
After=syslog.target network.target

[Service]
Type=forking
ExecStart=/usr/local/mysql/support-files/mysql.server start
ExecReload=/usr/local/mysql/support-files/mysql.server restart
ExecStop=/usr/local/mysql/support-files/mysql.server stop

[Install]
WantedBy=multi-user.target

创建软连

ln -s /lib/systemd/system/mysql.service /etc/systemd/system/multi-user.target.wants/mysql;

载入

systemctl daemon-reload;

启用系统启动

systemctl enable mysql;