#
# 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.
# 
######################################################################################################
dataSources:
  ds_0:
    dataSourceClassName: com.zaxxer.hikari.HikariDataSource
    driverClassName: org.opengauss.Driver
    jdbcUrl: jdbc:opengauss://20.20.20.54:14000/test?loggerLevel=OFF
    username: test
    password: Huawei@123
    connectionTimeout: 3600000
    maxLifetime: 70000
    maximumPoolSize: 510
    minimumIdle: 500
rules:
  bindingTables:
  - bmsql_warehouse, bmsql_customer
  - bmsql_stock, bmsql_district, bmsql_order_line
  defaultDatabaseStrategy:
    standard:
      shardingColumn: ds_id
      shardingAlgorithmName: database_inline
  defaultTableStrategy:
    none: null
  shardingAlgorithms:
    database_inline:
      props:
        algorithm-expression: ds_${ds_id % 1}
      type: INLINE
  tables:
    t_order:
      actualDataNodes: ds_${0..0}.t_order
#mode:
#  type: Cluster
#  repository:
#    type: ZooKeeper
#    props:
#      namespace: jdbc_ds
#      server-lists: 20.20.20.88:2181
#      retryIntervalMilliseconds: 500
#      timeToLiveSeconds: 60
#      maxRetries: 3
#      operationTimeoutMilliseconds: 500
#  overwrite: false

schemaName: sharding_db
props:
  max-connections-size-per-query: 1