打开 关闭

Database Per Tenant Migration for 1000+ Databases #1210


User avatar
0
falsharif 创建
  • ABP Framework version: v4.2.2
  • UI type: / Blazor
  • DB provider: EF Core /
  • Tiered (MVC) or Identity Server Separated (Angular): no

Dear team, is there a faster way to run DBMigrator on 1000+ Tenants ? its currently taking hours to finish as it loops through all the tenants one by one, i understand that. But this strategy is causing us to have downtimes when we do schema updates.

Is there a way to keep the system running while migration is running ? is there a faster way to migrate this many databases ? can i migrate them back to a single database ?


4 答案
  • User Avatar
    0
    maliming 创建
    支持团队 Fullstack Developer

    hi

    Dear team, is there a faster way to run DBMigrator on 1000+ Tenants ?

    You can try to execute the migration concurrently, such as creating multiple threads to execute the migration separately.

    Is there a way to keep the system running while migration is running ?

    This is similar to system running when changing the database, which may be difficult or impossible.

    can i migrate them back to a single database ?

    You can back to use the Host database by deleting the tenant's connection string.

  • User Avatar
    0
    falsharif 创建

    hi

    Dear team, is there a faster way to run DBMigrator on 1000+ Tenants ?

    You can try to execute the migration concurrently, such as creating multiple threads to execute the migration separately.

    Is there a way to keep the system running while migration is running ?

    This is similar to system running when changing the database, which may be difficult or impossible.

    can i migrate them back to a single database ?

    You can back to use the Host database by deleting the tenant's connection string.

    "You can back to use the Host database by deleting the tenant's connection string."

    does the script move the data back to the host database ?

  • User Avatar
    0
    maliming 创建
    支持团队 Fullstack Developer

    does the script move the data back to the host database ?

    No, You should do this manually.

  • User Avatar
    0
    ServiceBot 创建
    支持团队 Automatic process manager

    This question has been automatically marked as stale because it has not had recent activity.

Made with ❤️ on ABP v8.2.0-preview Updated on 三月 25, 2024, 15:11