[GitHub] [shardingsphere] tuichenchuxin commented on issue #15532: Using Add Resource causes loss of broadcast tables under the /metadata/schemaName/tables

[GitBox <gi...@apache.org>]

tuichenchuxin commented on issue #15532:
URL: https://github.com/apache/shardingsphere/issues/15532#issuecomment-1082559644


   I tried these steps, but didn't reproduced.
   ## FIREST 
   server.ymal
   ```
   mode:
     type: Cluster
     repository:
       type: ZooKeeper
       props:
         namespace: agent
         server-lists: localhost:2181
         retryIntervalMilliseconds: 500
         timeToLiveSeconds: 60
         maxRetries: 3
         operationTimeoutMilliseconds: 30000
     overwrite: true
   #
   rules:
     - !AUTHORITY
       users:
         - root@%:root
         - sharding@:sharding
       provider:
         type: ALL_PRIVILEGES_PERMITTED
   
   props:
     max-connections-size-per-query: 1
     executor-size: 16  # Infinite by default.
     proxy-frontend-flush-threshold: 128  # The default value is 128.
     proxy-opentracing-enabled: false
     proxy-hint-enabled: true
     sql-show: false
     check-table-metadata-enabled: false
     lock-wait-timeout-milliseconds: 50000 # The maximum time to wait for a lock
     show-process-list-enabled: true
     # Proxy backend query fetch size. A larger value may increase the memory usage of ShardingSphere Proxy.
     # The default value is -1, which means set the minimum value for different JDBC drivers.
     proxy-backend-query-fetch-size: -1
     check-duplicate-table-enabled: false
   ```
   ## Second
   ```
   CREATE DATABASE sharding_db;
   ```
   ## Third
   ```
   ADD RESOURCE demo_ds_0 (
       HOST=127.0.0.1,
       PORT=3306,
       DB=demo_ds_0,
       USER=root,
       PASSWORD=123456
   ), demo_ds_1(
       HOST=127.0.0.1,
       PORT=3306,
       DB=demo_ds_0,
       USER=root,
       PASSWORD=123456
   );
   ```
   ## Fourth
   ```
   CREATE SHARDING BROADCAST TABLE RULES (t_config);
   ```
   ## final
   I found broadcast tables are exist.
   ![image](https://user-images.githubusercontent.com/86938616/160739900-79eda776-bce3-4ad9-8037-68916f95b1f1.png)
   


-- 
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-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org