目录
1.安装mycat以及更改相应的配置文件
[root@mycat2 ~]# ls
anaconda-ks.cfg initial-setup-ks.cfg mycat Mycat-server-1.6-RELEASE-20161028204710-linux.tar.gz 公共 模板 视频 图片 文档 下载 音乐 桌面
[root@mycat2 ~]# mv mycat/ /usr/local/
[root@mycat2 ~]# cd /usr/local/
[root@mycat2 ~]# ls
bin etc games include lib lib64 libexec mycat sbin share src
[root@mycat2 ~]# yum -y install java-1.8.0-openjdk-devel
[root@mycat2 ~]# cd /usr/local/mycat/conf
[root@mycat2 conf]# vim server.xml
写表
80 <user name="root">
81 <property name="password">123456</property>
82 <property name="schemas">virtual-table</property>
读表
95 <user name="user">
96 <property name="password">user</property>
97 <property name="schemas">virtual-table</property>
98 <property name="readOnly">true</property>
99 </user>
[root@mycat2 conf]# vim schema.xml
<?xml version="1.0"?>
<!DOCTYPE mycat:schema SYSTEM "schema.dtd">
<mycat:schema xmlns:mycat="http://io.mycat/">
<schema name="mydb" checkSQLschema="false" sqlMaxLimit="100" dataNode="dn1">
</schema>
<dataNode dataHost="localhost1" database="zhu" name="dn1"/>
<dataHost name="localhost1" maxCon="1000" minCon="10" balance="3"
writeType="0" dbType="mysql" dbDriver="native" switchType="1" slaveThreshold="100">
<heartbeat>select user()</heartbeat>
<!-- can have multi write hosts -->
<writeHost host="hostMaster" url="192.168.4.7:3306" user="root" password="123456">
<!-- can have multi read hosts -->
<readHost host="hostS2" url="192.168.4.8:3306" user="root" password="123456" />
</writeHost>
</dataHost>
</mycat:schema>
解释:
name="mydb" 是虚拟的表名,dataNode="dn1"是虚拟的数据库
database="zhu"是真实对应的库名 ,
url="192.168.4.7:3306" user="root" password="123456" 真实对应的数据库服务IP和用户名密码,主要用来连接数据库。
2.检查mycat服务是否开启
[root@mycat ~]# ss -untlp | grep 8066
[root@mycat ~]# /usr/local/mycat/bin/mycat start
Starting Mycat-server...
[root@mycat ~]# jps
1521 WrapperSimpleApp
1555 Jps
[root@mycat ~]# ss -untlp | grep 8066
tcp LISTEN 0 100 :::8066 :::* users:(("java",pid=1521,fd=78))
3.用客户端验证是否成功
[root@room9pc01 ~]# mysql -uuser -puser -h192.168.4.11 -P8066 ----读验证是否成功 连接的IP是装mycat对应的服务器的IP
[root@room9pc01 ~]# mysql -uroot -p123456 -h192.168.4.11 -P8066 ---写验证是否成功