安装依赖
yum install -y git gcc gcc-c++ cmake libaio libaio-devel bison bison-devel zlib-devel ncurses ncurses-devel perl pcre-devel libxml2-devel libevent-devel rpm-build openssl-devel boost-program-options lsof socat perl-Compress-Raw-Bzip2 perl-Compress-Raw-Zlib perl-DBI perl-Data-Dumper perl-IO-Compress perl-Net-Daemon perl-PlRPC pcre2
目录、权限配置
groupadd mysql useradd mysql -g mysql mkdir -p /usr/local/mysql mkdir -p /usr/local/db/mysql/data mkdir -p /auth_pam_tool_dir touch /auth_pam_tool_dir/auth_pam_tool chown -R mysql:mysql /usr/local/mysql chown -R mysql:mysql /usr/local/db/mysql/data chown -R mysql:mysql /usr/local/mysql/. chown -R mysql:mysql /usr/local/db/mysql/data/. chown -R mysql:mysql /auth_pam_tool_dir echo "PATH=/usr/local/mysql/bin:/usr/local/mysql/lib:$PATH" >> /etc/profile echo "export PATH" >> /etc/profile source /etc/profile
安装前将CentOS7自带的MariaDB删掉
rpm -qa | grep mariadb #查出系统自带的MariaDB版本号 rpm -e --nodeps mariadb-libs-5.5.65-1.el7.x86_64
删除了CentOS7自带的MariaDB后，my.cnf也会同时被删除，手工上加my.cnf
vi /etc/my.cnf [client] port = 22066 socket = /usr/local/mysql/mysqld.sock # The MySQL server [mysqld] port = 22066 socket = /usr/local/mysql/mysqld.sock datadir = /usr/local/db/mysql/data skip-external-locking skip-name-resolve back_log = 50 max_connections = 2048 max_connect_errors = 1000 table_open_cache = 1024 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 server-id = 1 log-bin = mysql-bin expire_logs_days = 7 binlog_format = ROW innodb_data_file_path = ibdata1:12M:autoextend innodb_buffer_pool_size = 2G innodb_write_io_threads = 12 innodb_read_io_threads = 8 innodb_thread_concurrency = 16 innodb_flush_log_at_trx_commit = 2 innodb_log_buffer_size = 16M innodb_log_file_size = 170M innodb_lock_wait_timeout = 60
开始安装，将mariadb-10.5.4.tar.gz放到/usr/local下
tar zxvf mariadb-10.5.4.tar.gz cd mariadb-10.5.4 cmake -DCMAKE_BUILD_TYPE=Release -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock -DDEFAULT_CHARSET=utf8mb4 -DDEFAULT_COLLATION=utf8mb4_general_ci -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DENABLED_LOCAL_INFILE=1 -DMYSQL_DATADIR=/usr/local/db/mysql/data -DMYSQL_USER=mysql -DMYSQL_TCP_PORT=22066 make -j4 make install /usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/db/mysql/data cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql service mysql start chkconfig mysql on mysqladmin -u root password '123456' mysql -uroot -p123456 GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "123456"; flush privileges;