MYSQL Master-Slave Installation & Configuration

mysql单机主从

主mysql

yum install gcc

yum install ncurses-devel

yum install gcc-c++

mkdir /usr/local/mysql

mkdir /var/lib/mysql

groupadd mysql

useradd -g mysql mysql

chown mysql.mysql /usr/local/mysql

chown mysql.mysql /var/lib/mysql

./configure --prefix=/usr/local/mysql --with-tcp-port=3306 --with-charset=utf8 --with-extra-charsets=gb2312,big5,gbk,binary,ascii,latin1 --enable-local-infile --with-mysqld-user=mysql

make 

make install

cp 安装包/support-files/my-medium.cnf /etc/my.cnf

cp 安装包/support-files/mysql.server /etc/init.d/mysqld

chmod 755 /etc/init.d/mysqld

cd /usr/local/mysql/bin

./mysql_install_db --user=root --datadir=/var/lib/mysql --basedir=/usr/local/mysql

/etc/init.d/mysqld start

从mysql

mkdir /home/mysql1

mkdir /home/mysql1/data

groupadd mysql1

useradd -g mysql1 mysql1

chown mysql1.mysql1 /home/mysql1

chown mysql1.mysql1 /home/mysql1/data

./configure --prefix=/home/mysql1 --with-tcp-port=3307 --with-charset=utf8 --with-extra-charsets=gb2312,big5,gbk,binary,ascii,latin1 --enable-local-infile --with-mysqld-user=mysql1

make 

make install

cp 安装包/support-files/my-medium.cnf /etc/mysql/my.cnf

cd /usr/local/mysql/bin

./mysql_install_db --user=root --datadir=/home/mysql1/data --basedir=/home/mysql1

mv /etc/my.cnf /etc/my1.cnf

vi /etc/mysql/my.cnf

[mysqld]

user = root

datadir = /home/mysql1/data

basedir = /home/mysql1

port = 3307

socket = /tmp/mysql1.sock

/etc/init.d/mysqld start

主从设置

mkdir /usr/local/mysql/log

chown mysql:mysql /usr/local/mysql/log

mkdir /home/mysql1/log

chown mysql1:mysql1 /home/mysql1/log

cd /home/mysql1/bin

./mysql -uroot --socket=/tmp/mysql1.sock

create user replication identified by ‘123456’;

cd /usr/local/mysql/bin

./mysql -uroot -socket=/tmp/mysql.sock

grant replication slave on *.* to ‘replication’@’12.11.0.106’ identified by ‘123456’;

flush privileges;

vi /etc/mysql/my.cnf

server-id = 2

master_host = 12.11.0.106

master_user = replication

master_password = 123456

master_port = 3306

master_connect-retry=60

replicate-ignore-db=mysql

replicate-same-server-id=1

kill -9 从库PID

mv /etc/my.cnf /etc/my1.cnf

mv /etc/mysql/my1.cnf /etc/mysql/my.cnf

/etc/init.d/mysqld start

mysql -uroot --socket=/tmp/mysql1.sock

source /tmp/test1.sql

start slave

主从切换

ps -ef|grep mysql

kill -9 主库PID

mv /etc/my1.cnf /etc/my.cnf

mv /etc/mysql/my.cnf /etc/mysql/my1.cnf

/etc/init.d/mysqld start

mv /etc/my.cnf /etc/my1.cnf

mv /etc/mysql/my1.cnf /etc/mysql/my.cnf

vi /etc/mysql/my.cnf