wsg96321 edited a comment on issue #15727:
URL: 
https://github.com/apache/shardingsphere/issues/15727#issuecomment-1056115813


   Maybe it is a good idea for this Exception to deal like "mysql connection 
refuse " ? We use this in game's mysql meta data, so I think it is normal for 
game to "start a new server " or "merge two server " or "close a old server ". 
In this case , I have to often to `ADD RESROUCE` and `DROP RESOURCE` , and then 
execute SQL `ALTER SHARDING TABLE RULE xxxx` for every table like 
`hero/vip/user/account` and so on .  Besides, every time when I execute `ADD 
RESOURCE` will cost about 3 mins for one time(just in commad tell me success, 
it really can use maybe need 11 mins [It maybe flush connection in backgroud] ) 
and  `ALTER SHARDING TABLE RULE xxxx` cost about 4mins for one table  , so I 
even can't not flush all data in an hour. 


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


Reply via email to