-
mysql读写分离配置
首先配置安装MySQL主从
下载mycat服务
修改配置文件schema.xml
-
1234567891011121314151617
<?xml version="1.0"?><!DOCTYPE mycat:schema SYSTEM"schema.dtd"><mycat:schema xmlns:mycat="http://io.mycat/"><schema name="database1"checkSQLschema="false"sqlMaxLimit="100"dataNode="dn1"> </schema><dataNode name="dn1"dataHost="ssss"database="database1"/><dataHost name="ssss"maxCon="1000"minCon="10"balance="1"writeType="0"dbType="mysql"dbDriver="native"switchType="-1"slaveThreshold="100"><heartbeat>selectuser()</heartbeat><writeHost host="cluster1"url="10.2.2.105:3306"user="root"password="root"><readHost host="cluster2"url="10.2.2.105:3307"user="root"password="root"/><readHost host="cluster3"url="10.2.2.105:3308"user="root"password="root"/></writeHost></dataHost></mycat:schema>
修改 server.xml
|
1
2
3
4
5
6
7
8
9
10
11
12
|
<?xml version=
"1.0"
encoding=
"UTF-8"
?>
<!DOCTYPE mycat:server SYSTEM
"server.dtd"
>
<mycat:server xmlns:mycat=
"http://io.mycat/"
>
<system>
<
/system
>
<user name=
"admin"
>
<property name=
"password"
>admin<
/property
>
<property name=
"schemas"
>database1<
/property
>
<
/user
>
<
/mycat
:server>
~
|
启动mycat ./mycat start
查看端口
# netstat -tnlp TCP *:9066 (LISTEN) #虚拟schema管理端口 TCP *:8066 (LISTEN) #虚拟schema登陆端口
登录mycat读写分离服务:
mysql -uroot -p123456 -h127.0.0.1 -P 8066
本文转自 tianshuai369 51CTO博客，原文链接:http://blog.51cto.com/kkkkkk/2057425
