mysql简单主从部署（rhel6.4）

两台虚拟机一个master一个slave
分别安装数据库

yum install mysql mysql-server -y/etc/init.d/mysqld restart

vim /etc/my.cnf
master

[mysqld]character-set-server = utf8datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sockuser=mysql# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0port=3306log-bin=/var/lib/mysql/mysql-binlogserver-id=1binlog_do_db=handb[mysqld_safe]log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pid

slave
vim /etc/my.cnf

[mysqld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sockuser=mysql# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0log-bin=/var/lib/mysql/mysql-binlogserver-id=2replicate-do-db=handbmaster-host=172.25.254.118master-user=hanmaster-password=hanmaster-port=3306master-connect-retry=1[mysqld_safe]log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pid

master

mysql> show master status;+---------------------+----------+--------------+------------------+| File                | Position | Binlog_Do_DB | Binlog_Ignore_DB |+---------------------+----------+--------------+------------------+| mysql-binlog.000002 |      952 | handb        |                  |+---------------------+----------+--------------+------------------+1 row in set (0.00 sec)mysql> 

slave

mysql> show slave status\G*************************** 1. row ***************************               Slave_IO_State: Waiting for master to send event                  Master_Host: 172.25.254.118                  Master_User: han                  Master_Port: 3306                Connect_Retry: 60              Master_Log_File: mysql-binlog.000002          Read_Master_Log_Pos: 952               Relay_Log_File: mysqld-relay-bin.000011                Relay_Log_Pos: 500        Relay_Master_Log_File: mysql-binlog.000002             Slave_IO_Running: Yes   #重点看这两个是不是yes            Slave_SQL_Running: Yes              Replicate_Do_DB: handb          Replicate_Ignore_DB:            Replicate_Do_Table:        Replicate_Ignore_Table:       Replicate_Wild_Do_Table:   Replicate_Wild_Ignore_Table:                    Last_Errno: 0                   Last_Error:                  Skip_Counter: 0          Exec_Master_Log_Pos: 952              Relay_Log_Space: 1229              Until_Condition: None               Until_Log_File:                 Until_Log_Pos: 0           Master_SSL_Allowed: No           Master_SSL_CA_File:            Master_SSL_CA_Path:               Master_SSL_Cert:             Master_SSL_Cipher:                Master_SSL_Key:         Seconds_Behind_Master: 0Master_SSL_Verify_Server_Cert: No                Last_IO_Errno: 0                Last_IO_Error:                Last_SQL_Errno: 0               Last_SQL_Error: 1 row in set (0.00 sec)mysql> mysql> show processlist\G

然后只要在master上建立了在配置文件里面写的数据库之后。slave里面就会出现。