roodkcab commented on issue #14472: URL: https://github.com/apache/shardingsphere/issues/14472#issuecomment-1005514573
> Hi @roodkcab, we have provide [sql hint](https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/special-api/sharding/hint/#%E4%BD%BF%E7%94%A8-hint-%E8%B7%AF%E7%94%B1%E8%87%B3%E6%8C%87%E5%AE%9A%E6%95%B0%E6%8D%AE%E5%BA%93) in the master branch, I think you can try it. SQL hint can implement primary dataSource routing through comments in sql. > > ```sql > /* ShardingSphere hint: writeRouteOnly=true */ > SELECT * FROM t_order; > ``` yes, I know. and we have distsql to change session based hint too. the need is to use hint by dsn, i.e. use host, port or username to set hint automatically. -- 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]
