@maciej-wisniowski Thanks for your help. I was able to connect but had some trouble from then on. I will create an issue on github and see if official support can be added.

Is there a recommended way of running fusion auth on a clustered database?

Hi there,

I am trying to get fusion auth running in docker. I am using the MySQL setting and trying to connect it to a Vitess cluster. I am in maintenance mode and it doesn't accept the Vitess details. Has anyone got this working?

https://vitess.io/

Thanks

Paul

Here is my docker-compose.yml file:

version: '3'
services:
    vitess-test-8_0:
        image: vitess/vttestserver:mysql80@sha256:5fec546e3f2ba50237b78938982a72bf17eacbc97f18ab877774f22d6e2e9682
        restart: always
        ports:
            - 5421:33807
        environment:
            PORT: 33804
            KEYSPACES: 'test'
            NUM_SHARDS: '1'
            MYSQL_BIND_HOST: '0.0.0.0'
            FOREIGN_KEY_MODE: 'disallow'
            MYSQL_ROOT_PASSWORD: prisma
            MYSQL_DATABASE: global-person
            MYSQL_USER: prisma
            MYSQL_PASSWORD: prisma

    vitess-shadow-8_0:
        image: vitess/vttestserver:mysql80@sha256:5fec546e3f2ba50237b78938982a72bf17eacbc97f18ab877774f22d6e2e9682
        restart: always
        ports:
            - 5422:33807
        environment:
            PORT: 33804
            KEYSPACES: 'shadow'
            NUM_SHARDS: '1'
            MYSQL_BIND_HOST: '0.0.0.0'
            FOREIGN_KEY_MODE: 'disallow'
            MYSQL_ROOT_PASSWORD: prisma
            MYSQL_DATABASE: global-person
            MYSQL_USER: prisma
            MYSQL_PASSWORD: prisma

    fusionauth:
        image: fusionauth/fusionauth-app:latest
        depends_on:
            - vitess-test-8_0
        environment:
            DATABASE_URL: jdbc:mysql://localhost:5421/fusionauth
            database.root.username: prisma
            DATABASE_ROOT_PASSWORD: prisma
            database.username: prisma
            DATABASE_PASSWORD: prisma
            FUSIONAUTH_APP_MEMORY: 500M
            search.type: database
            fusionauth-app.url: http://fusionauth:9011
            FUSIONAUTH_APP_SILENT_MODE: 'false'
        restart: unless-stopped
        ports:
            - 9011:9011
        volumes:
            - fa_config:/usr/local/fusionauth/config

volumes:
    fa_config:

I am only new to this but could you not use the typescript client?

The passport-oidc-strategy seems abandoned.

There is this but there is no documentation:
https://github.com/mdwagner/next-great-idea/tree/master/nestjs

There are many guides on how to use Okta with NestJS such as

• https://developer.okta.com/blog/2020/02/26/build-a-secure-nestjs-api-with-postgres

• https://www.youtube.com/watch?v=6PJbHtBXRxQ

• https://okta-blog.netlify.app/blog/2021/02/22/first-nestjs-application

• https://slacker.ro/2021/03/15/build-a-secure-nestjs-back-end-for-your-react-application/

Even if FusionAuth is a better product, it just seems a lot easier to find information on Okta.

I had the same problem with https://www.ory.sh/ I just could not find any guides on how to integrate it.