- <dataHost name="localhost1" maxCon="1000" minCon="10" balance="0" writeType="0"
- dbType="mysql" dbDriver="native" switchType="1" slaveThreshold="100">
- <heartbeat>
- select user()
- </heartbeat>
- <writeHost host="hostM1" url="192.168.4.21:3306" user="ooo" password="123456">
- </writeHost>
- </dataHost>
- <dataHost name="localhost2" maxCon="1000" minCon="10" balance="0" writeType="0"
- dbType="mysql" dbDriver="native" switchType="1" slaveThreshold="100">
- <heartbeat>
- select user()
- </heartbeat>
- <writeHost host="hostM2" url="192.168.4.22:3306" user="ooo" password="123456">
- </writeHost>
- </dataHost>
- <dataHost name="localhost3" maxCon="1000" minCon="10" balance="0" writeType="0"
- dbType="mysql" dbDriver="native" switchType="1" slaveThreshold="100">
- <heartbeat>
- select user()
- </heartbeat>
- <writeHost host="hostM3" url="192.168.4.23:3306" user="ooo" #指定 hostM3
- 名称主机对应的 ip 地址
password="123456"> #访问数据库时, mycat 服务连接数据库服务器时使用的用户名和密码
- </writeHost>
- </dataHost>
- </mycat:schema>
添加 PATH 路径
- [[email protected] ~]# export PATH=/usr/local/mycat/bin:KaTeX parse error: Expected 'EOF', got '#' at position 21: ...[[email protected] ~]#? echo "PATH=/us...PATH">> /etc/profile
- [[email protected] ~]# source /etc/profile
- [[email protected] ~]# echo $PATH
- /usr/local/mycat/bin:/usr/local/mycat/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin
- [[email protected] ~]# which mycat
- /usr/local/mycat/bin/mycat
启动服务并查看端口
- [[email protected] ~]# mycat start #起服务
- Starting Mycat-server...
- [[email protected] ~]# netstat -antup | grep :8066 #查看端口
- tcp6 0 0 :::8066 ::?? LISTEN 18613/java
- [[email protected] ~]# ps -C java #查看进程
- PID TTY TIME CMD
- 18613 ? 00:00:01 java
用 ooo 用户登入
- [[email protected] ~]# MySQL -h192.168.4.21 -uooo -p123456
- MySQL> show processlist;
±-±-----±-------------------±-----±--------±-----±---------±-----------------+
| Id | User | Host | db | Command | Time | State | Info |
±-±-----±-------------------±-----±--------±-----±---------±-----------------+
- | 17 | ooo | 192.168.4.24:50180 | db1 | Sleep | 46 | | NULL |
- | 18 | ooo | 192.168.4.24:50182 | db1 | Sleep | 26 | | NULL |
- | 19 | ooo | 192.168.4.24:50184 | db1 | Sleep | 56 | | NULL |
- | 20 | ooo | 192.168.4.24:50186 | db1 | Sleep | 36 | | NULL |
- | 21 | ooo | 192.168.4.24:50188 | db1 | Sleep | 6 | | NULL |
- | 22 | ooo | 192.168.4.24:50190 | db1 | Sleep | 76 | | NULL |
- | 23 | ooo | 192.168.4.24:50192 | db1 | Sleep | 86 | | NULL |
- | 24 | ooo | 192.168.4.24:50194 | db1 | Sleep | 16 | | NULL |
- | 25 | ooo | 192.168.4.24:50196 | db1 | Sleep | 66 | | NULL |
- | 26 | ooo | 192.168.4.24:50198 | db1 | Sleep | 96 | | NULL |
- | 28 | ooo | 192.168.4.20:53532 | NULL | Query | 0 | starting | show processlist |
±-±-----±-------------------±-----±--------±-----±---------±-----------------+
11 rows in set (0.00 sec)
来源: http://www.bubuko.com/infodetail-3087002.html