1. Start the MySQL service;
  2. Create role and user in MySQL with creation permission for ShardingSphere-Proxy;
  3. Start Zookeeper service;
  4. Add and authentication configurations to server.yaml;
  5. Start ShardingSphere-Proxy;
  6. Use SDK or terminal connect to ShardingSphere-Proxy.
  1. Use newly created logic database
  1. Currently, DROP DATABASE will only remove the logical distributed database, not the user’s actual database;
  2. will delete all logical fragmented tables and actual tables in the database;
  3. CREATE DATABASE will only create a logical distributed database, so users need to create actual databases in advance.