Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
  • Dec 11 23:52
    scptre commented #4082
  • Dec 11 14:26
    nagytech commented #3954
  • Dec 11 11:18
    nagytech edited #4089
  • Dec 11 11:17
    nagytech opened #4089
  • Dec 11 11:00
    nagytech commented #4083
  • Dec 11 08:34
    jiyeongj commented #4083
  • Dec 11 08:33
    jiyeongj commented #4083
  • Dec 11 08:33
    jiyeongj commented #4083
  • Dec 11 07:57

    dependabot-preview[bot] on nuget

    (compare)

  • Dec 11 07:57

    dependabot-preview[bot] on dev

    Bump MongoDB.Driver from 2.9.1 … (compare)

  • Dec 11 07:57
    dependabot-preview[bot] closed #104
  • Dec 11 07:52
    dependabot-preview[bot] synchronize #104
  • Dec 11 07:52

    dependabot-preview[bot] on nuget

    Bump MongoDB.Driver from 2.9.1 … (compare)

  • Dec 11 07:52
    dependabot-preview[bot] edited #104
  • Dec 11 07:51
    dependabot-preview[bot] edited #104
  • Dec 11 07:51
    dependabot-preview[bot] edited #104
  • Dec 11 07:51
    Aaronontheweb commented #104
  • Dec 11 07:43

    dependabot-preview[bot] on nuget

    (compare)

  • Dec 11 07:43

    dependabot-preview[bot] on dev

    Bump Microsoft.NET.Test.Sdk fro… (compare)

  • Dec 11 07:43
    dependabot-preview[bot] closed #102
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
sharding together with persistence will give awesome scalability, only need now to find the right persistence :)
@Horusiath SqlServer persistence has implemented this batching journal right? can i use it in 1.3.1?
Bartosz Sypytkowski
@Horusiath
@bobanco not yet - I'm updating a related PR right now
I hope I'll made it in time before 1.3.1 release
Boban
@bobanco
@Horusiath thank you man
Bartosz Sypytkowski
@Horusiath
also if it's an option for you, you may want to use redis, even just for sharding-related data
@alexvaluyskiy put some work there
Joshua Garnett
@joshgarnett
@bobanco if it helps I’m going to be launching a game with Akka.Net + MySQL, so will likely be contributing improvements to that plugin. On a previous game we were using the JVM Akka + MySQL (Aurora to be specific) and targetting 50K/journals per second. With db sharding in place we were close to hitting that target