Mycat

下载安装

下载地址：http://dl.mycat.org.cn/

[root@dlb local]# tar -zxvf Mycat-server-1.6.7.6-release-20210930213049-linux.tar.gz -C /usr/local/    #解压到这个目录下
#加压既安装

配置文件

①schema.xml：定义逻辑库，表、分片三个节点等内容

    <schema name="mycatdb" checkSQLschema="false" sqlMaxLimit="100" randomDataNode="dn1">
        
        

        <table name="customer" primaryKey="id" dataNode="dn1,dn2" rule="test-rule" autoIncrement="true" fetchStoreNodeByJdbc="true">
            <childTable name="customer_addr" primaryKey="id" joinKey="customer_id" parentKey="id"> childTable>
        table>
        
    schema>
    
        
    <dataNode name="dn1" dataHost="localhost1" database="msa" />
    <dataNode name="dn2" dataHost="localhost1" database="msb" />

    
    <dataHost name="localhost1" maxCon="1000" minCon="10" balance="3"
              writeType="0" dbType="mysql" dbDriver="jdbc" switchType="2"  slaveThreshold="100">
              
        <heartbeat>select slave statusheartbeat>
        
        
        <writeHost host="master1" url="jdbc:mysql://47.101.165.96:3306" user="admin" password="Amanda+3213">
            <readHost host="slave1" url="jdbc:mysql://47.97.32.153:3306" user="admin" password="Amanda+3213"/>
        writeHost>
        
    dataHost>

②rule.xml：定义分片规则

    <tableRule name="test-rule">
        <rule>
            <columns>idcolumns>
            <algorithm>mod-longalgorithm>
        rule>
    tableRule>

    <function name="mod-long" class="io.mycat.route.function.PartitionByMod">
        
        
        <property name="count">2property>
    function>

③server.xml：定义用户以及系统相关变量，如端口等

    <user name="mycat1" defaultAccount="true">
        <property name="password">123456property>
        
        <property name="schemas">mycatdbproperty>
        <property name="defaultSchema">TESTDBproperty>
        
        
        
        
        
    user>

    <user name="user">
        <property name="password">userproperty>
        <property name="schemas">mycatdbproperty>
        <property name="readOnly">trueproperty>
        <property name="defaultSchema">mycatdbproperty>
    user>

管理

#下面命令必须切换到mycat的bin目录下执行  默认端口号 8066
./mycat start #启动
./mycat stop  #停止
./mycat status #查看状态
./mysql-umycat -p -
./mysql -uroot -p123456 -P8066