linlink~文档构建集群应用系统环境
规划节点
| IP | 主机名 | 节点 |
|---|---|---|
| 192.168.200.11 | mycat | Mycat中间件服务节点 |
| 192.168.200.12 | db1 | MariaDB数据库集群主节点 |
| 192.168.200.13 | db2 | MariaDB数据库集群从节点 |
| 192.168.200.14 | ZooKeeper1 | 集群节点 |
| 192.168.200.15 | ZooKeeper2 | 集群节点 |
| 192.168.200.16 | ZooKeeper3 | 集群节点 |
| 192.168.200.17 | redis | 消息队列服务 |
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mycat:schema SYSTEM "schema.dtd">
<mycat:schema xmlns:mycat="http://io.mycat/">
<schema name="gpmall" checkSQLschema="false" sqlMaxLimit="100" dataNode="dn1"></schema>
<dataNode name="dn1" dataHost="localhost1" database="gpmall" />
<dataHost name="localhost1" maxCon="1000" minCon="10" balance="3" dbType="mysql" dbDriver="native" writeType="0" switchType="1" slaveThreshold="100">
<heartbeat>select user()</heartbeat>
<writeHost host="hostM1" url="192.168.200.12:3306" user="root" password="123456">
<readHost host="hostS1" url="192.168.200.13:3306" user="root" password="123456" />
</writeHost>
</dataHost>
</mycat:schema>
~