eneance.MajimajiDBMYSQL 1.1.0

MajimajiDBMYSQL

MajimajiDBMYSQL is a simple database changelog management system, for MYSQL (if you want to use MSSQL, you can use MajimajiDB nuget package).

It will apply SQL changelog, store in files (named with pattern *.sql), according to file names order. It is launched at application startup, and can be launched across multiple application nodes to ensure horizontal scalability.

Currently supporting only MYSQL, and requires Serilog

Usage

Inside Startup.cs add this import:

using eneance.MajimajiDBMYSQL;

And add this line inside ConfigureServices():

public void ConfigureServices(IServiceCollection services)
{
    ...
    services.AddHostedService<MajimajiDBMYSQL>();
    ...
}

And you are ready to go !

Configuration

Configuration is done through appsettings.json files, with this node:

"MajimajiDB": {
    "AbsoluteChangelogPath": "[PATH TO CHANGELOG DIR]",  // Absolute path of the directory containing changelogs (e.g *.sql files), default value is "../MajimajiDBMYSQL/changelogs"
    "LocalChangelogPath": "[PATH TO CHANGELOG DIR]",  // App run relative path of the directory containing changelogs (e.g *.sql files), default value is "../MajimajiDBMYSQL/changelogs"
    "ConnectionString": "[CONNECTION STRING]", // The connection string, if not provided, then the default connection string is used
    "RetryDelay": 1234, // if databse is locked by another process, the delay between 2 attempt to run, in milliseconds (default: 1000)
    "RetryMaxNumber": 42 // if databse is locked by another process, the number of retry before killing the app (default: 60)
}

Running

Nothing to do ! Just provide changelogs as *.sql files...