MariaDB10.5安装二源码和二进制安装安装

超、凢脫俗 2024-03-23 12:12 48阅读 0赞

9de7bb31d0644e7393039222babfed10

闲话少说， 本次演示源码和二进制安装安装安装MariaDB10.5

### Oracle8.4 源码安装 MariaDB 10.5 ###

yum -y install git gcc gcc-c++ make bison ncurses ncurses-devel zlib-devel libevent-devel cmake openssl openssl-devel curl-devel libaio libaio-devel ncurses-compat-libs gnutls gnutls-devel
    #解压编译
    tar xf /software/mariadb-10.5.10.tar.gz -C /tmp
    cd /tmp/mariadb-10.5.10
    mkdir build ; cd build
    cmake -DCMAKE_BUILD_TYPE=Release \
               -DCMAKE_INSTALL_PREFIX=/usr/local/mariadb \
               -DMYSQL_DATADIR=/u01/mysql/data \
               -DSYSCONFDIR=/etc \
               -DMYSQL_UNIX_ADDR=/tmp/mysql.sock \
               ..
    make -j 2 && make install  
    
    #环境准备
    groupadd mysql
    useradd -g mysql mysql
    ln -s /usr/local/mariadb /usr/local/mysql
    chown -R root:mysql /usr/local/mysql
    #准备配置文件
    [ -f /etc/my.cnf ] && mv /etc/my.cnf /etc/my.cnf.$(date +%Y%m%d%H%M%S)
    cat > /etc/my.cnf <<EOF
    [mysqld]
    datadir=/u01/mysql/data
    socket=/tmp/mysql.sock
    log-error=/u01/mysql/mysqld.log
    pid-file=/u01/mysql/mysqld.pid
    
    log-bin-trust-function-creators=on
    skip_name_resolve=on
    max_connections=1000
    wait_timeout=1200
    interactive_timeout=1200
    
    [client]
    socket=/tmp/mysql.sock
    EOF
    mkdir -p /u01/mysql/data ; chown -R mysql /u01/mysql
    #创建数据库, 注意路径在 bin下
    mkdir /auth_pam_tool_dir && touch /auth_pam_tool_dir/auth_pam_tool  && chown -R mysql.mysql /auth_pam_tool_dir
    /usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/u01/mysql/data
    
    #设置服务 运行 systemctl start mariadb 不返回, 但数据库可以正常连接, 不清楚原因, 也没有找到解决方法
    #或者 使用以下两种方式都可以启动, 使用, 但不退出. 可以加 & 后台运行
    /usr/local/mysql/bin/mysqld_safe --user=mysql
    /usr/local/mysql/bin/mysqld --user=mysql
    
    #允许3306端口通过防火墙
    firewall-cmd --zone=public --add-port=3306/tcp --permanent && firewall-cmd --reload
    #设置环境变量 
    cat >> ${
        HOME}/.bash_profile <<EOF
    export PATH=\${
         PATH}:/usr/local/mysql/bin
    EOF
    source ${
        HOME}/.bash_profile
    
    #登陆, 修改密码后 plugin 自动由 unix_socket 变成 mysql_native_password
    mysql #不需要账号密码, 默认认证方式为 unix_socket
    ALTER USER 'root'@'localhost' IDENTIFIED BY 'Root_1qaz';

### Oracle8.4 二进制安装 MariaDB 10.5 ###

yum -y install  libaio ncurses-compat-libs
    groupadd mysql
    useradd -g mysql mysql
    tar -zxf /software/mariadb-10.5.10-linux-systemd-x86_64.tar.gz -C /usr/local
    ln -s /usr/local/mariadb-10.5.10-linux-systemd-x86_64 /usr/local/mysql
    chown -R root:mysql /usr/local/mysql/
    #准备配置文件
    [ -f /etc/my.cnf ] && mv /etc/my.cnf /etc/my.cnf.$(date +%Y%m%d%H%M%S)
    cat > /etc/my.cnf <<EOF
    [mysqld]
    datadir=/u01/mysql/data
    socket=/tmp/mysql.sock
    log-error=/u01/mysql/mysqld.log
    pid-file=/u01/mysql/mysqld.pid
    
    log-bin-trust-function-creators=on
    skip_name_resolve=on
    max_connections=1000
    wait_timeout=1200
    interactive_timeout=1200
    
    [client]
    socket=/tmp/mysql.sock
    EOF
    mkdir -p /u01/mysql/data ; chown -R mysql /u01/mysql
    #创建数据库
    /usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/u01/mysql/data
    
    #设置服务
    #使用官方文档 cp /usr/local/mysql/support-files/systemd/mariadb.service /usr/lib/systemd/system 设置服务失败, 具体原因未调查, 参考mysqld 手写了服务脚本
    cat > /usr/lib/systemd/system/mariadb.service<<EOF
    Description=MariaDB 10.5.10 database server
    Documentation=man:mariadbd(8)
    Documentation=https://mariadb.com/kb/en/library/systemd/
    After=network.target
    
    [Install]
    WantedBy=multi-user.target
    
    [Service]
    User=mysql
    Group=mysql
    Type=notify
    TimeoutSec=900
    PermissionsStartOnly=true
    ExecStart=/usr/local/mysql/bin/mysqld --user=mysql
    LimitNOFILE=65536
    Restart=on-failure
    RestartPreventExitStatus=1
    Environment=MYSQLD_PARENT_PID=1
    PrivateTmp=false
    EOF
    systemctl start mariadb
    
    #允许3306端口通过防火墙
    firewall-cmd --zone=public --add-port=3306/tcp --permanent && firewall-cmd --reload
    #设置环境变量
    cat >> ${
        HOME}/.bash_profile <<EOF
    export PATH=\${
         PATH}:/usr/local/mysql/bin
    EOF
    source ${
        HOME}/.bash_profile
    
    #登陆, 修改密码后 plugin 自动由 unix_socket 变成 mysql_native_password
    mysql #不需要账号密码, 默认认证方式为 unix_socket
    ALTER USER 'root'@'localhost' IDENTIFIED BY 'Root_1qaz';

至此， 安装包方式， 源码方式，二进制方式安装Mariadb完成， 请关注防丢失。  
9de7bb31d0644e7393039222babfed10谢谢