Repository navigation
Is there a schedule to support MySQL? #95
Description
Thank you for the great library! Do you consider to support MySQL? It does support locking features https://dev.mysql.com/doc/refman/5.7/en/locking-functions.html to implement distributed locking on top of it.
Thanks in advance.
Rustam
Activity
theplacefordev commentedon Jun 25, 2021
#24
madelson commentedon Jun 25, 2021
@theplacefordev I'd be open to adding this; seems straightforward. Would you be willing to test out a prerelease package and confirm that it is functioning as expected?
theplacefordev commentedon Jul 8, 2021
@madelson yes, of course. Thanks in advance!
madelson commentedon Jul 23, 2021
@theplacefordev as I've started working on this I noticed that there seem to be 2 popular drivers: https://www.nuget.org/packages/MySql.Data/ and https://www.nuget.org/packages/MySqlConnector/.
I'm curious which of these you have experience with and whether you think one or the other seems like a better default?
madelson commentedon Jul 28, 2021
Actually, seems like we'll have to use MySqlConnector as the default because it has better license terms.
theplacefordev commentedon Aug 24, 2021
@madelson I use it with EF Core and Pomelo.EntityFrameworkCore.MySql provider which is using MySqlConnector, so it works for me
madelson commentedon Aug 24, 2021
Thanks @theplacefordev ! I am close to having an alpha package out.
Implement MySql distributed lock (fix #95)
madelson commentedon Aug 25, 2021
@theplacefordev I've published a release candidate version: https://www.nuget.org/packages/DistributedLock.MySql/1.0.0-rc01
Would you mind giving it a try and confirming that it works for you?
theplacefordev commentedon Aug 29, 2021
@madelson sure I will try it tomorrow. Thanks a lot!
bgrainger commentedon Sep 4, 2021
FYI, MySqlConnector is the only MySQL ADO.NET library that supports asynchronous operations; all "Async" methods in MySql.Data operate synchronously: https://bugs.mysql.com/bug.php?id=70111.
madelson commentedon Sep 9, 2021
@theplacefordev not rush but did you get a chance to try this library?
theplacefordev commentedon Sep 23, 2021
@madelson Sorry for the delay. I've tested it on my laptop with MySql 5.7, .NET Core 3.1, EF 5, and MySqlConnector 1.3.11 - it seems to works for my test cases. Thank you!
madelson commentedon Sep 26, 2021
Thanks! I'll get a stable version merged soon! Re-opening for now to remind me.