配置主从mysql服务器

配置从mysql服务器1. 安装主mysql步骤（参考tar包中的INSTALL-BINARY文件即可，很简单）略2. 配置从机的/etc/my.cnf文件关键性的配置log-bin=mysql-binserver-id = 2master-host = 10.1.68.110master-user = backupmaster-password = 1234qwermaster-port = 3306replicate-do-db=icingareplicate-do-db=DB2binlog-do-db=DB3 //需要同步的数据库，如果没有本行，即表示同步所有的数据库binlog-ignore-db=mysql //被忽略的数据库保存退出3. 重启从机的mysql服务，基本的从机配置完成。4. 若从服务器的偏移量与主机不同，手动修改偏移量（1）先查看主机的状态信息mysql> show master status;（2）登录从机按照主的Position修改从机的Positionmysql> slave stop;mysql> change master to master_host='10.1.68.110',master_user='backup',master_password='1234qwer',master_log_file='mysql-bin.000011',master_log_pos=62291;mysql> slave start;为了开始复制，你可以运行：mysql> START SLAVE;运行SHOW SLAVE STATUS查看输出结果：mysql> SHOW SLAVE STATUS\G*************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: server1 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000001 Read_Master_Log_Pos: 164 Relay_Log_File: mysql-relay-bin.000001 Relay_Log_Pos: 164 Relay_Master_Log_File: mysql-bin.000001 Slave_IO_Running: Yes Slave_SQL_Running: Yes ...omitted... Seconds_Behind_Master: 0在这里主要是看: Slave_IO_Running=Yes Slave_SQL_Running=Yes主服务器常用命令1. 查看主机状态和Position信息，用来让slave机与master保持一致。mysql> show master status;1.4.2 从服务器常用命令mysql> show slave status;mysql> slave stop;mysql> slave start;mysql> show processlist;mysql> show master status; CHANGE MASTER TO MASTER_HOST='192.168.1.112', MASTER_USER='backup', MASTER_PASSWORD='1234baup', MASTER_LOG_FILE='mysql-bin.000068', MASTER_LOG_POS=55465309;