MySQL sqlrelay (Queue 서버 설치) SQL Relay는 강력한 데이터베이스 연결 관리 솔루션입니다

[client] port=3306 socket=/tmp/mysql.sock [mysqld_safe] socket = /tmp/mysql.sock nice = 0 [mysqld] user=mysql port=3306 sql-mode=ANSI_QUOTES,STRICT_ALL_TABLES,STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION lc_messages_dir = /mysql/share/ lc_messages = en_US basedir=/mysql socket=/tmp/mysql.sock pid-file=/data/tmp/mysql.pid datadir=/data/var tmpdir=/data/tmp log-error=/data/var/mysql.err slow_query_log_file=/data/var/slow.log slow_query_log=1 long_query_time=3 innodb_data_home_dir=/data/ibdata innodb_log_group_home_dir=/data/ibdata #lower_case_table_names=1 # Character set Config character-set-client-handshake=FALSE character-set-server=utf8 init_connect=SET collation_connection = utf8_general_ci init_connect=SET NAMES utf8 skip-name-resolve=1 log_timestamps=SYSTEM log_error_verbosity=1 # Common Config back_log=1024 ft_min_word_len=4 interactive_timeout=600 join_buffer_size=2M max_allowed_packet=16M max_heap_table_size=1G max_connections=500 max_connect_errors=999999 performance_schema read_buffer_size=2M read_rnd_buffer_size=20M skip-external-locking sort_buffer_size=2M max_length_for_sort_data=1024 tmp_table_size=1024M table_open_cache=2000 transaction-isolation= REPEATABLE-READ open_files_limit = 1024 slave-net-timeout=3 # Innodb config innodb_checksum_algorithm=NONE innodb_buffer_pool_size = 512M innodb_data_file_path=ibdata1:1G;ibdata2:1G;ibdata3:1024M:autoextend innodb_file_per_table=1 innodb_flush_method=O_DSYNC innodb_lock_wait_timeout=10 innodb_log_buffer_size=8M innodb_log_file_size=256M innodb_log_files_in_group=2 innodb_thread_sleep_delay=0 innodb_fast_shutdown innodb_autoinc_lock_mode=1 innodb_thread_concurrency = 4 innodb_read_io_threads = 2 innodb_write_io_threads = 2 innodb_open_files = 1024 innodb_doublewrite=0 innodb_flush_log_at_trx_commit=1 # Query Cache Disable query_cache_type=0 query_cache_size=0 # Replication related settings log-bin=/data/binlog/mysql-bin log_bin_trust_function_creators = 1 expire_logs_days=5 max_binlog_size=100M sync_binlog=1 binlog_cache_size=1M binlog_format=row binlog_row_image=minimal binlog_checksum=none log_slave_updates=1 server-id=1851 gtid_mode=off enforce_gtid_consistency=off binlog-ignore-db=performance_schema binlog-ignore-db=information_schema binlog-ignore-db=sys local-infile=0 [mysqldump] quick max_allowed_packet=64M [mysqladmin] user = root

#!/bin/bash stty erase ^H mysql_filename=`ls mysql-5.7.21-linux-glibc2.12-x86_64.tar.gz` mysql_filename2=`echo "${mysql_filename}" |sed "s/.tar.gz//g"` echo "mysql version : ${mysql_filename2}" echo -e "mysql configuration directory : default) /etc" read conf_dir echo -e "mysql configuration file name : default) my.cnf" read conf_file if [ -z ${conf_dir} ]; then conf_dir="/etc" fi if [ -z ${conf_file} ]; then conf_file="my.cnf" fi basedir=`cat my.cnf | grep basedir | cut -d "=" -f 2 | sed 's/ //g'` charset=`cat my.cnf | grep character-set-server | cut -d "=" -f 2 | sed 's/ //g'` datadir=`cat my.cnf | grep datadir | cut -d "=" -f 2 | sed 's/ //g'` datadir2=`cat my.cnf | grep datadir | cut -d "=" -f 2 | sed 's/ //g' | cut -d "/" -f 2` binlog_fullpath=`cat my.cnf | grep log-bin | cut -d "=" -f 2 | sed 's/ //g'` binlog_path=`cat my.cnf | grep log-bin | cut -d "=" -f 2 | sed 's/mysql-bin//g'` echo "========================" echo "configuration " echo "========================" echo "conf_dir : ${conf_dir}" echo "conf_file : ${conf_file}" echo "basedir : ${basedir}" echo "charset : ${charset}" echo "datadir_fullpath : ${datadir}" echo "datadir_name : ${datadir2}" echo "binlog_fullpath : ${binlog_fullpath}" echo "========================" echo -e "Is it correct? (y/n)" read sucess_yn if [ ${sucess_yn} == "n" ]; then exit 0; elif [ ${sucess_yn} == "y" ]; then continue; else echo "not correct stop" exit 0; fi yum -y install zlib curl yum -y install gcc g++ cpp gcc-c++ yum -y install openssl openssl-devel yum -y install libtermcap-devel ncurses-devel libc-client-devel bzip2-devel yum -y install bison yum -y install libaio cp -f my.cnf ${conf_dir}/${conf_file} tar xvzf ${mysql_filename2}.tar.gz if [ -d ${basedir} ]; then mv ${mysql_filename2}/* ${basedir}/ else mv ${mysql_filename2} ${basedir} fi mkdir -p /${datadir2}/ibdata mkdir -p /${datadir2}/tmp mkdir -p /${datadir2}/var mkdir -p /${binlog_path} mysql_group_cnt=`cat /etc/group | grep mysql | wc -l` if [ ${mysql_group_cnt} -eq 0 ]; then groupadd mysql useradd -r -g mysql mysql fi chown -R mysql.mysql ${basedir} chown -R mysql.mysql /${datadir2}/ibdata chown -R mysql.mysql /${datadir2}/tmp chown -R mysql.mysql ${datadir} chown -R mysql.mysql ${binlog_path} ${basedir}/bin/mysqld --defaults-file=${conf_dir}/${conf_file} --basedir=${basedir} --datadir=${datadir} --explicit_defaults_for_timestamp --initialize /mysql/bin/mysqld_safe --defaults-file=${conf_dir}/${conf_file} &

$ ls -al -rw-r--r-- 1 root root 2765 Jul 9 13:57 my.cnf -rw-r--r-- 1 root root 2605 Jul 9 13:55 setup_binary.sh -rw-rw-r-- 1 han han 641798603 Apr 9 14:15 mysql-5.7.21-linux-glibc2.12-x86_64.tar.gz $ /bin/bash ./setup_binary.sh mysql version : mysql-5.7.21-linux-glibc2.12-x86_64 mysql configuration directory : default) /etc mysql configuration file name : default) my.cnf ======================== configuration ======================== conf_dir : /etc conf_file : my.cnf basedir : /mysql charset : utf8 datadir_fullpath : /data/var datadir_name : data binlog_fullpath : /data/binlog/mysql-bin ======================== Is it correct? (y/n)