mycat安装启动

二、mycat安装启动

(如若没有安装mysql,点击链接https://blog.csdn.net/qq_44624124/article/details/120281803)

1.安装mycat

①tar -zxvf Mycat-server-1.6.7.1-release-20190627191042-linux.tar.gz

②Mv mycat/ /usr/local/

③tar -zxvf Mycat-web-1.0-SNAPSHOT-20170102153329-linux.tar.gz

④mv mycat-web/ /usr/local/

2.解读配置文件

①schema.xml 定义逻辑库，表、分片节点等内容

②rule.xml：定义分片规则

③server.xml：定义用户以及系统相关变量，如端口等

3.启动mycat

3.1.修改配置文件server.xml

  <user name="mycat">
                 <property name="password">789123</property>
                <property name="schemas">TESTDB</property>
         <!--    < property name="readOnly">true</property> -->
       </user> 

3.2.修改配置文件schema.xml

<?xml version="1.0"?> 
<!DOCTYPE mycat:schema SYSTEM "schema.dtd"> 
<mycat:schema xmlns:mycat="http://io.mycat/"> 
<schema name="TESTDB" checkSQLschema="false" sqlMaxLimit="100" dataNode="dn1"> 
</schema> 
<dataNode name="dn1" dataHost="host1" database="testdb" /> 
<dataHost name="host1" maxCon="1000" minCon="10" balance="0" 
writeType="0" dbType="mysql" dbDriver="native" switchType="1" 
slaveThreshold="100"> 
<heartbeat>select user()</heartbeat> 
<!-- can have multi write hosts --> 
<writeHost host="hostM1" url="192.168.140.131:3306" user="root" 
password="789123"> 
<!-- can have multi read hosts --> 
<readHost host="hostS1" url="192.168.119.131:3306" user="root" 
password="789123" /> 
</writeHost> 
</dataHost> 
</mycat:schema> 

3.3.验证数据库访问情况

①Mysql -uroot -p -P 3306 -h 192.168.119.132，输入密码验证

②出现异常情况不能连接，1.可能mysql服务没有启动，2.验证后还是不行就互相连接mysql，加入对面root用户：grant all privileges on . to mycat@‘192.168.119.131’ identified by ‘789123’;

3.4.启动mycat

①进入mycat/bin目录

②两种启动方式：前台启动./mycat console 后台启动 ./mycat start

③输入语句启动连接mycat:mysql -umycat -p -P 9066 -h 192.168.119.131 ,密码为你server.xml配置的密码

④验证是否正常启动

show database;就能看到创建的配置文件创建的这个TESTDB库