wsg96321 commented on issue #15411: URL: https://github.com/apache/shardingsphere/issues/15411#issuecomment-1039967837
> Hi @wsg96321 The option to consider is: Upgrade to 5.0.0 and use DistSQL to dynamically add datasources to avoid restarts. > > Ref: https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/resource-definition/ thanks a lot ,I have a try to do it just now. But it still has the same problem althouth it doesn't restart. It costs almost time (50 datasource cost about 5 minutes, I just have a test so it is not all database and table ).Then when I add an datasource (other machine room like Europe), the log show it will flush all datasource (about 50+) , So I also have to wait for all datasource reflush for a long time , and then I can read the data in new datasource. Fortunately, I can query other datasource when it is reflushing. Is there a better idea to resolve it ? -- 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]
