以下两个节点安装
1：防火墙打开相应端口
#? /sbin/iptables -I INPUT -p tcp --dport 3306 -j ACCEPT
#? /etc/rc.d/init.d/iptables save
2：安装相关依赖包
#? yum -y install gcc gcc-c++ ncurses ncurses-devel openssl openssl-devel cmake perl lsof bison
3：删除自带的mysql
#? rpm -qa|grep mysql
#? rpm -e --allmatches --nodeps mysql-libs-5.1.71-1.el6.x86_64
4：创建相关目录
#? mkdir /linuxidc/soft
#? mkdir -p /linuxidc/mysql/data/
5：创建mysql用户
#? /usr/sbin/groupadd mysql
#? /usr/sbin/useradd -s /sbin/nologin -M -g mysql mysql
#? chown -R mysql:mysql /linuxidc/mysql/
6：安装mysql
#? cd /linuxidc/soft
#? tar -zxvf mysql-5.6.19.tar.gz
#? cd mysql-5.6.19
#? cmake -DCMAKE_INSTALL_PREFIX=/linuxidc/server/mysql -DMYSQL_DATADIR=/linuxidc/mysql/data -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -DSYSCONFDIR=/etc/ -DWITH_SSL=yes -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_READLINE=on
#? make && make install
7：修改相关目录权限并创建软连接
#? chmod +w /linuxidc/server/mysql
#? chown -R mysql:mysql /linuxidc/server/mysql/
#? ln -s /linuxidc/server/mysql/lib/lib* /usr/lib/
#? ln -s /linuxidc/server/mysql/bin/mysql /usr/bin
8：修改配置文件
#? cp /linuxidc/server/mysql/support-files/my-default.cnf /etc/my.cnf
#? vi /etc/my.cnf
[mysqld]
character-set-server = utf8
default-storage-engine = MyISAM
basedir = /linuxidc/server/mysql
datadir = /linuxidc/mysql/data
log-error = /linuxidc/mysql/mysql_error.log
pid-file = /linuxidc/mysql/mysql.pid
max_allowed_packet = 32M
explicit_defaults_for_timestamp = true
9：安装mysql数据库
#? /linuxidc/server/mysql/scripts/mysql_install_db --basedir=/linuxidc/server/mysql --datadir=/linuxidc/mysql/data --user=mysql
10：设置mysql开机自动启动服务
#? cp /linuxidc/server/mysql/support-files/mysql.server /etc/init.d/mysqld
#? chkconfig --add mysqld
#? chkconfig --level 345 mysqld on
11：修改mysqld文件并启动mysql
#? vi /etc/init.d/mysqld
#修改mysqld文件中的下面两项
basedir=/linuxidc/server/mysql
datadir=/linuxidc/mysql/data
#? service mysqld start
12：创建需同步的数据库
#? mysql -uroot -p
mysql>? create database linuxidc;
mysql>? GRANT ALL PRIVILEGES ON linuxidc.* TO doiido@"%" IDENTIFIED BY 'linuxidc123';
mysql>? exit
--------------------以下在服务器master1上操作
修改配置文件
#? vi /etc/my.cnf
[mysqld]
#默认是1，master和slave不能相同即可
server-id=1
log-bin=bin.log
port=3306
binlog-do-db =linuxidc
#要复制的数据库
replicate-do-db =linuxidc
重启mysql
#? service mysqld restart
建立用于同步的账户
#? mysql -uroot -p
mysql>? grant replication slave on *.* to 'dodo'@'192.168.100.205' identified by 'jjjjjj';
查看File对应值，并记录下来
mysql>? show master status;
+------------------+----------+--------------+------------------+-------------------+
| File? ? ? ? ? ? | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+------------------+----------+--------------+------------------+-------------------+
| bin.000001? ? ? |? ? ? 120 | linuxidc? ? ? |? ? ? ? ? ? ? ? ? |? ? ? ? ? ? ? ? ? |
+------------------+----------+--------------+------------------+-------------------+
mysql>? exit
--------------------以下在服务器master2上操作
2.修改slave上的配置文件my.cnf
#? vi /etc/my.cnf
[mysqld]
server-id=2
port=3306
log-bin=bin.log
binlog-do-db =linuxidc
replicate-do-db =linuxidc
重启mysql
#? service mysqld restart
在从服务器上建立相应的数据库
#? mysql -uroot -p
将192.168.100.204设置为自己的主服务器
mysql>? CHANGE MASTER TO
MASTER_HOST='192.168.100.204',MASTER_PORT=3306,
MASTER_USER='dodo',
MASTER_PASSWORD='jj