You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/10/10 06:33:02 UTC
[GitHub] [shardingsphere] ykjxx opened a new issue, #20019: When sharding proxy and SQL hint are used for database splitting, does the read-write separation configuration not take effect?
ykjxx opened a new issue, #20019:
URL: https://github.com/apache/shardingsphere/issues/20019
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?
--
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: notifications-unsubscribe@shardingsphere.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang closed issue #20019: When sharding proxy and SQL hint are used for database splitting, does the read-write separation configuration not take effect?
Posted by GitBox <gi...@apache.org>.
RaigorJiang closed issue #20019: When sharding proxy and SQL hint are used for database splitting, does the read-write separation configuration not take effect?
URL: https://github.com/apache/shardingsphere/issues/20019
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #20019: When sharding proxy and SQL hint are used for database splitting, does the read-write separation configuration not take effect?
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #20019:
URL: https://github.com/apache/shardingsphere/issues/20019#issuecomment-1209374959
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.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] github-actions[bot] closed issue #20019: When sharding proxy and SQL hint are used for database splitting, does the read-write separation configuration not take effect?
Posted by GitBox <gi...@apache.org>.
github-actions[bot] closed issue #20019: When sharding proxy and SQL hint are used for database splitting, does the read-write separation configuration not take effect?
URL: https://github.com/apache/shardingsphere/issues/20019
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #20019: When sharding proxy and SQL hint are used for database splitting, does the read-write separation configuration not take effect?
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #20019:
URL: https://github.com/apache/shardingsphere/issues/20019#issuecomment-1210589563
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.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #20019: When sharding proxy and SQL hint are used for database splitting, does the read-write separation configuration not take effect?
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #20019:
URL: https://github.com/apache/shardingsphere/issues/20019#issuecomment-1278505109
Closed due to no reply for a long time.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] ykjxx commented on issue #20019: When sharding proxy and SQL hint are used for database splitting, does the read-write separation configuration not take effect?
Posted by GitBox <gi...@apache.org>.
ykjxx commented on issue #20019:
URL: https://github.com/apache/shardingsphere/issues/20019#issuecomment-1210064570
Hi @RaigorJiang
my config:
![image](https://user-images.githubusercontent.com/52477571/183792838-0b7e3988-986f-4579-96f8-1cc94593294e.png)
[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)
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] ykjxx closed issue #20019: When sharding proxy and SQL hint are used for database splitting, does the read-write separation configuration not take effect?
Posted by GitBox <gi...@apache.org>.
ykjxx closed issue #20019: When sharding proxy and SQL hint are used for database splitting, does the read-write separation configuration not take effect?
URL: https://github.com/apache/shardingsphere/issues/20019
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] github-actions[bot] commented on issue #20019: When sharding proxy and SQL hint are used for database splitting, does the read-write separation configuration not take effect?
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #20019:
URL: https://github.com/apache/shardingsphere/issues/20019#issuecomment-1272348987
Hello , this issue has not received a reply for several days.
This issue is supposed to be closed.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org