liusf1993 commented on issue #3211: Statement "SELECT GET_LOCK('lock10086')"
doesn't work as expected
URL:
https://github.com/apache/incubator-shardingsphere/issues/3211#issuecomment-541275875
> What is your expected action to using lock in a sharding databases? just
lock all of the table?
>
> Using lock with ShardingSphere is not a good practice, because
ShardingSphere on Sharding is for horizontal split. If you want use distribute
lock, maybe you can try zookeeper.
I'm integrating Shardingsphere into an old application. The lock is worked
in another dependent jar related to db, and it's just a distributed lock for
intializing. To keep the jar pure, we don't want to introduce another jar like
zookeeper or redis for a distribute lock in the jar at moment. Keeping the
lock and release work on the same database is just ok for us at moment.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
[email protected]
With regards,
Apache Git Services
