Iceberry-qdd commented on issue #35147:
URL:
https://github.com/apache/shardingsphere/issues/35147#issuecomment-2788843351
Previously I had a version without `READWRITE_SPLITTING` and it was working
fine.
### Version
Same as above.
### My needs
1. On `ds`, using `autoTables` rule, each `tb_product` table stores 1 month
of data, based on the rule below, it'll create `tb_product_0` ~ `tb_product_12`
automatically.
### My config
```yml
# Shardingsphere.yml
mode:
type: Standalone
repository:
type: JDBC
dataSources:
ds:
dataSourceClassName: com.zaxxer.hikari.HikariDataSource
driverClassName: com.mysql.cj.jdbc.Driver
jdbcUrl:
jdbc:mysql://localhost:3306/iceberry?serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=utf8
username: iceberry
password: iceberry
rules:
- !SHARDING
autoTables:
tb_product:
actualDataSources: ds
shardingStrategy:
standard:
shardingColumn: created_time
shardingAlgorithmName: auto_table_interval
keyGenerateStrategy:
column: id
keyGeneratorName: snowflake
auditStrategy:
auditorNames:
- sharding_key_required_auditor
allowHintDisable: true
shardingAlgorithms:
auto_table_interval:
type: AUTO_INTERVAL
props:
datetime-lower: "2025-04-08 00:00:00"
datetime-upper: "2026-04-08 00:00:00"
sharding-seconds: 2678400
auditors:
sharding_key_required_auditor:
type: DML_SHARDING_CONDITIONS
keyGenerators:
snowflake:
type: SNOWFLAKE
props:
sql-show: true
```
### My code
Same as above.
### Running Output:
<details>
<summary>The out is following (Click to expand):</summary>
```bash
Java HotSpot(TM) 64-Bit Server VM warning: Sharing is only supported for
boot loader classes because bootstrap classpath has been appended
2025-04-09T16:43:06.171+08:00 INFO 49448 --- [ShardingSphereDemo] [
main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting...
2025-04-09T16:43:06.722+08:00 INFO 49448 --- [ShardingSphereDemo] [
main] com.zaxxer.hikari.HikariDataSource : HikariPool-2 - Starting...
2025-04-09T16:43:06.988+08:00 INFO 49448 --- [ShardingSphereDemo] [
main] com.zaxxer.hikari.pool.HikariPool : HikariPool-2 - Added
connection conn0: url=jdbc:h2:mem:config user=SA
2025-04-09T16:43:06.990+08:00 INFO 49448 --- [ShardingSphereDemo] [
main] com.zaxxer.hikari.HikariDataSource : HikariPool-2 - Start
completed.
2025-04-09T16:43:07.046+08:00 INFO 49448 --- [ShardingSphereDemo] [
main] com.zaxxer.hikari.HikariDataSource : HikariPool-3 - Starting...
2025-04-09T16:43:07.212+08:00 INFO 49448 --- [ShardingSphereDemo] [
main] com.zaxxer.hikari.pool.HikariPool : HikariPool-3 - Added
connection com.mysql.cj.jdbc.ConnectionImpl@41b66d1
2025-04-09T16:43:07.212+08:00 INFO 49448 --- [ShardingSphereDemo] [
main] com.zaxxer.hikari.HikariDataSource : HikariPool-3 - Start
completed.
2025-04-09T16:43:08.036+08:00 INFO 49448 --- [ShardingSphereDemo] [
main] com.zaxxer.hikari.HikariDataSource : HikariPool-4 - Starting...
2025-04-09T16:43:08.052+08:00 INFO 49448 --- [ShardingSphereDemo] [
main] com.zaxxer.hikari.pool.HikariPool : HikariPool-4 - Added
connection com.mysql.cj.jdbc.ConnectionImpl@331ad6eb
2025-04-09T16:43:08.052+08:00 INFO 49448 --- [ShardingSphereDemo] [
main] com.zaxxer.hikari.HikariDataSource : HikariPool-4 - Start
completed.
2025-04-09T16:43:10.026+08:00 INFO 49448 --- [ShardingSphereDemo] [
main] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Added
connection
org.apache.shardingsphere.driver.jdbc.core.connection.ShardingSphereConnection@73c2d305
2025-04-09T16:43:10.026+08:00 INFO 49448 --- [ShardingSphereDemo] [
main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start
completed.
2025-04-09T16:43:10.925+08:00 INFO 49448 --- [ShardingSphereDemo] [
main] ShardingSphere-SQL : Logic SQL: CREATE TABLE
tb_product
(
id BIGINT NOT NULL PRIMARY KEY,
created_time DATETIME NOT NULL,
is_ordered TINYINT(1) DEFAULT 0 NOT NULL,
name VARCHAR(64) NULL
);
2025-04-09T16:43:10.926+08:00 INFO 49448 --- [ShardingSphereDemo] [
main] ShardingSphere-SQL : Actual SQL: ds_0 ::: CREATE
TABLE tb_product_0
(
id BIGINT NOT NULL PRIMARY KEY,
created_time DATETIME NOT NULL,
is_ordered TINYINT(1) DEFAULT 0 NOT NULL,
name VARCHAR(64) NULL
);
2025-04-09T16:43:10.926+08:00 INFO 49448 --- [ShardingSphereDemo] [
main] ShardingSphere-SQL : Actual SQL: ds_0 ::: CREATE
TABLE tb_product_1
(
id BIGINT NOT NULL PRIMARY KEY,
created_time DATETIME NOT NULL,
is_ordered TINYINT(1) DEFAULT 0 NOT NULL,
name VARCHAR(64) NULL
);
2025-04-09T16:43:10.926+08:00 INFO 49448 --- [ShardingSphereDemo] [
main] ShardingSphere-SQL : Actual SQL: ds_0 ::: CREATE
TABLE tb_product_2
(
id BIGINT NOT NULL PRIMARY KEY,
created_time DATETIME NOT NULL,
is_ordered TINYINT(1) DEFAULT 0 NOT NULL,
name VARCHAR(64) NULL
);
2025-04-09T16:43:10.927+08:00 INFO 49448 --- [ShardingSphereDemo] [
main] ShardingSphere-SQL : Actual SQL: ds_0 ::: CREATE
TABLE tb_product_3
(
id BIGINT NOT NULL PRIMARY KEY,
created_time DATETIME NOT NULL,
is_ordered TINYINT(1) DEFAULT 0 NOT NULL,
name VARCHAR(64) NULL
);
2025-04-09T16:43:10.927+08:00 INFO 49448 --- [ShardingSphereDemo] [
main] ShardingSphere-SQL : Actual SQL: ds_0 ::: CREATE
TABLE tb_product_4
(
id BIGINT NOT NULL PRIMARY KEY,
created_time DATETIME NOT NULL,
is_ordered TINYINT(1) DEFAULT 0 NOT NULL,
name VARCHAR(64) NULL
);
2025-04-09T16:43:10.927+08:00 INFO 49448 --- [ShardingSphereDemo] [
main] ShardingSphere-SQL : Actual SQL: ds_0 ::: CREATE
TABLE tb_product_5
(
id BIGINT NOT NULL PRIMARY KEY,
created_time DATETIME NOT NULL,
is_ordered TINYINT(1) DEFAULT 0 NOT NULL,
name VARCHAR(64) NULL
);
2025-04-09T16:43:10.928+08:00 INFO 49448 --- [ShardingSphereDemo] [
main] ShardingSphere-SQL : Actual SQL: ds_0 ::: CREATE
TABLE tb_product_6
(
id BIGINT NOT NULL PRIMARY KEY,
created_time DATETIME NOT NULL,
is_ordered TINYINT(1) DEFAULT 0 NOT NULL,
name VARCHAR(64) NULL
);
2025-04-09T16:43:10.929+08:00 INFO 49448 --- [ShardingSphereDemo] [
main] ShardingSphere-SQL : Actual SQL: ds_0 ::: CREATE
TABLE tb_product_7
(
id BIGINT NOT NULL PRIMARY KEY,
created_time DATETIME NOT NULL,
is_ordered TINYINT(1) DEFAULT 0 NOT NULL,
name VARCHAR(64) NULL
);
2025-04-09T16:43:10.930+08:00 INFO 49448 --- [ShardingSphereDemo] [
main] ShardingSphere-SQL : Actual SQL: ds_0 ::: CREATE
TABLE tb_product_8
(
id BIGINT NOT NULL PRIMARY KEY,
created_time DATETIME NOT NULL,
is_ordered TINYINT(1) DEFAULT 0 NOT NULL,
name VARCHAR(64) NULL
);
2025-04-09T16:43:10.930+08:00 INFO 49448 --- [ShardingSphereDemo] [
main] ShardingSphere-SQL : Actual SQL: ds_0 ::: CREATE
TABLE tb_product_9
(
id BIGINT NOT NULL PRIMARY KEY,
created_time DATETIME NOT NULL,
is_ordered TINYINT(1) DEFAULT 0 NOT NULL,
name VARCHAR(64) NULL
);
2025-04-09T16:43:10.930+08:00 INFO 49448 --- [ShardingSphereDemo] [
main] ShardingSphere-SQL : Actual SQL: ds_0 ::: CREATE
TABLE tb_product_10
(
id BIGINT NOT NULL PRIMARY KEY,
created_time DATETIME NOT NULL,
is_ordered TINYINT(1) DEFAULT 0 NOT NULL,
name VARCHAR(64) NULL
);
2025-04-09T16:43:10.930+08:00 INFO 49448 --- [ShardingSphereDemo] [
main] ShardingSphere-SQL : Actual SQL: ds_0 ::: CREATE
TABLE tb_product_11
(
id BIGINT NOT NULL PRIMARY KEY,
created_time DATETIME NOT NULL,
is_ordered TINYINT(1) DEFAULT 0 NOT NULL,
name VARCHAR(64) NULL
);
2025-04-09T16:43:10.930+08:00 INFO 49448 --- [ShardingSphereDemo] [
main] ShardingSphere-SQL : Actual SQL: ds_0 ::: CREATE
TABLE tb_product_12
(
id BIGINT NOT NULL PRIMARY KEY,
created_time DATETIME NOT NULL,
is_ordered TINYINT(1) DEFAULT 0 NOT NULL,
name VARCHAR(64) NULL
);
```
</details>
### My Database
--
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.
To unsubscribe, e-mail: notifications-unsubscr...@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
