Skip to content

Latest commit

 

History

History
126 lines (90 loc) · 3.83 KB

README.md

File metadata and controls

126 lines (90 loc) · 3.83 KB
Raw

DMDS

DMDS(Distributed MySQL Database Service) is a MySQL sharding middleware base on MyCAT.

What is Different ?

  • Table sharding

    Support sharding database and table in the same time.

  • Simplify

    Focus on MySQL , remove some unnecessary features like zookeeper config 、 catlte .

Deploy

  • Package

    After download source code, package it with maven and JDK (verison >= 7).

    mvn clean package -DskipTests=true

  • Start

    Copy package dmds-server-xxx.tar to deploy directory. Run bin/startup.sh after unzip it.

    cp target/dmds-server-xxx.tar.gz deploy/
cd deploy/
tar -xf dmds-server-xxx.tar.gz
cd dmds-server-1.0.0/
./bin/startup.sh

  • Stop

    Run bin/stop.sh to stop it.

Sharding Configuration Example

Configuration files are under conf directory like MyCAT. Let's see an example for 8 sharding tables in 2 databases.

  • schema.xml

    Configure hostNode、dataNode and schema. Schema name is dmds_test , data node is dn_dmds_test_00 and dn_dmds_test_01

        <schema name="dmds_test" checkSQLschema="true" sqlMaxLimit="5000" dataNode="dn_dmds_test_00">
        <table name="ts_order" primaryKey="id" dataNode="dn_dmds_test_00, dn_dmds_test_01"
               rule="rule_dmds_test_ts_order"/>
    </schema>
    <dataNode name="dn_dmds_test_00" dataHost="dh_dmds_test_00" database="dmds_test_00"/>
    <dataNode name="dn_dmds_test_01" dataHost="dh_dmds_test_00" database="dmds_test_01"/>
    <dataHost name="dh_dmds_test_00" maxCon="100" minCon="1" balance="0" writeType="0" dbType="mysql"
              dbDriver="native" switchType="1" slaveThreshold="100">
        <heartbeat>select 1</heartbeat>
        <writeHost host="M-dh_dmds_test_00" url="localhost:3306" user="dmds_test_user" password="pwd135"/>
    </dataHost>

  • rule.xml

    Configure tableRule and sharding function. Function class must be com.zhongan.dmds.route.function.PartitionTbByMod.

    • shardColumnType

      Data type of sharding column, 0 for numerical and 1 for string.

    <tableRule name="rule_dmds_test_ts_order">
    <rule>
        <columns>id</columns>
        <algorithm>function_dmds_test_ts_order</algorithm>
    </rule>
</tableRule>
<function name="function_dmds_test_ts_order"
          class="com.zhongan.dmds.route.function.PartitionTbByMod">
    <property name="dbCount">2</property>
    <property name="tbCount">4</property>
    <property name="shardColumnType">0</property>
</function>

  • server.xml

    Configure access user. user name is dmds_test

        <user name="dmds_test">
        <property name="password">4fe313bd</property>
        <property name="schemas">dmds_test</property>
    </user>

  • Table distributed

    The physical table is distributed in order on 2 databases. Table names are automatically generated.

    select TABLE_SCHEMA, TABLE_NAME from information_schema.TABLES where TABLE_SCHEMA like 'dmds_test_%' and TABLE_NAME like 'ts_order_%';
+--------------+---------------+
| TABLE_SCHEMA | TABLE_NAME    |
+--------------+---------------+
| dmds_test_00 | ts_order_0000 |
| dmds_test_00 | ts_order_0001 |
| dmds_test_00 | ts_order_0002 |
| dmds_test_00 | ts_order_0003 |
| dmds_test_01 | ts_order_0004 |
| dmds_test_01 | ts_order_0005 |
| dmds_test_01 | ts_order_0006 |
| dmds_test_01 | ts_order_0007 |
+--------------+---------------+

Contributing

See Contributing to DMDS for details on reporting bugs and commit pull request.

License

DMDS are licensed under GPL2.0 license

More Information

For more information, please see MyCAT documents.