搭建galera集群的时候,在虚拟机测试搭建,电脑关机重启后,发现宕机后的节点无法加入集群。
查看/var/log/mariadb/mariadb.log发现报错如下:
[root@controller1 ~]# tail -300f /var/log/mariadb/mariadb.log
2019-05-28 2:09:41 139686358980800 [ERROR] mysqld: Server GSSAPI error (major 851968, minor 2529639093) : gss_acquire_cred failed -Unspecified GSS failure. Minor code may provide more information. Keytab FILE:/etc/krb5.keytab is nonexistent or empty.
2019-05-28 2:09:41 139686358980800 [ERROR] Plugin ‘gssapi’ init function returned error.
2019-05-28 2:09:41 139686358980800 [Note] Server socket created on IP: ‘192.168.1.73’.
2019-05-28 2:09:41 139685977000704 [ERROR] mysqld: Can’t create/write to file ‘/var/run/mariadb/mariadb.pid’ (Errcode: 13 “Permission denied”)
2019-05-28 2:09:41 139685977000704 [ERROR] Can’t start server: can’t create PID file: Permission denied
原来是pid文件权限不够。更改文件权限
[root@controller1 ~]#chown mysql:mysql /var/run/mariadb/mariad