2.2 Yaml Configuration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 158 Authentication & Authorization . . . . . . . . . . . . . . . . . . . . . . . . . . . 158 Properties . . . capabilities on top of standalone databases, enabling data security across underlying data sources. Re ad /w ri te S pl it ti ng Read/write splitting can be used to cope with business access with high ShardingSphere provides a com‐ plete, transparent, secure, and low‐cost data encryption solution. Sh ad ow Da ta ba se In full‐link online load testing scenarios, ShardingSphere supports data isolation

2.2 Yaml Configuration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 176 Authentication & Authorization . . . . . . . . . . . . . . . . . . . . . . . . . . . 176 Properties . . . capabilities on top of standalone databases, enabling data security across underlying data sources. Re ad /w ri te S pl it ti ng Read/write splitting can be used to cope with business access with high ShardingSphere provides a com‐ plete, transparent, secure, and low‐cost data encryption solution. Sh ad ow Da ta ba se In full‐link online load testing scenarios, ShardingSphere supports data isolation

application enhancement capabili‐ ties through traffic deformation, redirection, governance, authentication, and analysis. 1.2.3 Pluggable: Building database function ecology The pluggable architecture prompt. You can use command‐line clients (mysql, psql, gsql, etc.) to connect to the Proxy’s authentication function. 2.2. ShardingSphere-Proxy 12 Apache ShardingSphere document, v5.2.1 2.2.3 Requirements source are offline, write data source whether the data source is responsible for read traffic lo ad‐balance‐a lgorithm‐ref A t t r i b u t e Load balance algorithm name

0 码力 | 523 页 | 4.51 MB | 1 年前

3

application enhancement capabili‐ ties through traffic deformation, redirection, governance, authentication, and analysis. 1.2. Design Philosophy 5 Apache ShardingSphere document, v5.2.0 1.2.3 Pluggable: prompt. You can use command‐line clients (mysql, psql, gsql, etc.) to connect to the Proxy’s authentication function. 2.2. ShardingSphere-Proxy 13 Apache ShardingSphere document, v5.2.0 2.2.3 Requirements source are offline, write data source whether the data source is responsible for read traffic lo ad‐balance‐a lgorithm‐ref A t t r i b u t e Load balance algorithm name

0 码力 | 483 页 | 4.27 MB | 1 年前

3

SET READ‐ WRITE_SPLITTING HINT SOURCE = [auto / write] 针对当前连接，设置读写分离的路由策 略（自动路由或强制到写库） SET RE AD‐ WRITE_SPLITTING HINT SOURCE = write SET SHARDING HINT DATABASE_VALUE = yy 针对当前连接，设置 hint 仅对数据库分 write_splitting 的 hint 设置 CLEAR RE AD‐ WRITE_SPLITTING HINT SHOW [SHARDING / READ‐ WRITE_SPLITTING] HINT STATUS 针对当前连接，查询 sharding 或 read‐ write_splitting 的 hint 设置 SHOW RE AD‐ WRITE_SPLITTING HINT STATUS 数据库； 3. 在 MySQL 中为 ShardingSphere‐Proxy 创建一个拥有创建权限的角色或者用户； 4. 启动 ZooKeeper 服务； 5. 添加 mode 和 authentication 配置参数到 server.yaml； 6. 启动 ShardingSphere‐Proxy； 7. 通过应用程序或终端连接到 ShardingSphere‐Proxy； 创建数据库

write_splitting 的 hint 设置 clear re ad‐ write_splitting hint show [sharding / r ead‐ write_splitting] hint status 针对当前连接，查询 sharding 或 read‐ write_splitting 的 hint 设置 show re ad‐ write_splitting hint status ShardingSphere‐Proxy 创建一个拥有创建权限的角色或者用户 4. 启动 Zookeeper 服务 (为了持久化配置) 启动 ShardingSphere-Proxy 1. 添加 mode 和 authentication 配置参数到 server.yaml (请参考相关 example 案例) 2. 启动 ShardingSphere‐Proxy (相关介绍) 创建分布式数据库和分片表 1. 连接到 ShardingProxy 创建一个拥有创建权限的角色或者用户 4. 启动 Zookeeper 服务 (为了持久化配置) 启动 ShardingProxy 1. 添加 mode 和 authentication 配置参数到 server.yaml (请参考相关 example 案例) 2. 启动 ShardingProxy (相关介绍) 创建分布式数据库和分片表 1. 连接到 ShardingProxy

SET READ‐ WRITE_SPLITTING HINT SOURCE = [auto / write] 针对当前连接，设置读写分离的路由策 略（自动路由或强制到写库） SET RE AD‐ WRITE_SPLITTING HINT SOURCE = write SET SHARDING HINT DATABASE_VALUE = yy 针对当前连接，设置 hint 仅对数据库分 write_splitting 的 hint 设置 CLEAR RE AD‐ WRITE_SPLITTING HINT SHOW [SHARDING / READ‐ WRITE_SPLITTING] HINT STATUS 针对当前连接，查询 sharding 或 read‐ write_splitting 的 hint 设置 SHOW RE AD‐ WRITE_SPLITTING HINT STATUS 数据库； 3. 在 MySQL 中为 ShardingSphere‐Proxy 创建一个拥有创建权限的角色或者用户； 4. 启动 ZooKeeper 服务； 5. 添加 mode 和 authentication 配置参数到 server.yaml； 6. 启动 ShardingSphere‐Proxy； 7. 通过应用程序或终端连接到 ShardingSphere‐Proxy； 创建数据库

https://shardingsphere.apache.org/document/current/en/user-manual/ shardingsphere-proxy/yaml-config/authentication/ ## @param compute.serverConfig.authority.privilege.type authority provider for storage node SET READ‐ WRITE_SPLITTING HINT SOURCE = [auto / write] 针对当前连接，设置读写分离的路由策 略（自动路由或强制到写库） SET RE AD‐ WRITE_SPLITTING HINT SOURCE = write SET SHARDING HINT DATABASE_VALUE = yy 针对当前连接，设置 hint 仅对数据库分 write_splitting 的 hint 设置 CLEAR RE AD‐ WRITE_SPLITTING HINT SHOW [SHARDING / R EAD‐ WRITE_SPLITTING] HINT STATUS 针对当前连接，查询 sharding 或 read‐ write_splitting 的 hint 设置 SHOW RE AD‐ WRITE_SPLITTING HINT STATUS

264 Data Source Configuration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 264 Authentication . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 265 Properties Configuration database sharding only, yy: sharding value sctl:hint set Database‐ Shar dingValue=100 sctl:hint ad dDatabaseSh ardingValue xx=yy For current connection, add sharding value for database, xx: logic columns: pad: cipherColumn: pad encryptorName: md5_encryptor 4.1.1 version server.yaml authentication: users: root: password: root sharding: password: sharding authorizedSchemas: sharding_db

206 Data Source Configuration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 206 Authentication . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 207 Properties Configuration bin/start.sh 3308. 2. ShardingSphere‐Proxy uses conf/server.yaml to configure the registry center, authentication information and public properties. 3. ShardingSphere‐Proxy supports multi‐logic data source Zookeeper service (for persistent configuration) Start ShardingSphere-Proxy 1. Add mode and authentication configurations to server.yaml (please refer to the example of ShardingSphere‐Proxy) 2. Start