https://www.prisma.io/ logo
Join Slack
Powered by
# orm-help
  • a

    Alan

    03/19/2020, 10:24 PM
    @Omar Nasr are you doing anything differently?
  • o

    Omar Nasr

    03/19/2020, 10:28 PM
    Ive honesty found kubernetes too complex for my use causes atm. Running Prisma behind a load balancer in Elastic Beanstalk on AWS and it's working pretty well and does not take too long to spin up new instances.
  • o

    Omar Nasr

    03/19/2020, 10:29 PM
    @Alan how are you scaling your DB along with prisma?
  • e

    Ethan Pursley

    03/19/2020, 11:49 PM
    @Alan @Omar Nasr I’m running 20 prisma-prod containers on ecs with database connections upped to 100 each, 2 cpus, 4gb ram, with an external rabbitmq server and every few minutes a few containers crash from subscriptions and respawn.
  • e

    Ethan Pursley

    03/19/2020, 11:49 PM
    We use subscriptions heavily, more than anything else.
  • a

    Alan

    03/20/2020, 12:09 AM
    are you using postgres @Ethan Pursley
  • e

    Ethan Pursley

    03/20/2020, 12:10 AM
    No, we are on mysql unfortunately
  • a

    Alan

    03/20/2020, 12:10 AM
    how are you able to set the db connections?
  • e

    Ethan Pursley

    03/20/2020, 12:11 AM
    in the prisma_config env var
  • e

    Ethan Pursley

    03/20/2020, 12:11 AM
    Copy code
    connectionLimit: 100
  • e

    Ethan Pursley

    03/20/2020, 12:11 AM
    sorry, that goes under database
  • e

    Ethan Pursley

    03/20/2020, 12:12 AM
    Copy code
    databases:
                        default:
                          connector: ${DbConnector}
                          host: ${DbHost}
                          port: ${DbPort}
                          user: ${DbUser}
                          password: ${DbPassword}
                          migrations: true
                          rawAccess: true
                          connectionLimit: 100
  • a

    Alan

    03/20/2020, 12:18 AM
    How is that any different that queuesize?
  • e

    Ethan Pursley

    03/20/2020, 12:20 AM
    I’m really unsure what queuesize does. but we increased it to 20k in hopes it would help and it did nothing but make prisma fall over faster
  • a

    Alan

    03/20/2020, 12:20 AM
    🤔
  • a

    Alan

    03/20/2020, 12:21 AM
    so the thing about prisma is that it doesn't utilize any read endpoints...
  • a

    Alan

    03/20/2020, 12:21 AM
    so using read replicas is basically useless, right?
  • e

    Ethan Pursley

    03/20/2020, 12:21 AM
    correct
  • e

    Ethan Pursley

    03/20/2020, 12:22 AM
    not only that but prisma 1 is maintainance only, so don’t expect much from it.
  • a

    Alan

    03/20/2020, 12:22 AM
    yeah 😞
  • a

    Alan

    03/20/2020, 12:22 AM
    how many users do you currently have Ethan?
  • a

    Alan

    03/20/2020, 12:23 AM
    I'm load testing for something related to auth tokens, and it crashes at 280
  • a

    Alan

    03/20/2020, 12:23 AM
    thats with 130 replicas
  • e

    Ethan Pursley

    03/20/2020, 12:23 AM
    It’s hard to say, because we don’t have good app insights, but we are trying to support 2k concurrent but are likely falling over around 200~
  • e

    Ethan Pursley

    03/20/2020, 12:24 AM
    and that’s with all of the optimization / scaling suggestions in place
  • a

    Alan

    03/20/2020, 12:26 AM
    are you using fargate?
  • a

    Alan

    03/20/2020, 12:27 AM
    was wondering if you are using alb to auto scale your ecs containers
  • a

    Alan

    03/20/2020, 12:27 AM
    do you know what the connection Limit default is?
  • a

    Alan

    03/20/2020, 12:27 AM
    if you do not set it?
  • e

    Ethan Pursley

    03/20/2020, 12:29 AM
    I am using fargate and they are behind a load balancer
1...354355356...637Latest