mycat双主高可用架构部署-ER表

置顶龙哥·三年风水

于 2024-09-18 11:11:53 发布

阅读量94

点赞数 2

分类专栏：高可用分布式 MySQL5.7.36 文章标签： mysql 分布式高可用

龙哥·三年风水

本文链接：https://blog.csdn.net/m0_63603104/article/details/142328171

版权

MySQL5.7.36 同时被 3 个专栏收录

34 篇文章 0 订阅

订阅专栏

高可用

25 篇文章 0 订阅

订阅专栏

分布式

20 篇文章 0 订阅

订阅专栏

MySQL5.7服务器IP是192.168.31.209及192.168.31.210

vi /usr/local/mycat/conf/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">
        	<table name="orders" primaryKey="id" dataNode="dn1,dn2" rule="mod-long">
        		<childTable name="orders_user" primaryKey="id" joinKey="order_id" parentKey="id">
        		</childTable>
        	</table>
        </schema>
        <dataNode name="dn1" dataHost="localhost1" database="test" />
        <dataNode name="dn2" dataHost="localhost2" database="test" />
        <dataHost name="localhost1" maxCon="1000" minCon="10" balance="1" writeType="0" dbType="mysql" dbDriver="native" switchType="1">
                <heartbeat>select user()</heartbeat>
                <writeHost host="db1" url="192.168.31.209:3306" user="root" password="123456">
                	<readHost host="db2" url="192.168.31.209:3308" user="root" password="123456" />
                </writeHost>
                <writeHost host="db3" url="192.168.31.210:3306" user="root" password="123456">
                	<readHost host="db4" url="192.168.31.210:3308" user="root" password="123456" />
                </writeHost>
         </dataHost>
         <dataHost name="localhost2" maxCon="1000" minCon="10" balance="1" writeType="0" dbType="mysql" dbDriver="native" switchType="1">
                <heartbeat>select user()</heartbeat>
                <writeHost host="db1" url="192.168.31.210:3307" user="root" password="123456">
                	<readHost host="db2" url="192.168.31.210:3309" user="root" password="123456" />
                </writeHost>
                <writeHost host="db3" url="192.168.31.209:3307" user="root" password="123456">
                	<readHost host="db4" url="192.168.31.209:3309" user="root" password="123456" />
                </writeHost>
         </dataHost>
</mycat:schema>