一：MYSQL主从配置

 　　1.1 部署环境

              主(master_mysql): 192.33.98.206      

　　　    从(slave_mysql):   192.33.98.207    

        1.2 配置文件  /etc/my.cnf

[mysqld] user=mysql # Disabling symbolic-links is recommended to prevent assorted security risks basedir=/usr/local/mysql datadir=/usr/local/mysql/data port = 3306 socket=/tmp/mysql.sock server_id=1 log-error=/usr/local/mysql/log/error.log log_bin=/usr/local/mysql/data/master_bin log_slave_updates=true log_bin_index=/usr/local/mysql/data/master_bin.index

    1.3重启主库的mysql  

service mysqld restart

mysql -uroot -proot

mysql>grant replication slave on *.* to 'slave'@'192.33.98.207' identified by 'root; ##授权给从数据库服务器 192.33.98.207 ，用户名slave，密码root

mysql>show master status ; ##查看主库的状态 file,position这两个值很有用。要放到slave配置中

1.4配置从库文件

/etc/my.cnf

[mysqld] user=mysql # Disabling symbolic-links is recommended to prevent assorted security risks basedir=/usr/local/mysql datadir=/usr/local/mysql/data port = 3306 server_id=2 socket=/tmp/mysql.sock log-error=/usr/local/mysql/log/error.log #读写分离 日志 relay_log_index=slave-relay-bin.index relay_log=slave-relay-log-bin

      1.5配置完毕重启从库

service mysqld restart

mysql -uroot -p M123qwe@t  > change master to master_host='192.33.98.206',

                                           master_user='slave' ,master_password='root', master_log_file='master_bin.000003' ,

                                          master_log_pos=1073194516;

mysql> start slave; ##开启从库 (stop slave：关闭从库）

mysql> show slave status \G;     ###Slave_IO_Running,Slave_SQL_Running 都为Yes的时候表示配置成功

 

 二：Mycat安装、配置

             安装过程就不赘述了

             配置文件 server.xml schema.xml  

           schema.xml

           

          

          server.xml

          

 

          用插件登录mycat

        

 

     

注意重启mycat啊：

1044 2018-10-24 21:02:16 work ./mycat status  1045 2018-10-24 21:02:44 work sudo find / -name mycat 1046 2018-10-24 21:03:12 work ./usr/local/mycat/bin/mycat status 1047 2018-10-24 21:03:24 work cd /usr/local/mycat 1048 2018-10-24 21:03:25 work ll 1049 2018-10-24 21:03:33 work cd bin/ 1050 2018-10-24 21:03:33 work ll 1051 2018-10-24 21:03:38 work ./mycat status 1052 2018-10-24 21:03:42 work ./mycat start 1053 2018-10-24 21:03:45 work ./mycat status 1054 2018-10-24 21:04:31 work pwd 1055 2018-10-24 21:05:06 work history

 

启动MyCat：  ./mycat start  查看启动状态：  ./mycat status  停止：  ./mycat stop  重启：  ./mycat restart