shardingSphere分库分表，读写分离_<shardingsphere:data-source-优快云博客

本文链接：https://blog.youkuaiyun.com/hncaoyuqi/article/details/106239761

本文详细介绍了分库分表策略及主从复制的配置方法，通过具体示例展示了如何使用算法表达式进行数据源和表的规则设置，实现负载均衡和读写分离，提高数据库系统的稳定性和效率。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

分库分表&主从

    <sharding:inline-strategy id="databaseStrategy" sharding-column="id" algorithm-expression="smart_$->{id%2}"/>
    <sharding:inline-strategy id="tableStrategy" sharding-column="id" algorithm-expression="smart_device_test_new_$->{id%2}"/>
    <sharding:data-source id="shardingDataSource">
        <sharding:sharding-rule data-source-names="smart_0,smart_1,smart_2,smart_3">
            <sharding:master-slave-rules>
                <sharding:master-slave-rule id="smart_0" master-data-source-name="smart_0" slave-data-source-names="smart_2" />
                <sharding:master-slave-rule id="smart_1" master-data-source-name="smart_1" slave-data-source-names="smart_3" />
            </sharding:master-slave-rules>
            <sharding:table-rules>
                <sharding:table-rule logic-table="smart_device_test_new" actual-data-nodes="smart_$->{0..1}.smart_device_test_new$->{0..1}" database-strategy-ref="databaseStrategy" table-strategy-ref="tableStrategy" />
            </sharding:table-rules>
        </sharding:sharding-rule>
    </sharding:data-source>

主从


    <master-slave:data-source id="masterSlaveDataSource" master-data-source-name="master"
                              slave-data-source-names="slave">
        <master-slave:props>
            <prop key="sql.show">false</prop>
            <prop key="executor.size">10</prop>
            <prop key="foo">bar</prop>
        </master-slave:props>
    </master-slave:data-source>