융융이'Blog

#[master] 설정 vi /etc/my.cnf ​``` server_id=1 log-bin=mysql-bin ​``` #값 확인하기 mysql -u root -p SHOW VARIABLES LIKE 'server_id'; #replication 계정 확인 grant replication slave, replication client on *.* to repl@'%' identified by '패스워드'; Query OK, 0 rows affected (0.000 sec) select user, host from user; +------+-----------+ | user | host | +------+-----------+ | repl | % | | root | 127.0.0.1 | | root | ..

yum install -y gcc* ncurses-devel cmake # 소스 설치 cd /usr/local/src/ wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.31.tar.gz tar zxvpf mysql-5.6.31.tar.gz cd mysql-5.6.31 #설치 위치 /usr/local/mysql #데이터 위치 /data cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data -DENABLED_LOCAL_INFILE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -..