When sharding proxy and SQL hint are used for database splitting, does the read-write separation configuration not take effect？

[ykjxx]

problem：When sharding proxy and SQL hint are used for database splitting, does the read-write separation configuration not take effect？ environment：shardingproxy-5.1.2,mysql5.7 What should I do if I want to use hint and read / write split config at the same time?

[RaigorJiang]

Hi @ykjxx Please describe your configuration and operation, what is the expectation and what is the actual performance? So that someone can help you analyze the cause of the problem.

It is best to use the issue template to ask questions.

[ykjxx]

Hi @RaigorJiang my config:

[db1, replica1] and [DB2, replica2] are two groups of master-slave Databases. I hope to route these two groups of Databases through Hin SQL and realize read-write separation excute-sql: /* ShardingSphere hint: dataSourceName=db_2 */ select * from sm_project_img; expect： It is expected that the above SQL execute on the slave dabatase(replica_2)

actual: this sql execute on the master database(db_2)

In this case，If I use distsql to set hint value, the READWRITE_SPLITTING-strategy can take effect； for example：Execute first ”set sharding hint database_value=db_2", then execute "select * from XX"，The query statement is executed from the slave database(replica_2), However, this distsql cannot guarantee thread safety in the multithreading environment of the same application，Is there a two pronged approach?

[RaigorJiang]

Two risks:

1. Your readwrite-splitting group names and the original resource names are duplicated, which may lead to deviation
2. The way of SQL HINT to dataSourceName has been removed from the master, so it is best not to use it, otherwise the subsequent upgrade will not be possible.

[github-actions[bot]]

Hello , this issue has not received a reply for several days. This issue is supposed to be closed.

[RaigorJiang]

Closed due to no reply for a long time.