keepalived+mycat+mysql数据库集群架构搭建

keepalived+mycat+mysql框架搭建

 

节点	ip	软件
mysql136	192.168.136.136	keepalived,mycat,mysql(3306)
mysql137	192.168.136.137	keepalived,mycat,mysql(3306)
mysql138	192.168.136.138	mysql（master3306）
mysql139	192.168.136.139	mysql(slave3306)

1，mysql136,mysql137节点分别安装mycat，mysql，keepalived软件，vip192.168.136.101

2，mysql138，mysql139节点安装mysql软件，并搭建主从复制。

整个集群的架构如下：

3，mysql136，mysql137，mysql138，mysql139各个节点分别安装mysql数据库，并且mysql138，mysql139搭建主从复制，过程简单，不必复述。

4，mysql136，mysql137节点安装mycat软件，

schema.xml 配置，两台mycat配置完全一样。

<?xml version="1.0"?>
<!DOCTYPE mycat:schema SYSTEM "schema.dtd">
<mycat:schema xmlns:mycat="http://io.mycat/">

    <schema name="TESTDB" checkSQLschema="false" sqlMaxLimit="100">
        <!-- auto sharding by id (long) -->
        <table name="travelrecord" dataNode="dn1,dn2,dn3" rule="auto-sharding-long" />

        <!-- global table is auto cloned to all defined data nodes ,so can join
            with any table whose sharding node is in the same data node -->
        <table name="company" primaryKey="ID" type="global" dataNode="dn1,dn2,dn3" />
        <table name="goods" primaryKey="ID" type="global" dataNode="dn1,dn2,dn3" />
        <!-- random sharding using mod sharind rule -->
        <tab