ShardingSphere-proxy-5.0.0分布式哈希取模分片实现(四)

tmchongye

已于 2022-06-22 05:20:54 修改

阅读量646

点赞数

文章标签：分布式哈希算法数据库

于 2022-06-22 05:17:40 首次发布

本文链接：https://blog.csdn.net/tmchongye/article/details/125401882

版权

本文详细介绍了如何使用ShardingSphere-proxy 5.0.0对字符串字段进行哈希取模分片。通过修改`config-sharding.yaml`配置文件并重启服务，实现了数据的分布式存储。实验中，数据被有效分片到`t_product_0`和`t_product_1`表中，展示了ShardingSphere的数据库分片能力。

摘要由CSDN通过智能技术生成

一、说明

主要是对字符串的字段进行hash取模

二、修改配置文件config-sharding.yaml，并重启服务

#
# Licensed to the Apache Software Foundation (ASF) under one or more
# contributor license agreements.  See the NOTICE file distributed with
# this work for additional information regarding copyright ownership.
# The ASF licenses this file to You under the Apache License, Version 2.0
# (the "License"); you may not use this file except in compliance with
# the License.  You may obtain a copy of the License at
#
#     http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
#

######################################################################################################
# 
# Here you can configure the rules for the proxy.
# This example is configuration of sharding rule.
# 
######################################################################################################
#
#schemaName: sharding_db
#
#dataSources:
#  ds_0:
#    url: jdbc:postgresql://127.0.0.1:5432/demo_ds_0
#    username: postgres
#    password: postgres
#    connectionTimeoutMilliseconds: 30000
#    idleTimeoutMilliseconds: 60000
#    maxLifetimeMilliseconds: 1800000
#    maxPoolSize: 5