안녕하세요

호스팅 전문기업 비아웹입니다.

​rocky linux 9 환경에서 최신 APM 설치에 대해 기록합니다.

​

1. 설치 버전

• 테스트 OS : Rocky Linux release 9.4 (Blue Onyx)

• apache 2.4.61

• php 8.3.9

• maraidb 11.4.2

​

2. 패키지 다운로드

• 의존성 패키지 설치

• dnf install wget tar

• 최신 버전 다운로드

• # maraidb  11.4.2
  wget https://archive.mariadb.org/mariadb-11.4.2/bintar-linux-systemd-x86_64/mariadb-11.4.2-linux-systemd-x86_64.tar.gz
  
  # apache 2.4.61
  wget https://dlcdn.apache.org/httpd/httpd-2.4.61.tar.gz
  # 인증서 관련 오류 발생시 --no-check-certificate  옵션 사용
  
  # php-8.3.9
  wget https://www.php.net/distributions/php-8.3.9.tar.gz

3. mariadb 설치

• # 압축 해제 후
  mv mariadb-11.4.2-linux-systemd-x86_64 /usr/local/mysql
  
  # 사용자 추가
  groupadd mysql
  useradd -g mysql mysql -d /usr/local/mysql -s /sbin/nologin

•  

• my.cnf (참고용)

• vi /etc/my.cnf
  
  [client]
  default-character-set = utf8mb4
  port = 3306
  socket = /tmp/mysql.sock
  default-character-set = utf8mb4
   
   
  [mysqld]
  socket=/tmp/mysql.sock
  datadir=/usr/local/mysql/data
  basedir = /usr/local/mysql
  #user = mysql
  #bind-address = 0.0.0.0
   
  skip-external-locking
  key_buffer_size = 384M
  max_allowed_packet = 1M
  table_open_cache = 512
  sort_buffer_size = 2M
  read_buffer_size = 2M
  read_rnd_buffer_size = 8M
  myisam_sort_buffer_size = 64M
  thread_cache_size = 8
  query_cache_size = 32M
   
  ## dns query
  skip-name-resolve
   
  ## connection
  max_connections = 1000
  max_connect_errors = 1000
  wait_timeout= 60
   
  ## slow-queries
  #slow_query_log = /var/log/slow-queries.log
  #long_query_time = 3
  #log-slow-queries = /var/log/mysql-slow-queries.log
   
  ## timestamp
  explicit_defaults_for_timestamp
   
  symbolic-links=0
  
  ## binlog
  server-id = 1
  log-bin = /usr/local/mysql/data/mysql-bin
  binlog_cache_size = 2M
  max_binlog_size = 100M 
  expire_logs_days = 7
  
   
  ## log
  log_warnings     = 2
  log-error = /usr/local/mysql/data/mysqld.log
  pid-file = /usr/local/mysql/data/mysqld.pid
  
   
  ## chracter
  skip-character-set-client-handshake
  init_connect = SET NAMES utf8mb4
  character-set-server = utf8mb4
  
   
  symbolic-links=0
   
  ## Password Policy
  #plugin-load-add=validate_password.so 
  #validate_password_policy= 0 ## LOW
  #validate_password_policy= 1 ## MEDIUM
  #validate_password_policy= 2 ## STRONG
   
   
  ## MyISAM Spectific options
  default-storage-engine = myisam
  key_buffer_size = 32M
  bulk_insert_buffer_size = 64M
  myisam_sort_buffer_size = 128M
  myisam_max_sort_file_size = 10G
  myisam_repair_threads = 1
   
   
  ## INNODB Spectific options
  default-storage-engine = InnoDB
  #skip-innodb
  #innodb_additional_mem_pool_size = 16M
  #innodb_buffer_pool_size = 1024MB
  innodb_data_file_path = ibdata1:10M:autoextend
  #innodb_write_io_threads = 8
  #innodb_read_io_threads = 8
  #innodb_thread_concurrency = 16
  #innodb_flush_log_at_trx_commit = 1
  #innodb_log_buffer_size = 8M
  #innodb_log_file_size = 128M
  #innodb_log_files_in_group = 3
  #innodb_max_dirty_pages_pct = 90
  #innodb_lock_wait_timeout = 120
   
   
  [mysqldump]
  default-character-set = utf8mb4
  max_allowed_packet = 16M
   
  [mysql]
  no-auto-rehash
  default-character-set = utf8mb4
   
  [myisamchk]
  key_buffer_size = 256M
  sort_buffer_size = 256M
  read_buffer = 2M
  write_buffer = 2M
  

• 초기 DB 설치

• cd /usr/local/mysql/
  scripts/mysql_install_db
  chown -R mysql:mysql ./data
  

• systemd 등록

• cp /usr/local/mysql/support-files/systemd/mariadb.service /etc/systemd/system/
  
  cd /etc/systemd/system/
  ln -s mariadb.service mysql.service
  ln -s mariadb.service mysqld.service
  
  systemctl daemon-reload
  systemctl enable mariadb
  systemctl start mariadb
  

• 추가 설정

• # mysql logrotate
  cp /usr/local/mysql/support-files/mariadb.logrotate /etc/logrotate.d/
  
  # 명령어 link
  ln -s /usr/local/mysql/bin/mysql /usr/bin/
  ln -s /usr/local/mysql/bin/mysqldump /usr/bin/
  
  # 오류 error while loading shared libraries: libncurses.so.5
  dnf install ncurses-devel
  

• 패스워드 복잡도 설정

• # mysql shell 에서
  install soname 'simple_password_check';
  

   
• 

• # /etc/my.cnf [mysqld] 에 아래 내역 추가
  ## simple password check
  simple_password_check = ON
  simple_password_check_minimal_length = 8
  simple_password_check_digits = 1
  simple_password_check_letters_same_case = 1
  simple_password_check_other_characters = 1
  

여기까지 mariadb 11.4.2 버전 설치에 대해 기록합니다.

apache 설치에 대한 부분은 다음 게시물에 기록 남기겠습니다.

​

감사합니다.

호스팅 전문기업 비아웹