i have the follow error:
Loaded: loaded (/usr/lib/systemd/system/mysql@.service; disabled; vendor preset: disabled)
Active: failed (Result: exit-code) since Mon 2018-10-15 15:28:39 CEST; 1min 4s ago
Process: 14583 ExecStopPost=/usr/bin/mysql-systemd stop-post (code=exited, status=0/SUCCESS)
Process: 14554 ExecStop=/usr/bin/mysql-systemd stop (code=exited, status=2)
Process: 14136 ExecStartPost=/usr/bin/mysql-systemd start-post $MAINPID (code=exited, status=1/FAILURE)
Process: 14135 ExecStart=/usr/bin/mysqld_safe --basedir=/usr ${EXTRA_ARGS} (code=exited, status=0/SUCCESS)
Process: 14087 ExecStartPre=/usr/bin/mysql-systemd start-pre (code=exited, status=0/SUCCESS)
Main PID: 14135 (code=exited, status=0/SUCCESS)
Oct 15 15:28:39 servidor-1.localdomain mysql-systemd[14136]: ERROR! mysqld_safe with PID 14135 has already exited: FAILURE
Oct 15 15:28:39 servidor-1.localdomain systemd[1]: mysql@bootstrap.service: control process exited, code=exited status=1
Oct 15 15:28:39 servidor-1.localdomain mysql-systemd[14554]: WARNING: mysql pid file /run/mysqld/mysql.pid empty or not readable
Oct 15 15:28:39 servidor-1.localdomain mysql-systemd[14554]: ERROR! mysql already dead
Oct 15 15:28:39 servidor-1.localdomain systemd[1]: mysql@bootstrap.service: control process exited, code=exited status=2
Oct 15 15:28:39 servidor-1.localdomain systemd[1]: Failed to start Percona XtraDB Cluster with config /etc/sysconfig/mysql.bootstrap.
Oct 15 15:28:39 servidor-1.localdomain systemd[1]: Unit mysql@bootstrap.service entered failed state.
Oct 15 15:28:39 servidor-1.localdomain systemd[1]: mysql@bootstrap.service failed.
Oct 15 15:28:39 servidor-1.localdomain mysql-systemd[14583]: WARNING: mysql pid file /run/mysqld/mysql.pid empty or not readable
Oct 15 15:28:39 servidor-1.localdomain mysql-systemd[14583]: WARNING: mysql may be already dead
my my.cnf is :
[mysqld]
user = mysql
log_bin
binlog_format = ROW
innodb_buffer_pool_size = 1000M
innodb_flush_log_at_trx_commit = 0
innodb_flush_method = O_DIRECT
innodb_log_files_in_group = 2
innodb_log_file_size = 60M
innodb_file_per_table = 1
datadir = /var/lib/mysql
wsrep_cluster_address = gcomm://192.168.1.1, 192.168.2
wsrep_provider = /usr/lib64/galera3/libgalera_smm.so
wsrep_slave_threads = 8
wsrep_cluster_name = db.com
wsrep_node_name = Node1
wsrep_node_address = 192.168.1.1
default_storage_engine=InnoDB
innodb_locks_unsafe_for_binlog = 1
innodb_autoinc_lock_mode = 2
wsrep_sst_method=xtrabackup-v2
wsrep_sst_auth=“11111111e”
[mysqld_safe]
pid-file = /run/mysqld/mysql.pid
syslog
!includedir /etc/my.cnf.d
–
My SO is: CENTOS 7
i hace disabled firewall and
sellinux disabled too
the command used for wake up the master
systemctl start mysql@bootstrap.service[SUP][IMG]https://jira.percona.com/images/icons/mail_small.gif[/IMG][/SUP]