MariaDB /etc/mysql/debian-start

原始 📋 Ubuntu 24.04 LTS (Noble Numbat) 50 行

详情

大小
50 行
MD5
c08358d02a853b1dda4bcc4a56f5f798
SHA256
3121b5eb5f3faf8071c8b4853b394a9d958f3d6ba7fc6950a8c7f7fc82d786b9
/etc/mysql/debian-start
#!/bin/bash
#
# This script is executed by both SysV init /etc/init.d/mariadb and
# systemd mariadb.service on every (re)start.
#
# Changes to this file will be preserved when updating the Debian package.
#

# shellcheck source=debian/additions/debian-start.inc.sh
source /usr/share/mysql/debian-start.inc.sh

# Read default/mysql first and then default/mariadb just like the init.d file does
if [ -f /etc/default/mysql ]
then
  # shellcheck source=/dev/null
  . /etc/default/mysql
fi

if [ -f /etc/default/mariadb ]
then
  # shellcheck source=/dev/null
  . /etc/default/mariadb
fi

MARIADB="/usr/bin/mariadb --defaults-extra-file=/etc/mysql/debian.cnf"
MYADMIN="/usr/bin/mariadb-admin --defaults-extra-file=/etc/mysql/debian.cnf"
# Don't run full mariadb-upgrade on every server restart, use --version-check to do it only once
MYUPGRADE="/usr/bin/mariadb-upgrade --defaults-extra-file=/etc/mysql/debian.cnf --version-check --silent"
MYCHECK_SUBJECT="WARNING: mariadb-check has found corrupt tables"
MYCHECK_RCPT="${MYCHECK_RCPT:-root}"

## Checking for corrupt, not cleanly closed (only for MyISAM and Aria engines) and upgrade needing tables.

# The following commands should be run when the server is up but in background
# where they do not block the server start and in one shell instance so that
# they run sequentially. They are supposed not to echo anything to stdout.
# If you want to disable the check for crashed tables comment
# "check_for_crashed_tables" out.
# (There may be no output to stdout inside the background process!)

# Need to ignore SIGHUP, as otherwise a SIGHUP can sometimes abort the upgrade
# process in the middle.
trap "" SIGHUP
(
  upgrade_system_tables_if_necessary;
  check_root_accounts;
  check_for_crashed_tables;
) >&2 &

exit 0

复制粘贴

curl:
curl https://exampleconfig.com/api/v1/config/original/c08358d02a853b1dda4bcc4a56f5f798?hint=debian-start
wget:
wget -O debian-start https://exampleconfig.com/api/v1/config/original/c08358d02a853b1dda4bcc4a56f5f798?hint=debian-start

给 AI Agent 用

<prompt><role>DevOps agent</role><source url='https://exampleconfig.com/api/v1/config/original/c08358d02a853b1dda4bcc4a56f5f798?hint=debian-start' /><config><app>MariaDB</app><os>Ubuntu 24.04 LTS (Noble Numbat)</os><location>/etc/mysql/debian-start</location><lines>50</lines><md5>c08358d02a853b1dda4bcc4a56f5f798</md5><sha256>3121b5eb5f3faf8071c8b4853b394a9d958f3d6ba7fc6950a8c7f7fc82d786b9</sha256></config></prompt>

粘贴到 Claude、ChatGPT 或任何 AI 助手里。

安装 MariaDB

Alpine Linux

sudo apk add mariadb

Debian

sudo apt update && sudo apt install mariadb-server

Red Hat Enterprise Linux

sudo yum install mariadb-server

Ubuntu

sudo apt update && sudo apt install mariadb-server

文件位置

文件路径
/etc/mysql/debian-start
目录
/etc/mysql/
用途
系统级配置目录
说明
/etc/ 里的文件是系统级配置,影响所有用户。

FAQ

什么时候该用这个 debian-start?

用来恢复缺失的默认文件、确认发行版本带了什么,或拿你的 MariaDB config 做 diff。

怎么恢复 MariaDB 的默认配置?

下载文件,把 /etc/mysql/debian-start 里的当前配置备份好,替换掉,然后 reload 或 restart MariaDB。

debian-start 适合直接上生产吗?

这是 Ubuntu 24.04 LTS (Noble Numbat) 的厂商默认配置,只能当基线。上生产前请检查安全和性能设置。

和其他 OS 版本有什么不同?

默认值会随发行版和版本变化,这份对应 Ubuntu 24.04 LTS (Noble Numbat)。

我可以用它来排查 MariaDB 吗?

可以。和你的配置做 diff 找出漂移,然后只恢复需要的段落。