Hi, in the architecture of Ory, can we have a cent...
# ory-selfhostingb
boundless-dress-11510
08/14/2023, 7:53 AMHi, in the architecture of Ory, can we have a central database for all component (kratos, keto, hydra and oauth)?
b
bulky-architect-22083
08/14/2023, 8:59 AMIt is possible but generally better to have separate databases for each of time to maintain data integrity.
b
boundless-dress-11510
08/14/2023, 9:00 AMSo, you mean a database to each component which mean 4 databases to maintain?
b
bulky-architect-22083
08/14/2023, 9:01 AMYes it is better to do so. I now have a combined database for kratos and hydra and already regretting it 😅
b
boundless-dress-11510
08/14/2023, 10:05 AMThis add a very huge worklaod for maintenance, operation and HA. One of my client setup oauth and hydra on the same mysql database and it work fine, so for me kratos and keto could use the same database as well
b
bulky-architect-22083
08/14/2023, 11:51 AMUpto you. Like I said, I am doing the same and regretting my choice. Hope you don't regret your choice 🙏
b
boundless-dress-11510
08/14/2023, 12:11 PMthanks for sharing
e
enough-yak-81379
08/14/2023, 1:27 PMwe would recommend running a separate db object for each application, but all of them can run inside 1 database instance
b
boundless-dress-11510
08/14/2023, 2:23 PMThanks a lot for your feedback !!!
boundless-dress-11510
08/14/2023, 4:00 PMdoes all module have its own database/schema running on the host or they can share the same database/schema?
e
enough-yak-81379
08/15/2023, 11:18 AMthey have their own schemas 🙂
b
bulky-architect-22083
08/15/2023, 11:23 AMWhen I try to do schema migrations on a database that is shared between Kratos and Hydra, I get an error that the Network table can’t be migrated. @enough-yak-81379
bulky-architect-22083
08/15/2023, 11:23 AMKratos v1.0.0 and Hydra v2.1.2
e
enough-yak-81379
08/15/2023, 11:24 AMdatabase that is sharedb
bulky-architect-22083
08/15/2023, 11:25 AMThe database instance is the same
bulky-architect-22083
08/15/2023, 11:25 AMBoth Kratos and Hydra share the same DSN
e
enough-yak-81379
08/15/2023, 11:27 AMuhm, then they are running in the same db object? That would be a bad practice imho, i d suggest running them like here https://github.com/ory/k8s/blob/master/hacks/values/postgres.yaml where you have separate db objects inside a single postgres instance
b
bulky-architect-22083
08/15/2023, 11:28 AMAh ok that makes sense. I was getting confused between instances and objects
bulky-architect-22083
08/15/2023, 11:28 AMThanks for the clarification!
e
enough-yak-81379
08/15/2023, 11:28 AMyeah, sorry! Not a db expert so might have chosen poor wording 😅
b
bulky-architect-22083
08/15/2023, 11:29 AMNot at all! Your explanation was on point. Thank you for the link and clarification
b
boundless-dress-11510
08/15/2023, 11:35 AMThe instance is the main process running database software (postgres, mysql or mariadb) on the host, the database is created within the instance and can be shared by one or more application (eg. kratos-db, keto-db or common-db), the objects (tables, index...) are items within a specific database (eg. kratos-db) and their own schema/attribute.
👍 1
b
bulky-architect-22083
08/15/2023, 11:36 AMYea once instance can have different objects and each object can have its own tables
bulky-architect-22083
08/15/2023, 11:36 AMSo as long as Kratos, Hydra are on different database objects, it should be fine
9 Views