You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2019/09/03 06:45:24 UTC
[GitHub] [incubator-shardingsphere] M-make opened a new issue #2964: Can I
configure multiple schemas?
M-make opened a new issue #2964: Can I configure multiple schemas?
URL: https://github.com/apache/incubator-shardingsphere/issues/2964
#### tool
Sharding-proxy
#### version
4.0.0-SR2
#### question
` Can I configure multiple schemas?`
> I tried to configure the schema in multiple yml files, but it doesn't seem to work.
> I observed the log, just loaded the contents of config-shard1.yaml
#### config-shard1.yaml
```yml
schemaName: z9
dataSources:
ds_0:
url: jdbc:mysql://132.232.39.227:3306/test?serverTimezone=UTC&useSSL=false
username: root
password: 88888888
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
ds_1:
url: jdbc:mysql://132.232.39.227:3307/test?serverTimezone=UTC&useSSL=false
username: root
password: 88888888
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
```
#### config-shard2.yaml
```yml
schemaName: sharding_db
dataSources:
dd01:
url: jdbc:mysql://132.232.39.227:3306/test?serverTimezone=UTC&useSSL=false
username: root
password: 88888888
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
```
#### log
```log
[INFO ] 14:36:05.269 [main] com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting...
[INFO ] 14:36:05.922 [main] com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Start completed.
[INFO ] 14:36:05.922 [main] com.zaxxer.hikari.HikariDataSource - HikariPool-2 - Starting...
[INFO ] 14:36:06.284 [main] com.zaxxer.hikari.HikariDataSource - HikariPool-2 - Start completed.
[INFO ] 14:36:06.324 [main] c.a.icatch.provider.imp.AssemblerImp - Loaded jar:file:/Users/huqingfeng/Documents/Middleware/apache-shardingsphere-incubating-4.0.0-RC2-sharding-proxy-bin/lib/transactions-4.0.6.jar!/transactions-defaults.properties
[INFO ] 14:36:06.325 [main] c.a.icatch.provider.imp.AssemblerImp - Loaded jar:file:/Users/huqingfeng/Documents/Middleware/apache-shardingsphere-incubating-4.0.0-RC2-sharding-proxy-bin/lib/sharding-transaction-xa-atomikos-manager-4.0.0-RC2.jar!/jta.properties
[WARN ] 14:36:11.334 [main] c.a.icatch.provider.imp.AssemblerImp - Thanks for using Atomikos! Evaluate http://www.atomikos.com/Main/ExtremeTransactions for advanced features and professional support
or register at http://www.atomikos.com/Main/RegisterYourDownload to disable this message and receive FREE tips & advice
Thanks for using Atomikos! Evaluate http://www.atomikos.com/Main/ExtremeTransactions for advanced features and professional support
or register at http://www.atomikos.com/Main/RegisterYourDownload to disable this message and receive FREE tips & advice
[INFO ] 14:36:11.350 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.default_max_wait_time_on_shutdown = 9223372036854775807
[INFO ] 14:36:11.350 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.allow_subtransactions = true
[INFO ] 14:36:11.350 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.recovery_delay = 300000
[INFO ] 14:36:11.350 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.automatic_resource_registration = false
[INFO ] 14:36:11.350 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.oltp_max_retries = 5
[INFO ] 14:36:11.350 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.client_demarcation = false
[INFO ] 14:36:11.350 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.threaded_2pc = false
[INFO ] 14:36:11.350 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.serial_jta_transactions = false
[INFO ] 14:36:11.350 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.log_base_dir = ./logs
[INFO ] 14:36:11.350 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.rmi_export_class = none
[INFO ] 14:36:11.350 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.max_actives = 10000
[INFO ] 14:36:11.351 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.checkpoint_interval = 50000
[INFO ] 14:36:11.351 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.enable_logging = true
[INFO ] 14:36:11.351 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.log_base_name = xa_tx
[INFO ] 14:36:11.351 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.max_timeout = 300000
[INFO ] 14:36:11.351 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.trust_client_tm = false
[INFO ] 14:36:11.351 [main] c.a.icatch.provider.imp.AssemblerImp - USING: java.naming.factory.initial = com.sun.jndi.rmi.registry.RegistryContextFactory
[INFO ] 14:36:11.351 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.tm_unique_name = 10.2.104.75.tm
[INFO ] 14:36:11.351 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.forget_orphaned_log_entries_delay = 86400000
[INFO ] 14:36:11.351 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.oltp_retry_interval = 10000
[INFO ] 14:36:11.351 [main] c.a.icatch.provider.imp.AssemblerImp - USING: java.naming.provider.url = rmi://localhost:1099
[INFO ] 14:36:11.351 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.force_shutdown_on_vm_exit = false
[INFO ] 14:36:11.351 [main] c.a.icatch.provider.imp.AssemblerImp - USING: com.atomikos.icatch.default_jta_timeout = 300000
[INFO ] 14:36:11.357 [main] c.a.icatch.provider.imp.AssemblerImp - Using default (local) logging and recovery...
[INFO ] 14:36:11.674 [main] c.a.d.xa.XATransactionalResource - resource-1-ds_0: refreshed XAResource
[INFO ] 14:36:11.987 [main] c.a.d.xa.XATransactionalResource - resource-2-ds_1: refreshed XAResource
[INFO ] 14:36:17.213 [nioEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0xd24daafc] REGISTERED
[INFO ] 14:36:17.214 [nioEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0xd24daafc] BIND: 0.0.0.0/0.0.0.0:3307
[INFO ] 14:36:17.218 [nioEventLoopGroup-2-1] i.n.handler.logging.LoggingHandler - [id: 0xd24daafc, L:/0.0.0.0:3307] ACTIVE
```
----------------------------------------------------------------
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:
users@infra.apache.org
With regards,
Apache Git Services