AspNetCore.HealthChecks.MySql 8.0.0

dotnet add package AspNetCore.HealthChecks.MySql --version 8.0.0
NuGet\Install-Package AspNetCore.HealthChecks.MySql -Version 8.0.0
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="AspNetCore.HealthChecks.MySql" Version="8.0.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add AspNetCore.HealthChecks.MySql --version 8.0.0
#r "nuget: AspNetCore.HealthChecks.MySql, 8.0.0"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
// Install AspNetCore.HealthChecks.MySql as a Cake Addin
#addin nuget:?package=AspNetCore.HealthChecks.MySql&version=8.0.0

// Install AspNetCore.HealthChecks.MySql as a Cake Tool
#tool nuget:?package=AspNetCore.HealthChecks.MySql&version=8.0.0

MySQL Health Check

This health check verifies the ability to communicate with a MySQL Server. It uses the provided MySqlDataSource or a connection string to connect to the server.

Defaults

By default, the MySqlDataSource instance is resolved from service provider. (This should be the same as the instance being used by the application; do not create a new MySqlDataSource just for the health check.) The health check will send a MySQL "ping" packet to the server to verify connectivity.

builder.Services
    .AddMySqlDataSource(builder.Configuration.GetConnectionString("mysql")) // using the MySqlConnector.DependencyInjection package
    .AddHealthChecks().AddMySql();

Connection String

You can also specify a connection string directly:

builder.Services.AddHealthChecks().AddMySql(connectionString: "Server=...;User Id=...;Password=...");

This can be useful if you're not using MySqlDataSource in your application.

Customization

You can additionally add the following parameters:

  • healthQuery: A query to run against the server. If null (the default), the health check will send a MySQL "ping" packet to the server.
  • configure: An action to configure the MySqlConnection object. This is called after the MySqlConnection is created but before the connection is opened.
  • name: The health check name. The default is mysql.
  • failureStatus: The HealthStatus that should be reported when the health check fails. Default is HealthStatus.Unhealthy.
  • tags: A list of tags that can be used to filter sets of health checks.
  • timeout: A System.TimeSpan representing the timeout of the check.
builder.Services
    .AddMySqlDataSource(builder.Configuration.GetConnectionString("mysql"))
    .AddHealthChecks().AddMySql(
        healthQuery: "SELECT 1;",
        configure: conn => conn.ConnectTimeout = 3,
        name: "MySQL"
    );

Breaking changes

In previous versions, MySqlHealthCheck defaulted to testing connectivity by sending a SELECT 1; query to the server. It has been changed to send a more efficient "ping" packet instead. To restore the previous behavior, specify healthQuery: "SELECT 1;" when registering the health check.

While not a breaking change, it's now preferred to use MySqlDataSource instead of a connection string. This allows the health check to use the same connection pool as the rest of the application. This can be achieved by calling the .AddMySql() overload that has no required parameters. The health check assumes that a MySqlDataSource instance has been registered with the service provider and will retrieve it automatically.

Product Compatible and additional computed target framework versions.
.NET net5.0 was computed.  net5.0-windows was computed.  net6.0 was computed.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 was computed.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 was computed.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed. 
.NET Core netcoreapp2.0 was computed.  netcoreapp2.1 was computed.  netcoreapp2.2 was computed.  netcoreapp3.0 was computed.  netcoreapp3.1 was computed. 
.NET Standard netstandard2.0 is compatible.  netstandard2.1 was computed. 
.NET Framework net461 was computed.  net462 was computed.  net463 was computed.  net47 was computed.  net471 was computed.  net472 was computed.  net48 was computed.  net481 was computed. 
MonoAndroid monoandroid was computed. 
MonoMac monomac was computed. 
MonoTouch monotouch was computed. 
Tizen tizen40 was computed.  tizen60 was computed. 
Xamarin.iOS xamarinios was computed. 
Xamarin.Mac xamarinmac was computed. 
Xamarin.TVOS xamarintvos was computed. 
Xamarin.WatchOS xamarinwatchos was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (38)

Showing the top 5 NuGet packages that depend on AspNetCore.HealthChecks.MySql:

Package Downloads
NanoCore

The project is inspired by years of tedious repetitions, continuously re-writing similar code-snippets and libraries, to handle common functionality, not related to the business domain, such as logging, data persistence, message queuing, documentation, validation and similar.

FenixAlliance.ACL.Dependencies

Application Component for the Alliance Business Suite.

EachShow.Host

主机启动程序

GeeksCoreLibrary

Geeks Core Library

Marvel.Web.Framework

Marvel.Web.Framework

GitHub repositories (12)

Showing the top 5 popular GitHub repositories that depend on AspNetCore.HealthChecks.MySql:

Repository Stars
Ombi-app/Ombi
Want a Movie or TV Show on Plex/Emby/Jellyfin? Use Ombi!
skoruba/IdentityServer4.Admin
The administration for the IdentityServer4 and Asp.Net Core Identity
dotnet/aspire
An opinionated, cloud ready stack for building observable, production ready, distributed applications in .NET
dotnetcore/osharp
OSharp是一个基于.Net6.0的快速开发框架,框架对 AspNetCore 的配置、依赖注入、日志、缓存、实体框架、Mvc(WebApi)、身份认证、功能权限、数据权限等模块进行更高一级的自动化封装,并规范了一套业务实现的代码结构与操作流程,使 .Net 框架更易于应用到实际项目开发中。
AlphaYu/adnc
.NET微服务/分布式开发框架,同时也适用于单体架构系统的开发。
Version Downloads Last updated
8.0.0 74,812 12/15/2023
7.0.0 126,730 7/30/2023
7.0.0-rc2.5 21,908 3/13/2023
7.0.0-rc2.4 11,780 1/14/2023
7.0.0-rc2.3 176 12/27/2022
7.0.0-rc2.2 124 12/27/2022
6.0.2 1,737,141 2/28/2022
6.0.1 242,226 12/29/2021
6.0.1-rc1.1 29,759 11/5/2021
6.0.0 11,752 12/29/2021
5.0.1 655,644 1/5/2021
5.0.0 9,570 12/29/2020
5.0.0-preview1 3,912 11/22/2020
3.2.0 238,360 9/3/2020
3.1.1 599,400 4/17/2020
3.1.0 33,296 4/9/2020
3.0.0 388,874 9/24/2019
2.2.0 590,570 11/14/2018