Hi,
I am trying out the ShardingSphere features. I have two questions on admin
related tasks. I tried different configurations but in vain. Very
appreciate for anyone could help.
1) How to configure the yaml files such that I can create tables on all
sharded databases through proxy?
- For example, I want to run "create table testing (test varchar(40))" on
proxy and create the table on all sharded databases.
- I tried defaultDataSourceName but the table was only created on that
database.
- I tried Master and Slave settings but I got "Cannot find table rule and
default data source..." error or couldn't start up ShardingSphere.
2) How to configure the yaml files such that normal user and admin can
login the proxy as different user accounts?
Without defaultDataSourceName and masterSlaveRules, my yaml file currently
looks like this:
schemaName: xxx_db
dataSources:
ds_0:
......
ds_1:
......
shardingRule:
tables:
table1:
......
table2:
......
defaultDatabaseStrategy:none:
defaultTableStrategy:none
Best Regards,
Eric Poon
