什么时候该用这个 my.cnf.fallback?
用来恢复缺失的默认文件、确认发行版本带了什么,或拿你的 MariaDB config 做 diff。
# Copyright (c) 2015, 2025, Oracle and/or its affiliates. # # This program is free software; you can redistribute it and/or modify # it under the terms of the GNU General Public License, version 2.0, # as published by the Free Software Foundation. # # This program is designed to work with certain software (including # but not limited to OpenSSL) that is licensed under separate terms, # as designated in a particular file or component or in included license # documentation. The authors of MySQL hereby grant you an additional # permission to link the program and your derivative works with the # separately licensed software that they have either included with # the program or referenced in the documentation. # # This program is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # GNU General Public License, version 2.0, for more details. # # You should have received a copy of the GNU General Public License # along with this program; if not, write to the Free Software # Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA # # The MySQL Community Server configuration file. # # For explanations see # http://dev.mysql.com/doc/mysql/en/server-system-variables.html # * IMPORTANT: Additional settings that can override those from this file! # The files must end with '.cnf', otherwise they'll be ignored. # !includedir /etc/mysql/conf.d/
curl https://exampleconfig.com/api/v1/config/original/c6e5f8779da0dbdc84837cef20dae05d?hint=my.cnf.fallback
wget -O my.cnf.fallback https://exampleconfig.com/api/v1/config/original/c6e5f8779da0dbdc84837cef20dae05d?hint=my.cnf.fallback
<prompt><role>DevOps agent</role><source url='https://exampleconfig.com/api/v1/config/original/c6e5f8779da0dbdc84837cef20dae05d?hint=my.cnf.fallback' /><config><app>MariaDB</app><os>Ubuntu 22.04 LTS (Jammy Jellyfish)</os><location>/etc/mysql/my.cnf.fallback</location><lines>33</lines><md5>c6e5f8779da0dbdc84837cef20dae05d</md5><sha256>824fcb08a7ba8ffc9a49843fbd612b18b751e8d082be94ede59b81cf8686c593</sha256></config></prompt>
粘贴到 Claude、ChatGPT 或任何 AI 助手里。
sudo apk add mariadb
sudo apt update && sudo apt install mariadb-server
sudo yum install mariadb-server
sudo apt update && sudo apt install mariadb-server
什么时候该用这个 my.cnf.fallback?
用来恢复缺失的默认文件、确认发行版本带了什么,或拿你的 MariaDB config 做 diff。
怎么恢复 MariaDB 的默认配置?
下载文件,把 /etc/mysql/my.cnf.fallback 里的当前配置备份好,替换掉,然后 reload 或 restart MariaDB。
my.cnf.fallback 适合直接上生产吗?
这是 Ubuntu 22.04 LTS (Jammy Jellyfish) 的厂商默认配置,只能当基线。上生产前请检查安全和性能设置。
和其他 OS 版本有什么不同?
默认值会随发行版和版本变化,这份对应 Ubuntu 22.04 LTS (Jammy Jellyfish)。
我可以用它来排查 MariaDB 吗?
可以。和你的配置做 diff 找出漂移,然后只恢复需要的段落。