Simbafa commented on issue #8903:
URL: https://github.com/apache/shardingsphere/issues/8903#issuecomment-769500810
config-sharding.yaml
```
13 # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or
implied.
14 # See the License for the specific language governing permissions and
15 # limitations under the License.
16 #
17
18
######################################################################################################
19 #
20 # Here you can configure the rules for the proxy.
21 # This example is configuration of sharding rule.
22 #
23
######################################################################################################
24 #
25 schemaName: test
26 #
27 dataSourceCommon:
28 username: root
29 password: test
30 connectionTimeoutMilliseconds: 30000
31 idleTimeoutMilliseconds: 60000
32 maxLifetimeMilliseconds: 1800000
33 maxPoolSize: 50
34 minPoolSize: 1
35 maintenanceIntervalMilliseconds: 30000
36
37 dataSources:
38 ds_0:
39 url:
jdbc:mysql://192.168.1.46:3306/test?serverTimezone=UTC&useSSL=false
40 # url:
jdbc:postgresql://127.0.0.1:5432/demo_ds_0?serverTimezone=UTC&useSSL=false
41 # ds_1:
42 # url:
jdbc:postgresql://127.0.0.1:5432/demo_ds_1?serverTimezone=UTC&useSSL=false
43 #
44 rules:
45 - !SHARDING
46 tables:
47 t_order:
48 actualDataNodes: ds_${0}.t_order_${0}
49 tableStrategy:
50 standard:
51 shardingColumn: order_id
52 shardingAlgorithmName: t_order_inline
53 # keyGenerateStrategy:
54 # column: order_id
55 # keyGeneratorName: snowflake
56 # t_order_item:
57 # actualDataNodes: ds_${0..1}.t_order_item_${0..1}
58 # tableStrategy:
```
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
