安装mycat

• 下载
  下载地址为：http://dl.mycat.org.cn/1.6.7.5/2020-4-10/

  wget http://dl.mycat.org.cn/1.6.7.5/2020-4-10/Mycat-server-1.6.7.5-release-20200410174409-linux.tar.gz

• 解压

  tar -zxvf  Mycat-server-1.6.7.5-release-20200410174409-linux.tar.gz
  

• 将mycat移动到/usr/local/mycat

  mv mycat/ /usr/local/mycat
  

• 配置环境变量
  然后键入命令source /etc/profile 使配置文件生效

  vim /etc/profile
  

  export MYCAT_HOME=/usr/local/mycat
  export PATH=$MYCAT_HOME/bin:$PATH:$JAVA_HOME/bin
  

配置

• 进入conf目录

  cd /usr/local/mycat/conf
  

• 备份server.xml

  cp server.xml{,.bak}
  

• 修改server.xml

  <user name="mycat">
   <propery name="password">123456</propery>
   <!--使用名称为TESTDB的schema的 -->
   <propery name="schemas">usercenter</propery>
  </user>
  

• 备份schema.xml

  cp schema.xml{,.bak}
  

• 修改schema.xml

  <?xml version="1.0"?>
  <!DOCTYPE mycat:schema SYSTEM "schema.dtd">
  <mycat:schema xmlns:mycat="http://io.mycat/">
   <schema name="usercenter" checkSQLschema="false" sqlMaxLimit="100" dataNode="dn1">
   </schema>
   <dataNode name="dn1" dataHost="host1" database="msb" />
   <dataHost name="host1" maxCon="1000" minCon="10" balance="1"
             writeType="0" dbType="mysql" dbDriver="native" switchType="1"  slaveThreshold="100">
       <heartbeat>select user()</heartbeat>
       <writeHost host="hostM1" url="192.168.1.61:3306" user="root"
                  password="123456">
           <readHost host="hostS1" url="192.168.1.64:3306" user="root" password="123456"></readHost>
       </writeHost>
       <writeHost host="hostM2" url="192.168.1.62:3306" user="root"
                  password="123456">
           <readHost host="hostS2" url="192.168.1.63:3306" user="root" password="123456"></readHost>
       </writeHost>
   </dataHost>
  </mycat:schema>
  

• server.xml和schema.xml传输到master

  scp server.xml 192.168.1.62:/usr/local/mycat/conf/server.xml
  scp schema.xml 192.168.1.62:/usr/local/mycat/conf/schema.xml
  

• 启动mycat
  控制台启动：去mycat/bin目录下执行 ./mycat console
  后台启动：去mycat/bin目录下执行 ./mycat start

• 登录mycat

  • 管理窗口的登录

    mysql -uroot -p123456 -P 9066 -h 192.168.85.111
    

  • 数据窗口的登录

    mysql -uroot -p123456 -P8066 -h 192.168.85.111
    

  • Dbeaver
    

• 开机启动
  ``` ln -s /usr/local/mycat/bin/mycat /etc/init.d/mycat

service mycat start

chkconfig —add mycat ```