LoginLink.Connectors.Database.MySql 0.2.0

LoginLink.Connectors.Database.MySql

True BYO-DB MySQL storage backend for LoginLink.

A tenant admin points their tenant at a MySQL server they own and operate — Aiven, PlanetScale, RDS, Azure Database for MySQL, or a self-hosted instance (MySQL 8.0+ or a compatible fork). LoginLink never provisions, installs, or hosts the database itself; it only validates and uses a connection string the tenant supplies. SQLite remains the permanent, always-available default — this connector is an additive option, never a replacement.

Scope

Originally Tenant-scope only under LOCK-50 ("host.db/platform.db are permanently SQLite"). Superseded (2026-09-17): Host and Platform scope are both now supported too, so the control plane itself can run directly on MySQL — a fresh /setup install, or a later migration via PlatformScopeMigrationService.

Dialect notes

• Every integer-ish column is BIGINT, never plain INT — matches the 8-byte width Dapper's dynamic-row (long)row.x casts expect.
• Every TEXT column that's part of a PRIMARY KEY, UNIQUE, or index is VARCHAR(n) instead — MySQL/InnoDB can't index a TEXT/BLOB column without an explicit prefix length. Columns that are never indexed stay TEXT.
• Indexes are declared inline inside each table's own CREATE TABLE IF NOT EXISTS rather than as separate CREATE INDEX statements — MySQL has no CREATE INDEX IF NOT EXISTS, so this sidesteps the idempotency problem entirely instead of needing a try/catch-per-index helper.
• ENGINE=InnoDB is explicit on every table, since this schema depends on real foreign-key enforcement (MyISAM silently ignores FOREIGN KEY clauses).

Registration

builder.Services.AddMySqlStorage();

// AFTER app = builder.Build() (not inside ConnectorRegistry's own factory —
// see PostgresqlDatabaseConnector's registration in Program.cs for why):
var mysql = app.Services.GetRequiredService<MySqlDatabaseConnector>();
connectorRegistry.Register((IDatabaseConnector)mysql);
connectorRegistry.RegisterSchemaProvisioner(mysql.Name,
    app.Services.GetRequiredService<MySqlSchemaProvisioner>());

Connection details

Read per-tenant via ITenantStorageCredentialsReader, never from appsettings.json — each tenant's own host/port/database/username/password/SSL mode are stored (encrypted) in platform.db.tenant_storage_credentials.