Mycat1.6基础用法之--简单实现mysql高可用

最新推荐文章于 2022-10-24 20:32:40 发布

weixin_33709590

最新推荐文章于 2022-10-24 20:32:40 发布

阅读量100

点赞数

文章标签：数据库 python

原文链接：https://my.oschina.net/wangyunlong/blog/3048156

版权

2019独角兽企业重金招聘Python工程师标准>>>

cat /app/mycat/conf/server.xml

<user name="root" defaultAccount="true">
        <property name="password">rootpwd123456</property>
        <property name="schemas">testwyl</property>
</user>
<user name="wyl">
        <property name="password">123456</property>
        <property name="schemas">testwyl</property>
        <property name="readOnly">true</property>
</user>

cat /app/mycat/conf/schema.xml

[root@centos scripts]# cat /app/mycat/conf/schema.xml
<?xml version="1.0"?>
<!DOCTYPE mycat:schema SYSTEM "schema.dtd">
<mycat:schema xmlns:mycat="http://io.mycat/">
    <schema name="testwyl" checkSQLschema="false" sqlMaxLimit="100" dataNode="dn1">
    </schema>
    <dataNode name="dn1" dataHost="localhost01" database="testwyl" />
    <dataHost name="localhost01" maxCon="200" minCon="20" balance="1" writeType="0" dbType="mysql" dbDriver="native" switchType="1"  slaveThreshold="100">
             <heartbeat>select user()</heartbeat>
            <writeHost host="hostM1" url="127.0.0.1:3307" user="root" password="rootpwd123456">
            <readHost host="hostS2" url="127.0.0.1:3308" user="root" password="rootpwd123456" />
             </writeHost> 
             <writeHost host="hostS1" url="127.0.0.1:3307" user="root" password="rootpwd123456" />
         </dataHost>
</mycat:schema>

转载于:https://my.oschina.net/wangyunlong/blog/3048156