Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
  • 20:47
    IgorFedchenko commented #4085
  • 20:46
    IgorFedchenko commented #4085
  • 15:09
    IgorFedchenko commented #4085
  • 11:24
    Kenji-Tanaka commented #3887
  • 10:45
    nagytech edited #4086
  • 10:45
    nagytech synchronize #4086
  • 10:43
    nagytech opened #4086
  • 09:00
    Horusiath commented #4077
  • 06:31
    Aaronontheweb commented #4085
  • 06:28
    Aaronontheweb commented #4085
  • 06:24
    Aaronontheweb commented #4085
  • Dec 07 11:49
    IgorFedchenko commented #4085
  • Dec 07 10:31
    IgorFedchenko commented #4085
  • Dec 07 08:36
    IgorFedchenko commented #4085
  • Dec 06 20:57
    IgorFedchenko commented #4085
  • Dec 06 20:32
    IgorFedchenko commented #4085
  • Dec 06 20:01
    IgorFedchenko commented #4085
  • Dec 06 19:55
    IgorFedchenko commented #4085
  • Dec 06 16:22
    Aaronontheweb labeled #3997
  • Dec 06 16:22
    Aaronontheweb closed #3997
Joshua Garnett
@joshgarnett
@alexvaluyskiy I think I see the issue, they are only including a dll for 452, my guess is if you up the project version to that it’ll work
Alex Valuyskiy
@alexvaluyskiy
mysql.data.6.10.3-rc contains a dll for net452 and for netstandard1.3
The problem is - netstandard one works fine, but net452 - not
Joshua Garnett
@joshgarnett
hmm you are right
weird
Alex Valuyskiy
@alexvaluyskiy
MySql.Data 6.9.9 works fine, but it does not support Net Standard
Joshua Garnett
@joshgarnett
it supports .netstandard1.3
Akka.net is 1.6, right?
Alex Valuyskiy
@alexvaluyskiy
MySql.Data 6.9.9 - support only net45
MySql.Data 6.10.3-rc, MySql.Data 8.0.8-dmr - support both .NET 4.5.2 and .NET Standard 1.3, but does not work
Joshua Garnett
@joshgarnett
Interesting, so I just pulled down your changes and was able to run the tests without any problems
This is within an editor though
Nick Chamberlain
@heynickc
@alfredherr sorry for the late response, but this PR on the dev branch of Lighthouse has a .NET Core compatible version as a separate project petabridge/lighthouse#37
Boban
@bobanco
anyone using cluster sharding and mysql persistence with 1.3.1 version?
Joshua Garnett
@joshgarnett
Yes
You need to be using the latest mysql persistence changes from the dev branch there, the nuget package hasn’t been updated yet
Boban
@bobanco
@joshgarnett thanks :+1:
Boban
@bobanco
@Horusiath i did some performance testing on cluster sharding with mysql as a persistence , the performance which i got was 312.5 entities per sec
Bartosz Sypytkowski
@Horusiath
@bobanco what and how you were testing? Mind to send a sample?
Boban
@bobanco
my dev machine specs:
CPU: i7 4790k
RAM: 16GB
SSD: 250 GB Samsung
basicly i was trying to see the performance of how many entities we can allocate per second
and also each entity is persistent and persists its state
Bartosz Sypytkowski
@Horusiath
but entities with remember-entities=on? all entities in one shard or maybe one entity for each shard?
Boban
@bobanco
mb this is not the true performance testing of the sharding itself
Bartosz Sypytkowski
@Horusiath
without batching, event journals are still pretty slow
Boban
@bobanco
hm does batching helps even if each persistent entity is unique?
Bartosz Sypytkowski
@Horusiath
especially then - batching is applicable, when many persistent entities are trying to persist their events at the same time
Boban
@bobanco
hm..how i can use batcing journal? or there is not ready one?
Bartosz Sypytkowski
@Horusiath
i've tested it on sqlite, sqlserver and postgres on various settings - using current defaults, I was getting around 400-700 events/sec (simply limits of full connection rountrips on ADO.NET), with batching journal - 8000-12000 events/sec
it's part of shared persistence sql lib, but it needs implementation per each concrete provider
Boban
@bobanco
does postgres has implemented it?
i mean the postgres persistence implementation
Bartosz Sypytkowski
@Horusiath
there was PR (not merged) made long ago ;) It needs to be updated
AkkaNetContrib/Akka.Persistence.PostgreSql#32
this is the PR
console app for stress tests is attached
Boban
@bobanco
will take a look
with jvm lagom framework whihc under the hood is using akka sharding and persistence i was getting troughput > 3k
same workload
Bartosz Sypytkowski
@Horusiath
lagom with cassandra?
Boban
@bobanco
oh yes
i forgot abt the cassandra
Bartosz Sypytkowski
@Horusiath
their cassandra plugin also implements some sort of request batching
Boban
@bobanco
any idea when postgres PR will get merged?
if i can get better troughput mb i can avoid convincing my team and also myself to use jvm for this microservice, cuz entire ecosystem is running on .net
and akka.net
i also made prototype on a top of orleans, it was even worse the mysql storage provider was falling :smile:
Bartosz Sypytkowski
@Horusiath
I guess mysql is not a top used storage in .net - probably most of the implementations in all libraries will end up pretty buggy
Boban
@bobanco
i can switch to postgres or cassandra
if i can avoid this issue