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: [email protected] With regards, Apache Git Services
