Support the database to use forced routing, and the data table to use the column to divide the table?

[lanrenbulan]

Hi,

I am doing saas, one database per customer, but the table needs to be split.

Support the database to use forced routing, and the data table to use the column to divide the table?

schemaName: sql_hint
#
dataSources:
  ds_0:
    url: jdbc:mysql://localhost:3306/demo_ds_0
    username: root
    password: root
    connectionTimeoutMilliseconds: 30000
    idleTimeoutMilliseconds: 60000
    maxLifetimeMilliseconds: 1800000
    maxPoolSize: 50
    minPoolSize: 1
  ds_1:
    url: jdbc:mysql://localhost:3306/demo_ds_1
    username: root
    password: root
    connectionTimeoutMilliseconds: 30000
    idleTimeoutMilliseconds: 60000
    maxLifetimeMilliseconds: 1800000
    maxPoolSize: 50
    minPoolSize: 1
  ds_2:
    url: jdbc:mysql://localhost:3306/demo_ds_2
    username: root
    password: root
    connectionTimeoutMilliseconds: 30000
    idleTimeoutMilliseconds: 60000
    maxLifetimeMilliseconds: 1800000
    maxPoolSize: 50
    minPoolSize: 1
#
rules:
- !SHARDING
  tables:
    t_order:
      actualDataNodes: ds_${0..2}.t_order_${0..1}
      tableStrategy:
        standard:
          shardingColumn: user_id
          shardingAlgorithmName: table_inline

  defaultDatabaseStrategy:
    none:
  defaultTableStrategy:
    none:

  shardingAlgorithms:
    table_inline:
      type: INLINE
      props:
        algorithm-expression: t_order_${user_id % 2}

<?php

$dsn = 'mysql:dbname=sql_hint;host=127.0.0.1;port=3308';
$user = 'root';
$password = 'root';
try {
    $pdo = new PDO($dsn, $user, $password);

    // SQL解析
    $sql = '/* ShardingSphere hint: dataSourceName=ds_1 */';
    $sql .= 'insert into t_order(user_id) values (11)';
    $pdo->exec($sql);
    var_dump($pdo->errorInfo());
} catch (PDOException $e) {
    echo 'Connection failed: ' . $e->getMessage();
}

The configuration and code I wrote did not achieve the results I wanted