FromLake's questions

我有一个文件 /etc/mysql/mysqld_multi_cls.cnf，其中包含 mariadb 多个数据库实例所需的一切。

我可以使用以下命令启动这些实例：

sudo mariadbd-multi --defaults-file=/etc/mysql/mysqld_multi_cls.cnf start  

 

但是我找不到在启动时启动这些实例的（巧妙的）方法。

在 /conf.d/ 文件夹中添加 .cnf 文件不会启动实例，除非我不知情地搞砸了。数据库在基于 Debian 的 Raspberry pi5、Raspberry Pi OS 上运行。而且我对 Linux 相当不熟悉/菜鸟。

请求后，这是.cnf文件：

# Configuration Settings for mysqld_multi , as well as separate instances. 
#
[mysqld_multi]
mysqld       = /usr/bin/mariadbd-safe
mysqladmin   = /usr/bin/mariadb-admin

[mysqld2]
socket          = /tmp/mysql.sock2
port            = 3307
pid-file        = /usr/local/mysql/mdb2/ansible-host1.pid2
datadir         = /var/lib/mysql2
log-error       = /var/log/mysql2/error.log
log-bin             = /var/log/mysql2/mdb2-mysql-bin.log
server-id               = 2
expire-logs-days    = 72
sync_binlog              = 1
innodb_flush_log_at_trx_commit  = 1
innodb_flush_method = O_DIRECT      
binlog_format                 = mixed
gtid_strict_mode            = 1

[mysqld3]
socket          = /tmp/mysql.sock3
port            = 3308
pid-file        = /usr/local/mysql/mdb3/ansible-host1.pid3
datadir         = /var/lib/mysql3
log-error       = /var/log/mysql3/error.log
log-bin             = /var/log/mysql3/mdb3-mysql-bin.log
server-id               = 3
expire-logs-days    = 64
sync_binlog     = 1
innodb_flush_log_at_trx_commit  = 1
innodb_flush_method = O_DIRECT  
binlog_format       = mixed
gtid_strict_mode    = 1

[mysqld4]
socket          = /tmp/mysql.sock4
port            = 3309
pid-file        = /usr/local/mysql/mdb4/ansible-host1.pid4
datadir         = /var/lib/mysql4
log-error       = /var/log/mysql4/error.log
log-bin             = /var/log/mysql4/mdb4-mysql-bin.log
server-id               = 4
expire-logs-days    = 64
sync_binlog     = 1
innodb_flush_log_at_trx_commit  = 1
innodb_flush_method = O_DIRECT  
binlog_format       = mixed
gtid_strict_mode    = 1

-- 编辑 -- 在下面的答案中完成设置。-- 编辑 --

当我按照一篇关于如何在 Linux 上设置额外的 MariaDB 或 Mysql 的文章（下面的链接）操作时，它就起作用了。但是，我不喜欢“mysql1”和“mysql2”作为实例名称。但当我只更改代码的这一方面时，运行启动命令时服务器不会安装。

为了便于比较，我在下面列出了两种设置：一种是可以工作的设置，其中创建了 2 个实例，另一种最终不起作用。我非常想知道如何让不起作用的那个起作用。非常感谢您的帮助！

- 1）Datadir（有效的设置）：

sudo mkdir -p -v /var/lib/mysql{1..2}
sudo chown mysql:mysql -v /var/lib/mysql{1..2}

- 1）Datadir（最终不起作用的设置）：

sudo mkdir -p -v /var/lib/mysqlTest
sudo chown mysql:mysql -v /var/lib/mysqlTest

- 2）套接字目录（有效的设置）：

sudo mkdir -p -v /usr/local/mysql/mdb{1..2}
sudo chown -v -R mysql:mysql /usr/local/mysql/mdb{1..2}

- 2）套接字目录（最终不起作用的设置）：

sudo mkdir -p -v /usr/local/mysql/mdbTest
sudo chown -v -R mysql:mysql /usr/local/mysql/mdbTest

- 3）日志目录（有效的设置）：

sudo mkdir -p -v /var/log/mysql{1..2}
sudo chown -v -R mysql:mysql /var/log/mysql{1..2}

- 3）日志目录（最终不起作用的设置）：

sudo mkdir -p -v /var/log/mysqlTest
sudo chown -v -R mysql:mysql /var/log/mysqlTest

- 4）我创建以下文件

“mysqld_multi_cls.cnf”

位于：/etc/mysql/

- 5）内容（有效的设置）：

# Configuration Settings for mysqld_multi , as well as separate instances. 
#
[mysqld_multi]
mysqld       = /usr/bin/mysqld_safe
mysqladmin   = /usr/bin/mysqladmin

[mysqld1]
socket          = /tmp/mysql.sock1
port            = 3307
pid-file        = /usr/local/mysql/mdb1/ansible-host1.pid1
datadir         = /var/lib/mysql1
log-error       = /var/log/mysql1/error.log
log_bin         = /var/lib/mysql1/mdb1-mysql-bin.log
server-id       = 1
expire_logs_days = 72
sync_binlog     = 1
innodb_flush_log_at_trx_commit = 1
innodb_flush_method = O_DIRECT      
binlog_format       = mixed
gtid_strict_mode    = 1

[mysqld2]
socket          = /tmp/mysql.sock2
port            = 3308
pid-file        = /usr/local/mysql/mdb2/ansible-host1.pid2
datadir         = /var/lib/mysql2
log-error       = /var/log/mysql2/error.log
log-bin         = /var/lib/mysql2/mdb2-mysql-bin.log
server-id       = 2
expire_logs_days = 64
sync_binlog     = 1
innodb_flush_log_at_trx_commit  = 1
innodb_flush_method             = O_DIRECT  
binlog_format                   = mixed
gtid_strict_mode                = 1

- 5）内容（最终不起作用的设置）：

# Configuration Settings for mysqld_multi , as well as separate instances. 
#
[mysqld_multi]
mysqld       = /usr/bin/mysqld_safe
mysqladmin   = /usr/bin/mysqladmin

[mysqlTest]
socket          = /tmp/mysql.sock3
port            = 3309
pid-file        = /usr/local/mysql/mdbTest/ansible-host1.pid3
datadir         = /var/lib/mysqlTest
log-error       = /var/log/mysqlTest/error.log
log_bin         = /var/lib/mysqlTest/mdbTest-mysql-bin.log
server-id       = 3
expire_logs_days = 72
sync_binlog     = 1
innodb_flush_log_at_trx_commit  = 1
innodb_flush_method             = O_DIRECT      
binlog_format                   = mixed
gtid_strict_mode                = 1

-6）现在我们启动服务器：

sudo mysqld_multi --defaults-file=/etc/mysql/mysqld_multi_cls.cnf --log=/etc/mysql/multi_ins.log start      

• 如果在第一种情况下完成，数据库现在正在安装，每个人都很高兴。
• 但是，如果在第二种庄园中，我只更改了名称并创建了一个（额外的）实例，什么也不会发生。

我错过了什么？

欢呼并非常感谢！

以下是 Michael Amadi 在 Linkedin 上的文章： https: //www.linkedin.com/pulse/running-multiple-instances-mariadb-single-server-different-amadi