apache
After restarting ShardingSphere-Proxy 5.5, previously created tables cannot be viewed.
Environment: ShardingSphere-Proxy: 5.5/5.4.1 MySQL: 8.0.20 Docker Issue: After creating a table using ShardingSphere-Proxy, upon restarting the proxy container, the previously created table cannot be queried in the proxy.
@liangjiajie-hub You may need to use cluster mode (with zookeeper) to persist the meta data.
@liangjiajie-hub You may need to use cluster mode (with zookeeper) to persist the meta data.
Why can't standalone mode be used?
@liangjiajie-hub The standalone mode is only suitable for local development and testing, not for a production environment.
@liangjiajie-hub The standalone mode is only suitable for local development and testing, not for a production environment.
I discovered this issue while testing in standalone mode, so I am unable to complete the setup for the testing environment.
Here is my configuration: "mode: type: Standalone repository: type: JDBC props: provider: H2 jdbc_url: jdbc:h2:mem:config;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL username: test password: Test@123"
@liangjiajie-hub You may need to use cluster mode (with zookeeper) to persist the meta data.
The 5.3.2 version has been tested and does not have this issue.