techapi 님의 블로그

1. master 에서 작업  show processlist; 2. master 에서 작업  show master status\G;   -> File, Position 값 확인 3. slave 에서 작업 (repl user 생성)use mysql; create user 'repl_user'@'%' identified by 'pass1234';grant replication slave on *.* to 'repl_user'@'%';flash privileges; 생성 확인select * user; 4. slave 에서 작업 (pos 값 설정 -> 2에서 확인한 값 등록)change master tomaster_host='172.27.17.51',master_user='repl_user',master_pas..

1. 환경 추가/etc/yum.repo.d/maria.repo # MariaDB 10.2 CentOS repository list - created 2017-09-07 02:00 UTC# http://downloads.mariadb.org/mariadb/repositories/[mariadb]name = MariaDBbaseurl = http://yum.mariadb.org/10.2/centos6-amd64gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDBgpgcheck=1 mysql 로그인SET PASSWORD = PASSWORD('123456'); update user set password=password('PQ$p6h3kTEs') where user='roo..