Storage Seçimi

builder.Services.AddHangfire(config => config
    .UseSqlServerStorage(connectionString, new SqlServerStorageOptions
    {
        CommandBatchMaxTimeout = TimeSpan.FromMinutes(5),
        SlidingInvisibilityTimeout = TimeSpan.FromMinutes(5),
        QueuePollInterval = TimeSpan.Zero,                  // Long-polling (SlidingInvisibility ile birlikte)
        UseRecommendedIsolationLevel = true,                // ReadCommitted
        DisableGlobalLocks = true,                          // Schema 7+ gerektirir
        TryAutoDetectSchemaDependentOptions = true,         // 1.8: Schema'ya göre otomatik optimizasyon
        SchemaName = "hangfire",                            // İzole schema
        PrepareSchemaIfNecessary = true                     // Auto-migration
    }));

builder.Services.AddHangfire(config => config
    .UseRedisStorage(redisConnectionString, new RedisStorageOptions
    {
        Prefix = "hangfire:",            // Key prefix
        Db = 3,                          // Ayrı Redis DB
        InvisibilityTimeout = TimeSpan.FromMinutes(30),
        ExpiryCheckInterval = TimeSpan.FromMinutes(5)
    }));

dotnet add package Hangfire.PostgreSql

// NuGet: Hangfire.PostgreSql (community, Frank.HangFire.Mongo da var)
builder.Services.AddHangfire(config => config
    .UsePostgreSqlStorage(options => options
        .UseNpgsqlConnection(postgresConnectionString), new PostgreSqlStorageOptions
    {
        SchemaName = "hangfire",
        QueuePollInterval = TimeSpan.FromSeconds(5),  // PG: LISTEN/NOTIFY destekli, Zero KULLANMAYIN (PG'de long-polling yok)
        PrepareSchemaIfNecessary = true,
        InvisibilityTimeout = TimeSpan.FromMinutes(5)
    }));

// appsettings.Production.json
// Connection string'leri secret manager'dan alın (User Secrets, Azure Key Vault, AWS SSM)
{
  "ConnectionStrings": {
    "DefaultConnection": "Server=db-primary;Database=MyApp;User Id=app_user;Password=${DB_PASSWORD};Encrypt=true;TrustServerCertificate=false",
    "HangfireConnection": "Server=db-hangfire;Database=HangfireDb;User Id=hangfire_svc;Password=${HANGFIRE_DB_PASSWORD};Max Pool Size=100;Encrypt=true;TrustServerCertificate=false"
  }
}

// Program.cs — ayrı connection string
builder.Services.AddHangfire(config => config
    .UseSqlServerStorage(
        builder.Configuration.GetConnectionString("HangfireConnection"),
        new SqlServerStorageOptions
        {
            SchemaName = "hangfire",
            PrepareSchemaIfNecessary = true,
            DisableGlobalLocks = true
        }));

// Aynı DB, farklı schema — basit ama riskli
builder.Services.AddHangfire(config => config
    .UseSqlServerStorage(
        builder.Configuration.GetConnectionString("DefaultConnection"),
        new SqlServerStorageOptions
        {
            SchemaName = "hangfire",          // Default "HangFire" schema
            PrepareSchemaIfNecessary = true
        }));

// Connection pool tükenmesini önlemek için pool size artırın
// Hangfire worker'lar + app request'leri aynı pool'u paylaşır
// Connection string'e ekleyin: "Max Pool Size=200"