|
Install mariadb from bare metal
/etc/my.cnf (comment are removed) :
----------------------------------------------
[client]
|
|
[mysqld]
|
innodb_file_format=Barracuda
|
innodb_file_per_table=ON
|
server-id = 1
|
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
|
|
[mysqld_multi]
|
mysqld = /usr/bin/mysqld_safe
|
mysqladmin = /usr/bin/mysqladmin
|
log = /var/log/mysqld_multi.log
|
!includedir /etc/my.cnf.d
|
/etc/my.cnf.d/cfg_1.cnf (comment are removed) :
--------------------------------------------------------------
[mysqld1]
|
port = 63331
|
log-warnings = 6
|
user = mysql
|
symbolic-links = 0
|
/etc/systemd/system :
---------------------------
[Unit]
|
Description=MySQL Multi Server for instance %i
|
After=syslog.target
|
After=network.target
|
|
[Service]
|
User=mysql
|
Group=mysql
|
Type=forking
|
ExecStart=/usr/bin/mysqld_multi --defaults-file=/etc/my.cnf.d/cfg_%i.cnf --verbose start %i
|
ExecStop=/usr/bin/mysqld_multi stop %i
|
#Restart=always
|
#RestartSec=5
|
PrivateTmp=true
|
|
[Install]
|
WantedBy=multi-user.target
|
|
Got this error :
mai 02 14:33:29 ASUS-G75VW-JC systemd[1]: Starting MySQL Multi Server for instance 1...
|
mai 02 14:33:29 ASUS-G75VW-JC mysqld_multi[7785]: WARNING: Log file disabled. Maybe directory or file isn't writable?
|
mai 02 14:33:29 ASUS-G75VW-JC mysqld_multi[7785]: mysqld_multi log file version 2.16; run: Wed May 2 14:33:29 2018
|
mai 02 14:33:29 ASUS-G75VW-JC mysqld_multi[7785]: Starting MySQL servers
|
mai 02 14:33:29 ASUS-G75VW-JC systemd[1]: Started MySQL Multi Server for instance 1.
|
|
Running this command show how variables are set :
mysql --port=63331 -BNe 'show global variables' | grep -e datadir -e sock -e pid -e err -e general_log
|
And return :
datadir /var/lib/mysql/
|
general_log OFF
|
general_log_file ASUS-G75VW-JC.log
|
log_error /var/log/mysql/mysqld.log
|
.......
|
.......
|
pid_file /var/lib/mysql/ASUS-G75VW-JC.pid
|
.........
|
........
|
socket /var/run/mysql/mysql.sock
|
Log file is set but is not used.
Adding a log option ( --log=/var/log/mysqld_multi.log ) in mysqld@service suppress the error warning.
ExecStart=/usr/bin/mysqld_multi --defaults-file=/etc/my.cnf.d/cfg_%i.cnf --log=/var/log/mysqld_multi.log --verbose start %i
|
|