Dashboard

Mysql


Setp 1 - Download

Download

DB

Setp 2 - Install

Install

  • 1) New VM

    • [New VM] RockyLinux85 => Copy vm
    [Network] eth0, VLAN_71
    [Memory] 4G


  • 2) DB Install

    • eth0 - dhcp eth1 - ip : 192.168.71.31(mssql), 41(mysql)


    [Mssql]
    Linux 용 mssql 이다. 사용법은 동일하다.

    ### 최신버전의 mssql 설치
    ### 메모리 2G 이상 안되면 설치 자체가 안됨.
    curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/8/mssql-server-2019.repo
    yum install -y mssql-server
    echo "SA 계정의 강력한 암호를 지정해야 합니다(대문자 및 소문자, 기본 10자리 숫자 및/또는 영숫자가 아닌 기호를 포함 하여 최소 길이 8자)."
    mkdir /home/db/ ; mkdir /home/db/mssql; mkdir /var/log/mssql
    chown -R mssql:mssql /home/db/mssql /var/log/mssql

    ### 무료 버전(Express)으로 설치 기본 10G까지는 Free
    SSIS_PID=Express ACCEPT_EULA=Y MSSQL_SA_PASSWORD='비밀번호' SQL_ENABLE_AGENT='y' MSSQL_LCID=1042 /opt/mssql/bin/mssql-conf -n setup

    sleep 5
    ### 추가되는 DB 계정 별도로 위치 지정
    /opt/mssql/bin/mssql-conf set filelocation.defaultdatadir /home/db/mssql
    /opt/mssql/bin/mssql-conf set filelocation.defaultlogdir /home/db/mssql
    /opt/mssql/bin/mssql-conf set filelocation.errorlogfile /var/log/mssql/errorlog

    sleep 5

    systemctl stop mssql-server
    chown -R mssql:mssql /home/db/mssql /var/log/mssql
    /bin/rm -rf /var/opt/mssql/log/*

    systemctl start mssql-server

    #### mssql Drive
    curl -o /etc/yum.repos.d/msprod.repo https://packages.microsoft.com/config/rhel/8/prod.repo
    yum remove unixODBC-utf16 unixODBC-utf16-devel
    yum install -y mssql-tools unixODBC-devel

    echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
    echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
    source ~/.bashrc

    [Mariadb]

    echo '# MariaDB 10.7 CentOS repository list - created 2022-04-03 12:46 UTC' > /etc/yum.repos.d/Mariadb.repo
    echo '# https://mariadb.org/download/' >> /etc/yum.repos.d/Mariadb.repo
    echo '[mariadb]' >> /etc/yum.repos.d/Mariadb.repo
    echo 'name = MariaDB' >> /etc/yum.repos.d/Mariadb.repo
    echo 'baseurl = https://mirror.yongbok.net/mariadb/yum/10.7/centos8-amd64' >> /etc/yum.repos.d/Mariadb.repo
    echo 'module_hotfixes=1' >> /etc/yum.repos.d/Mariadb.repo
    echo 'gpgkey=https://mirror.yongbok.net/mariadb/yum/RPM-GPG-KEY-MariaDB' >> /etc/yum.repos.d/Mariadb.repo
    echo 'gpgcheck=1' >> /etc/yum.repos.d/Mariadb.repo

    mkdir /home/db;mkdir /home/db/mariadb;
    mkdir /var/log/mysql
    mkdir /var/run/mysqld


    dnf install -y MariaDB-* --exclude=*debuginfo --exclude=MariaDB-test --exclude=MariaDB-gssapi-server --exclude=MariaDB-columnstore-engine



    [Redis]

    dnf install redis
    vim /etc/redis.conf
    => supervised systemd
    => requirepass strong_password
    => bind 0.0.0.0
    => protected-mode no

    systemctl start redis
    systemctl enable redis