I'm trying to create a master / slave in Mysql about CentOS (3.10.0-862.14.4.el7.x86_64) but I can not start it.
/usr/bin/mysql --version
/usr/bin/mysql Ver 14.14 Distrib 5.6.41, for Linux (x86_64) using EditLine wrapper
The content of /etc/my.cnf is:
[mysqld_safe]
log-error = /var/log/mysqld.log
pid-file = /var/run/mysqld/mysqld.pid
[mysqld_multi]
mysqld = /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin
#user = mysql_multi_admin
#password = mysql_multi_pass
[mysqld1]
server-id = 1
#ledir = /usr/sbin
port = 3307
datadir = /var/lib/mysql_master
socket = /var/lib/mysql/mysql_master.sock
pid-file = /var/run/mysqld/mysqld_master.pid
log_error = /var/log/mysql/error_master.log
symbolic-links = 0
character-set-server= utf8
max_allowed_packet = 1G
thread_concurrency = 12
table_open_cache = 1024
open_files_limit = 4096
key_buffer = 4G
log-bin = /var/log/mysql-bin
binlog_do_db = invenio
[mysqld2]
server-id = 2
#ledir = /usr/sbin
port = 3308
datadir = /var/lib/mysql_slave
socket = /var/lib/mysql_slave/mysql.sock
pid-file = /var/run/mysqld/mysqld_slave.pid
log_error = /var/log/mysql_slave/error.log
symbolic-links = 0
character-set-server= utf8
max_allowed_packet = 1G
thread_concurrency = 12
table_open_cache = 1024
open_files_limit = 4096
key_buffer = 4G
log-bin = /var/log/mysql-bin
binlog_do_db = invenio
read_only = 1
relay-log = /var/log/mysql_slave/relay-bin
relay-log-index = /var/log/mysql_slave/relay-bin.index
master-info-file = /var/log/mysql_slave/master.info
relay-log-info-file = /var/log/mysql_slave/relay-log.info
I install the corresponding BD:
mysql_install_db --user=mysql --datadir=/var/lib/mysql_master
mysql_install_db --user=mysql --datadir=/var/lib/mysql_slave
Apparently all good:
ls -la /var/lib/mysql_master
total 110604
drwxr-xr-x 4 mysql mysql 93 oct 5 11:36 .
drwxr-xr-x 67 root root 4096 oct 4 14:39 ..
-rw-rw---- 1 mysql mysql 12582912 oct 5 10:14 ibdata1
-rw-rw---- 1 mysql mysql 50331648 oct 5 10:14 ib_logfile0
-rw-rw---- 1 mysql mysql 50331648 oct 4 14:39 ib_logfile1
drwx------ 2 mysql mysql 4096 oct 4 14:39 mysql
drwx------ 2 mysql mysql 4096 oct 5 10:14 performance_schema
ls -la /var/lib/mysql_slave
total 110604
drwxr-xr-x 4 mysql mysql 93 oct 5 11:36 .
drwxr-xr-x 67 root root 4096 oct 4 14:39 ..
-rw-rw---- 1 mysql mysql 12582912 oct 4 14:30 ibdata1
-rw-rw---- 1 mysql mysql 50331648 oct 4 14:30 ib_logfile0
-rw-rw---- 1 mysql mysql 50331648 oct 4 14:30 ib_logfile1
drwx------ 2 mysql mysql 4096 oct 4 14:30 mysql
drwx------ 2 mysql mysql 4096 oct 4 14:30 performance_schema
I make sure he's getting the opts right:
my_print_defaults mysqld1
--server-id=1
--ledir=/usr/sbin
--port=3307
--datadir=/var/lib/mysql_master
--socket=/var/lib/mysql/mysql_master.sock
--pid-file=/var/run/mysqld/mysqld_master.pid
--log_error=/var/log/mysql/error_master.log
--symbolic-links=0
--character-set-server=utf8
--max_allowed_packet=1G
--thread_concurrency=12
--table_open_cache=1024
--open_files_limit=4096
--key_buffer=4G
--log-bin=/var/log/mysql-bin
--binlog_do_db=invenio
my_print_defaults mysqld2
--server-id=2
--ledir=/usr/sbin
--port=3308
--datadir=/var/lib/mysql_slave
--socket=/var/lib/mysql_slave/mysql.sock
--pid-file=/var/run/mysqld/mysqld_slave.pid
--log_error=/var/log/mysql_slave/error.log
--symbolic-links=0
--character-set-server=utf8
--max_allowed_packet=1G
--thread_concurrency=12
--table_open_cache=1024
--open_files_limit=4096
--key_buffer=4G
--log-bin=/var/log/mysql-bin
--binlog_do_db=invenio
--read_only=1
--relay-log=/var/log/mysql_slave/relay-bin
--relay-log-index=/var/log/mysql_slave/relay-bin.index
--master-info-file=/var/log/mysql_slave/master.info
--relay-log-info-file=/var/log/mysql_slave/relay-log.info
I try to start ...
mysqld_multi start --verbose --no-log
mysqld_multi log file version 2.16; run: vie oct 5 11:54:33 2018
Starting MySQL servers
WARNING: mysqld_safe is being used to start mysqld. In this case you may need to pass
"ledir=..." under groups [mysqldN] to mysqld_safe in order to find the actual mysqld binary.
ledir (library executable directory) should be the path to the wanted mysqld binary.
[root@desinvenio invenio]# 181005 11:54:33 mysqld_safe Logging to '/var/log/mysql/error_master.log'.
181005 11:54:34 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql_master
181005 11:54:34 mysqld_safe Logging to '/var/log/mysql_slave/error.log'.
181005 11:54:34 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql_slave
181005 11:54:34 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld_master.pid ended
181005 11:54:34 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld_slave.pid ended
However, it does not do so:
mysqld_multi report
Reporting MySQL servers
MySQL server from group: mysqld1 is not running
MySQL server from group: mysqld2 is not running
Any idea what may be happening?
Thanks in advance.
Greetings